Inventory Balance Reconciliation
Hi I am trying to reconcile my inventory and for some unknown reason it is starting off in a negative, does anyone know how I can fix it?
Forum Discussion
Hi Lisa
I have done what you have suggested and as you can see from the attachment the current value of the first line is wrong which is throwing out the rest of the figures - do you have any tips or solutions for this?
Much appreciated
K
Hi Cypruspine
Unfortunately you are seeing another example of one of the many bugs in the quite unreliable inventory system in MYOB. Based on observations and posts from other users, most problems stem from editing or deleting an invoice or other inventory related transactions. MYOB simply does update things correctly and throws all the figures out.
Have a look at this post here as an example, including how the user 'solved' the problem. Editing the transactions (as you seem to have done) causes MYOB to re-do the COGS calcs based on the 'current' values. This is likely why all you figures now show same COGS. It is important to correct the 'current' values before editing all trans.
There are no easy solutions or fixes here. In a recent update MYOB tried to fix some of the issues, however this seems to have caused other problems with inventory. All you can do is do an inventory adjustment journal to set the correct On Hand Count and On Hand Value, so that going forward MYOB will use the correct figures, at least until the next time it messes the values up.
Regards
Gavin
