Forum Discussion

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
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

Ultimate User

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

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
  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
  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
  - GMW
    Cover User
    12 months ago
    Thank you gavin12345 & Leneth_A .