Forum Discussion

Jenny-Accounts's avatar
Jenny-Accounts
Experienced Cover User
5 years ago

Qty "On Hand" is Zero, but Items List shows non zero value -4.44089209850063E-16

Can't create a purchase in MYOB AccountRight Premier AU 2019.4.0 for a particular inventory item.  AccountRight times out, and shuts down. 

 

After Investigation of the inventory item, I see it has a zero value on stock when viewing the Item Card, and this is what it should be. 

 

However, when you view the item under "Items List", you see there is a nonsense value of -4.44089209850063E-16.  See first attachment.  I have reviewed the Inventory Registry history for this item, and see no issue, see second attachment.

 

How do I correct this issue, so I can put stock on this code that we have purchased?

 

Thanks

  • Steven_M's avatar
    Steven_M
    5 years ago

    Hi Jenny-Accounts 

     

    Thank you for providing that information.

     

    I've arranged for a script to be run over the company file from the cloud that has been known to aid clients with a similar situation.  We do recommend just closing down and reopening the company file.

     

    Do let us know how you get on and if you require further assistance.

  • Hi Jenny-Accounts 

     

    We do have a script in which can run over company files that are showing unusually long decimal place or N/A inventory values or a negative inventory message when changing the preferences. Just before we do arrange for that we need for you to check the following:

    Please note that if you do have any receive item transactions these would need to be converted into Bills before this process.

    • Go to Inventory>>Item List>>Inventoried tab, click to sort by On Hand (select the column heading). Ensure that no items are showing as having a negative on hand value.
    • Run the Inventory Value Reconciliation and check to ensure that there no invalid amounts. Invalid amounts being a negative or an item that has 0 on hand but a value in Inventory

    If those options are fine and you don't have any negative values we can arrange for the script to be run: For us to do this we need to confirm the following details:

    • Where the company file is stored i.e. online or local
    • What the LAST FOUR DIGITS of the serial number is - Setup>>Company Information
    • What is the company file ID - Help>>About AccountRight
    • Jenny-Accounts's avatar
      Jenny-Accounts
      Experienced Cover User

      Hello Steven_M

       

      Thank you for your prompt reply.   See my response to your questions below:

       

      “Please note that if you do have any receive item transactions these would need to be converted into Bills before this process.”   No, presently there are no orders in our system, which show inventory as 'received'

       

       

      “Go to Inventory>>Item List>>Inventoried tab, click to sort by On Hand (select the column heading). Ensure that no items are showing as having a negative on hand value.”  No items are showing as negative “on hand” value in “On Hand” column.

       

      “Run the Inventory Value Reconciliation and check to ensure that there no invalid amounts. Invalid amounts being a negative or an item that has 0 on hand but a value in Inventory”  Inventory Reconciliation Report has been run, and checked, there are no negative amounts, nor are there any items with 0 on hand showing a non-zero value, even the problematic inventory item I report in thus support issue here is showing as a 0 quantity on hand, and a 0 value.

       

      “Where the company file is stored i.e. online or local”  Stored ONLINE

       

      “What the LAST FOUR DIGITS of the serial number is”6536”

      • Steven_M's avatar
        Steven_M
        Former Staff

        Hi Jenny-Accounts 

         

        Thank you for providing that information.

         

        I've arranged for a script to be run over the company file from the cloud that has been known to aid clients with a similar situation.  We do recommend just closing down and reopening the company file.

         

        Do let us know how you get on and if you require further assistance.