Inventory Control Issues AR 2021.3
We have run full inventory control for >20 years. We have inwards stock, then build finished items in the form of Liquid Product, Jar, Lid Label for 250gm units to 30 KG units in the main, but also other types of items.
Value of stock was always checked via the Items Register report, Inventory Reconciliation report. Since we started the online version we have a problem when building an item - it does not always use the average price of the bulk fluid item in stock. The Item Register report will look correct, but when we check the item card figures via the blue arrows where there is Quantity on Hand; Current Value; Average Cost;, those figures can be significantly different and sometimes by huge amounts, and the systems uses the card values for the Autobuilds. When raised with MYOB they told us to start a new stock item number for the product, but then it can happen again. 2 Files attached show the differences at exact same point in time.
I have checked back to the old Premier v12 we ran, and that problem does not show at all. Over the years I have drilled down into how the stock works, and how to fix some issues that come along with quantities and values etc.
However, I have never seen the differences and problems we are now getting. And it makes it very difficult to get a true stock value. Is there anyone out there who has in depth knowledge of how the stock system works, and how to resolve it and/or has anyone else encountered this problem.
Look forward to some answers
Hi KatieMcL , that eliminates one possibility.
This program has been completely rewritten from the old v19 program, which can be misleading, because whilst it looks the same, the behaviour is not always the same.
You'll note from the forum that that there are quite a number of issues around inventory.
The closing qty and value balances of both the on-screen item register and the item register detail report are taken from the onhand qty/value per the item card. Then prior balances are worked out backwards.
If the closing values of the register detail report and the item register display do not agree to the item card, and there are no future dated transactions in the file (?), then you may need to have a script run over the file to correct the history. (There are a number of such scripts). A moderator can advise further.
