Physical Inventory by Dimension report has lines that are not physically in stock but have an amount remaining

Question Status

Melissa Ingram asked a question on 24 Jun 2013 9:31 AM

We are having an issue with the system not closing out inventory lines. We are on AX 2009 and have serialized items that use weighted average for the model group.  For example, when we run the close in one of the companies, the phyiscal inventory by dimensions report shows that there are 593 units on-hand in stock which is correct, but it also shows 4000+ serials that are not physically in stock, the financial quantity = 0, but there is an amount left over so the line does not close.  We run the 2 reports prior to the close and run the recalc after, we run the total specification, at 100 maximum throughputs and a minumum throughput adjustment of 1 but these records remain on the report which indicated to me that these lines are not closing properly.  What process or step are we no doing as these reports jsut keep growing?

Thank you for your time,


Brandon Wiese responded on 24 Jun 2013 2:40 PM

Can you post how your dimension groups are setup?  Specifically, your physical and financial inventory dimension structure?

Melissa Ingram responded on 26 Jun 2013 4:40 AM

For serialized items : the site, warehouse, location, and serial number are active, for site the following are checked: mandatory, primary stocking, physical inventory, financial inventory, coverage plan by dimension

for warehouse: same as site except warehouse is not mandatory, for location and serial number: only physical inventory is checked.

For non-serialized items: site is the same, warehouse is the same except that financial inventory is not checked, location is the same, and serial number is not checked