Forum Discussion
- gavin12345Ultimate User
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
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.
- gavin12345Ultimate 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
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.