Forum Discussion

Bryn_S's avatar
Bryn_S
Cover User
8 days ago

Cost of Sales Issue

Hi,  I have an invoice on 31/12/2024 for a total of $333.90 but when I run the P/L for December it shows total cost of sales purchases for this invoice as $117,281,240,496.78???.  Not sure how this ...
  • gavin12345's avatar
    gavin12345
    8 days ago

    Hi Bryn_S 

    I wouldn't worry about the cache on this one. Caused by a well known bug (long decimal) in AR2024. MYOB need to run a script to fix the long decimal. However this might not fix the actual transaction, they might need to manually fix that for you.

     

    How it works:

    AR2024 likely shows 0 on hand for this item on the profile tab, where as the value might be 0.01. The real on hand count however might be 3.453245E-16 (a very tiny fraction such as 0.0000000000000645324) - due to a bug in MYOB which they decline to fix. The average cost (which is used to calculate the COS for the sale) would be calculated as 0.01 divided by 3.453245E-16, giving something like 2.89583E+13 - a huge number!

     

    I suggest you get back in touch with MYOB.

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User
8 days ago

Hi Bryn_S 

I wouldn't worry about the cache on this one. Caused by a well known bug (long decimal) in AR2024. MYOB need to run a script to fix the long decimal. However this might not fix the actual transaction, they might need to manually fix that for you.

 

How it works:

AR2024 likely shows 0 on hand for this item on the profile tab, where as the value might be 0.01. The real on hand count however might be 3.453245E-16 (a very tiny fraction such as 0.0000000000000645324) - due to a bug in MYOB which they decline to fix. The average cost (which is used to calculate the COS for the sale) would be calculated as 0.01 divided by 3.453245E-16, giving something like 2.89583E+13 - a huge number!

 

I suggest you get back in touch with MYOB.

 

Regards

Gavin

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.