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

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.

Hi ArgoInt,

Thank you for your response.

I appreciate you taking the time to share your experience and feedback. I'm sorry to hear that the information provided doesn't resolve the issue. It's concerning to learn that MYOB crashed multiple times, leading you to take proactive steps such as running a backup and logging out. It seems that this has fixed and reset the system to correct the inventory value.

I sincerely apologize for any inconvenience caused by the lack of acknowledgement or response from our support team. I assure you that this is not the standard of service we aim to provide. We take your feedback seriously, and I will ensure that your experience is shared with our support team for further review and improvement.

If there's anything else I can assist you with, please don't hesitate to let me know. I'm happy to help in any way I can.

Cheers,

Princess