Forum Discussion

GMW's avatar
GMW
Cover User
6 months ago
Solved

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.   Phone s...
  • gavin12345's avatar
    gavin12345
    6 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
6 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

  • GMW's avatar
    GMW
    Cover User
    6 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
      6 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
      MYOB Moderator
      6 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