Negative values in inventory
How do we get rid of the small negative amounts in MYOB Accountright. Thanks
Forum Discussion
Hi MelinC,
Thanks for your post and welcome here to the Community Forum. Thank you for flagging your inquiry to us. We regret that you are having issues with the negative values in your inventory, and we appreciate your cooperation as we work to address your concern.
We do have a script that we can run over your file that should resolve this, can you please confirm the last 4 digits of your product serial number and your file ID (This can be found by going to Help >> About MYOB AccountRight). Also, please make sure to take a backup of your file before we do this.
Please do not hesitate to post again if you need help in the future.
If my response has answered your enquiry, please click "Accept as Solution" to assist other users find this information.
Cheers,
Leneth
Last 4 digits are 7410 and file ID 2. This is a server file and it is not online. Thanks
Hi MelinC
If your file is offline, you will need to either:
- send it in to MYOB or
- put it online or
- ask MYOB to send you the script or
- use FGH File Utility MYOX
Regards
Gavin
Hi MelinC,
Thank you for that information.
Regarding this matter, since your company file is offline you would need to check that if you do have any received item transactions these would need to be converted into Bills:
- Go to Inventory>>Item List>>Inventoried tab, and click to sort by On Hand (select the column heading). Ensure that no items are shown as having a negative on-hand value.
- Run the Inventory Value Reconciliation report and check to ensure that there are no invalid amounts. Invalid amounts are negative or an item that has 0 on hand but a value in Inventory.
- If there are any invalid amounts without a large number of decimals in the Quantity, then an Inventory Adjustment needs to be entered to bring it to valid values.
Please let us know if the above two causes are both checked, and no issues can be found.
Feel free to post again anytime you require further assistance.
Cheers,
LenethThank you for your response below,
There are 3 items with negative on hand values in the Inventory>>Item List>>Inventoried tab with a lot of decimal places. All of these items have a $0 balance in the Inventory Value Reconciliation report. How can we get rid of the negative amount of stock in these items?
There are no invalid amounts in the Inventory Value Reconciliation report.
Hi MelinC,
I hope everything is going well for you today. I just wanted to follow up on whether you still require assistance with the negative amounts in your company file. In case you do, since your company file is offline, please check first the above instructions to further assist you.
Feel free to post again anytime you require further assistance.
Cheers,
Leneth
