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.
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
Hi ArgoInt,
Thank you for your post, and we apologize for the delayed response.
We hope that the information provided by Gavin will assist you in addressing your issue. You may also refer to this Help article, Making inventory adjustments, which has detailed information to assist with this. If you have any further questions or need additional assistance, please don't hesitate to ask.
We want to extend our sincere appreciation to you gavin12345, for taking the time to provide such a detailed and insightful explanation in response to our user's concern. Thank you for your continuous support.
Cheers,
Princess
Hi Princess,
Gavin only confirmed what I already suspected, so it didn't actually help with a solution.
I don't know what "fixed" my issue as I had also lodged a support message since I suspected there was a bug in our company file. After MYOB crashed multiple times I ran a back up and logged out. When I logged back in the inventory count was showing the correct value. I never received any reply or acknowledgement from the support people which I don't think is acceptable.
