Need assistance with an inventory adjustment
We've an issue where we can't make an inventory adjustment and I can't figure what's going on/wrong. I can't isolate where I unit cost has been pulled from. Would appreciate any assistance. ...
Forum Discussion
When keying a Inventory Adjustment, I believe the "cost per unit" is the "Average Cost" that is displayed on the Item Profile (3rd figure down on the righthand side). This figure shown is excluding any GST.
What can go wrong is that the Average Cost goes beyond 2 decimal points in the background (that we can't see) and therefore throws up an error if the adjustment removes all stock back to a nil on hand. For example 2 units with average cost of $20 each may actually have a background value of $20.000055, therefore when you do your adjustment there is still $0.000055 of value. The same can occur with the Qty (profile page states 2.00 in stock but in the background it may be a quantity of2.0000033.
Unfortunately MYOM have not yet come up with a solution to fix this other than getting MYOB support to run a script over your file (to remove excessive decimal places) prior to keying such adjustments.
Hope this helps!
