Forum Discussion

GMW's avatar
GMW
Cover User
8 months ago

Corruption in the MYOB account right file

There is a corruption in the MYOB account right file. It appears a credit note is causing the glitch / corruption and is showing incorrect reporting figures to the value over $3 trillion.

 

What is the fix to the above issue?

I lodged a support case on 06/11/2023 and I was advised by MYOB support staff that I "will need to upload a backup of your company file for investigation. The team will repair the backup copy and return it to you for review and can choose to restore that company file backup locally to review it".

 

Need to know how my data file can be repaired. 

  • Hi GMW 

     

    There have been numerous forum posts about this issue Your file has one or more items with a minuscule on hand count (like 4.7878761229E-23) and a positive on hand value. Say the item on hand value is $10 and you have 4.7878761229E-23, this gives a average cost of millions or trillions. So when you sell some of these, the COGS figure is ridiculous. 

     

    If your file is online, MYOB have scripts that can set the on hand count to 0 instead of 4.7878761229E-23. This will prevent re-occurrence. The transaction itself may need to be manually repaired.

     

    If you are unable to get timely help from MYOB, try FGHTables, they repair both myo and myox files.

     

    Regards

    Gavin

7 Replies

  • Hi GMW 

     

    There have been numerous forum posts about this issue Your file has one or more items with a minuscule on hand count (like 4.7878761229E-23) and a positive on hand value. Say the item on hand value is $10 and you have 4.7878761229E-23, this gives a average cost of millions or trillions. So when you sell some of these, the COGS figure is ridiculous. 

     

    If your file is online, MYOB have scripts that can set the on hand count to 0 instead of 4.7878761229E-23. This will prevent re-occurrence. The transaction itself may need to be manually repaired.

     

    If you are unable to get timely help from MYOB, try FGHTables, they repair both myo and myox files.

     

    Regards

    Gavin

    • GMW's avatar
      GMW
      Cover User

      Thank you for identifying the root cause of my problem Gavin. I am extremely grateful you were able to explain how this occured, how to avoid future occurances and a third party contact that could repair our file. 

       

      You are spot on with you explanation that our online file has one or more items with a minuscule on hand count (like 4.7878761229E-23). You mentioned that MYOB have scripts that can set the on hand count to 0 instead of 4.7878761229E-23 as this will prevent re-occurrence. Is this something only MYOB can do or is this a process I can do from time to time myself if I notice more of these miniscule on hand counts appear?

       

      I've been riddled with so much stress over the last few weeks as I was in the dark on whether or not our file could be repaired. Thank you so much for your insight and knowledge Gavin.

       

      • gavin12345's avatar
        gavin12345
        Ultimate User

        Hi GMW 

         

        User attempts to fix this usually fail, specialist software or a custom script is required. While the file is online only MYOB can run the script. If the file is offline, FGHTables have a tool allowing user to fix this themselves, however there is a fee to use the tool. However it will not fix transactions affected by the issue such as your screenshot shows.

         

        Regards

        Gavin

  • Leneth_A's avatar
    Leneth_A
    MYOB Moderator

    Hi GMW
     
    Thank you again for bringing your inquiry to us. We're pleased to offer support through private messages. This thread will now be closed. If you have any further issues, don't hesitate to start a new post, and our moderators will assist you.
     
     
    Cheers,   
    Leneth