Forum Discussion

_Zentra's avatar
_Zentra
Experienced User
3 years ago

Inventory Item List Stock On Hand Discrepancy

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. C...
  • Sam_R's avatar
    Sam_R
    3 years ago

    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
Komal_S's avatar
Komal_S
MYOB Staff

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's avatar
_Zentra
Experienced User
3 years ago

Hi Komal_S ,

 

Yes, still having same issue. Assistance would be appreciated :)

  • _Zentra's avatar
    _Zentra
    Experienced User
    3 years ago

    Hi Komal_S,

     

    Any updates on this one?

     

  • Sam_R's avatar
    Sam_R
    Former Staff
    3 years ago

    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's avatar
      _Zentra
      Experienced User
      3 years ago

      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's avatar
        Sam_R
        Former Staff
        3 years ago

        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. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.