Forum Discussion

ArgoInt's avatar
2 years ago

Inventory Count Error in Items Register - System does not agree with report.

Hi,

 

I'm using the desktop version of Accountright and have an issue with the count in the Items Register window showing a different on hand figure from the Items Register report. The system is showing a nil balance when the report shows 25 items (which is the correct amount). I noticed that the first entry after the nil opening balance is a purchase of 60 items but the count shows 35 on hand?

 

I need this fixed urgently to get an invoice out to a customer.

 

  • Hi ArgoInt 

     

    There are a number of issues (aka bugs) in the Inventory module. The Items Register and Details reports often show misleading on hand counts and values, esp if you use multiple inventory locations.

     

    Check the Item Profile tab, this usually shows the correct on hand count, as does the Inventory Value Reconciliation Report. You should be able to process a sale invoice provided these show an on hand count that exceeds the invoice sale count. If MYOB does not allow you to process, check the on hand count at the location you are using - you may need to transfer. 

     

    If you are not using locations and sale still won't go through, attach some screenshots that show the details as well as the message you are receiving.

     

    Regards

    Gavin

    • ArgoInt's avatar
      ArgoInt

      Hi Gavin,

       

      To reply to you comments below.

       

      The item only has one location.

      Profile tab is showing incorrect on hand balance. It is only the report that is correct.

      We only order what we need to invoice so don't hold a balance of this item (ie a purchse entry is followed by a sale) so I can't "transfer" any product.

       

      For this item the opening count is nil followed by a purchase of 60 units. So you would think that the items on hand would show as 60. Unfortunately the on hand figure after the purchase is showing as 35 and not 60, hence being unable to enter my invoice.  

      • gavin12345's avatar
        gavin12345
        Ultimate User

        Hi ArgoInt 

         

        My apologies, when I wrote:

         

        "Check the Item Profile tab, this usually shows the correct on hand count, as does the Inventory Value Reconciliation Report." - I meant that these are the amounts being used by MYOB, not that they are correct or show what they should show. So when reports differ to these amounts, the reports are 'wrong' and should be ignored. When the profile tab and IVR show amounts that don't agree with physical on hand amounts and value - they need to be adjusted by the user.

         

        It is likely that before your Purchase, the on hand count for this item showed as - 25. This is the bit that was likely caused by a bug in MYOB. When a previous transaction was edited/reversed/deleted etc, MYOB failed to update the amounts correctly, resulting in the negative on hand amount.

         

        Best way to correct this is to process an Inventory Adjustment Journal to adjust the on hand count and the value to the amounts they should be. If not sure how, there are article in the Support section on this.

         

        Regards

        Gavin