Forum Discussion

Bryn_S's avatar
Bryn_S
Cover User
1 year ago
Solved

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
    1 year 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
1 year 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

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

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