Armanino Blog

Resolving the Physical Inventory by Inventory Dimension Report in Dynamics AX 2009 and 2012

September 20, 2013

At first glance there appears to be a discrepancy between the Physical Inventory on the Inventory On Hand form and the amount displayed on the report Physical Inventory by Inventory Dimension. This has caused a bit of confusion for some AX clients.

In AX 2009, to view the report, you can go to Inventory Management > Reports > Status > Physical inventory > Physical inventory by inventory dimension.

You can resolve the quantities in the report to the quantities in the On Hand form by noting the Picked and Registered quantities on the Physical Inventory by Inventory Dimension Report.

In AX 2009, on the Inventory On Hand form (Inventory Management > Inquiries > On-hand) the Physical Inventory amount takes into account any Picked and/ or Registered amounts. If there is an amount picked, it will decrement the on hand quantity by the picked amount, and if there is an amount registered it will increment by that amount. In the Physical Inventory by Inventory Dimension Report, the On Hand quantity does not take into account the Picked and Registered amounts, causing the discrepancy.

In order to resolve the two sources of information, there are parameters on the Physical Inventory by Inventory Dimension Report where you can specify that you wish to see the Picked and Registered amounts. See our example below:

Inventory 1

The output will show any picked or registered amounts. In this example, notice that the On hand amount in the report is 321 where the Physical inventory amount is 316 in the Inquiries > On-hand form. In this example, opting to display the Picked and Registered amounts makes it possible to resolve the difference, since 321 less 5 is 316.

Inventory 2

The report received some improvements in AX 2012, and the path there is Inventory and Warehouse Management > Reports > Status > Physical Inventory > Physical inventory by inventory dimension. The report automatically reports on Picked and Registered amounts so that you do not have to remember to specify the parameters as in AX 2009, and the report displays the On Hand amount after consideration of the Picked and Registered amounts. This way, the report ties out much more clearly with the On Hand form (Inventory and warehouse management > Common > On-hand inventory).

Inventory 3

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
Costco Travel Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022