Forum Discussion

GMW's avatar
GMW
Cover User
12 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 ...
  • gavin12345's avatar
    gavin12345
    12 months ago

    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

gavin12345's avatar
gavin12345
Ultimate User

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
12 months ago

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
    12 months ago

    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
    Former Staff
    12 months ago

    Hi GMW, 
     
    Thanks for your post and welcome here to the Community Forum. We apologize for any difficulties you are experiencing to resolve your concern and we appreciate your patience during this time. 
     
    To investigate this further with you, I will be sending a private message to you requesting the necessary information. Please access this by clicking on your forum display picture in the top right-hand corner of your screen, then choose the envelope icon that appears. 
     
     
    Please let me know if you need further help. 
     
    Cheers,   
    Leneth

      • Leneth_A's avatar
        Leneth_A
        Former Staff
        11 months ago

        Hi GMW, 
         
        You're most welcome. I received your private message, and I am now checking it further on our end. We appreciate your patience while we check on this. 
         
         
        Cheers,   
        Leneth

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.