Inventory Reconciliation

[Mapleloor]

I am having trouble getting my inventory to balance and also entering a credit note for items that we incorrectly charged in December as it is saying that is has a zero balance.  The item in question also has a (-) value of 817.74 in the reconcilliation before I have done any transactions for this item.  I have run a detail item transaction report back to 1/7/2020 and there are no transactions on this item before 13/10/21.  Yet if I run a reconciliation report for 1/9/21 it is showing the item with the negative value above.

[gavin12345]

Hi @Mapleloor 

Unfortunately MYOB's inventory module is a little like that - unreliable - you will see posts all over the forum with different un-explainable examples. Sometimes it picks up figures randomly and then creates astronomically high COGS amts or on hand Values (into the millions!). 

From personal experience I would say the bulk of the errors are caused by editing or deleting invoices/bills. MYOB incorrectly updates things in the back end.

It is essentially up to the user to manage and control inventory. 

The only solution I can suggest is to record an Inventory Adjustment Journal to set the SOH and Value to what it should be today.

Regards

Gavin