Cost of Sales Issue

Bryn_S

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 can happen or how to even fix it.

thanks in advance

Bryn

gavin12345

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