Inventory Item List Stock On Hand Discrepancy

[_Zentra]

Hi There,

Just have an issue where the Item List is showing On Hand value that is incorrect. Please see below steps I have taken to check stock discrepancy and also how I have tried to resolve. Can you review and advise how to fix this accordingly?

Item List shows incorrect stock on hand:

Quantity on Hand is correct if you look within the item itself:

Item Register is also correct:

Item Summary Report is correct:

I have also tried adjusting in a quantity of 3 (which did show correctly as 3 on hand in the item list) and adjusting out but still reverted back to 2.2200…etc

Are you able to advise how to fix this issue? We have at least three codes that are affected that I am aware of:

Any assistance would be appreciated

[Komal_S]

Hi @_Zentra 

Sorry that nobody has offered their assistance with regards to your query yet. Please let us know if you still need assistance with this. 

[_Zentra]

Hi @Komal_S ,

Yes, still having same issue. Assistance would be appreciated

[_Zentra]

Hi @Komal_S,

Any updates on this one?

[Sam_R · Accepted solution]

Hi @_Zentra,

Thank you for your post and patience.

From looking at your screenshots, this may need a script run over the filet to correct it. However, before I run the script over your file you will need to check if you have any receive item transactions, these would need to be converted into bills before this process. Also please check the following:

• Please go to Inventory > Item list > Inventoried tab > Click to sort by on hand (Ensure that no items are showing as having a negative on-hand value) 
• Also please run the Inventory value reconciliation report (Reports > Inventory) and check to see ensure that there are no invalid amounts. (This being a negative or an item that has 0 on hand but a value in inventory)

Once you have checked this and the above is fine please send me a private message with the following details:

• Serial number 
• Business name 
• File ID with the issue (this can be found by going to help > About MYOB AccountRight

[_Zentra]

Hi @Sam_R ,

Issue has recurred:

Two things:

1. Can you fix this one?

2. How does this occur so we can't prevent it from happening again?

Thanks!

[Sam_R]

Hi @_Zentra,

Thank you for letting me know. 

I have just run the scirpt over your file again to correct this (you may need to close and reopen your software).

Our teams are still looking at a permanent fix for this, however, the script is the only solution we have this stage.

Please reach out if I can assist with anything else.