Forum Discussion
Hi sKrael
Due to bugs in MYOB sometimes you end up with zero on hand, however a negative or positive value for that zero on hand. This is why some amounts show as N/A, as you cannot divide a value by zero.
This does indicate a form of corruption in the file and sometimes MYOB staff offer to run a script to fix it. Not your moderator though.
Try doing an inventory adjustment to change the on hand count to 1 (or higher) and the value a larger number than the negative on hand value. So for example if the negative value is -$50, set the IAJ to On Hand 1 and Value adjust by say $52. This will set the onhand count to 1 and the value to $2. Once you get to this point you can make correcting adjustments as required.
Regards
Gavin
You're a legend, that sorted it thank you gavin12345
I did a +1 inventory adjustment for just over the negative value (by 23c), then a -1 adjustment to correct the quantity and value of -23c to get rid of the N/A and the inventory item is now back to zero.
Will I need to tell my accountant, or are there any other adjustments I should make so ensure the accounts are in order relative to these adjustments?
- Sean_DC2 years agoFormer Staff
Hi sKrael,
I'm glad to know that you were able to resolve it. Thank you for the advise gavin12345. This will be helpful for other users experiencing this.
Please feel free to reach out to us again if you require further assistance.
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.