Forum Discussion

stevenphung's avatar
stevenphung
User
9 months ago

Need script to zero out inventory

Hi,

I need the script to run over one of my client's company files to zero out unusually long decimal place or N/A inventory values that can't be done due to the error message that keeps popping up.

 

I have gone through and checked everything as per this post:

https://community.myob.com/t5/AccountRight-Sales-and-purchases/Qty-quot-On-Hand-quot-is-Zero-but-Items-List-shows-non-zero/td-p/627485 

 

These are the client file's details:

The company file is stored: online

The LAST FOUR DIGITS of the serial number: 0812
The company file ID: 7

 

Let me know if you guys need any other info. Thanks

3 Replies

Sort By
Replies have been turned off for this discussion
  • Celia_B's avatar
    Celia_B
    MYOB Moderator
    9 months ago

    Hi stevenphung,

     

    Thanks for your post and welcome to the Community Forum. 

     

    We appreciate you in providing details on the account. To help you with this, I am sending you a private message asking for more information. Kindly check your inbox. 

     

    Regards, 

    Cel

     

    • stevenphung's avatar
      stevenphung
      User
      9 months ago

      Hi Celia,

       

      Your script did not work.

       

      I have closed and re-opened MYOB again but I can still see stock items that essentially have a zero-stock balance (e.g. 0.000001) but they still appear on my 'count inventory' list.

       

      Can someone else help?

      • gavin12345's avatar
        gavin12345
        Ultimate User
        9 months ago

        Hi stevenphung 

         

        How does it appear in your Count Sheet, also how does it appear in the Items List in the On Hand column. Attach 2 images as well as advised what you see as some images are blocked by moderators. In some less common scenarios the MYOB scripts do not work.

         

        Regards

        Gavin