Negative values in inventory

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

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

Thank 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,  
 
Thank you for checking the above instructions. 
 
To investigate this further, I will be sending a private message to you requesting the necessary details. To access this, please click on your forum display picture in the top right-hand corner of your screen, then choose the envelope icon that appears. 
 
 
Let me know if you have problems with this. 
 
Cheers,   
Leneth

Hi MelinC, 
 
I trust your day is going well. I wanted to check whether you still need assistance with the negative values in your inventory. If so, I've sent you a private message, requesting additional information to investigate this matter further. 
 
 
Let me know how this goes and if we can provide any further assistance here on the forum. 
 
Cheers,   
Leneth

Hi MelinC, 
 
Thank you once more for raising your inquiry. We previously asked for more details regarding your inquiry, but we haven't received a response from you. We will be closing this thread now. Should you encounter any future issues, please don't hesitate to start a new post, and our moderators will be ready to assist you.
 
 
Cheers,   
Leneth