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

thanks in advance

Bryn

  • 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

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    8 days ago

    Hi Bryn_S,

     

    It's quite unusual to see such a large amount for the cost of sales purchases on your profit and loss report. First, try clearing your AccountRight cache, as this can sometimes fix odd behavior. 

     

    If the issue continues after clearing the cache, we will need to look further into the specific invoice transactions and reports to find the root cause of the discrepancy. You can reach out to our support team on live chat through our virtual assistant MOCA or submit a support ticket via MyAccount.

     

    Cheers,

    Princess

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.