Inventory value report was released from AX 2009 SP1. It’s a very powerful report. Most of the users uses this report to do reconciliation between general ledger and inventory. In this article, we will discuss how to use this report to do the reconciliation between general ledger and inventory.
When we try to view inventory report, we need firstly define the below parameters. Let’s firstly explain the Date interval parameter. The ‘Date interval code’ is used when you want to view the predefined period instead of giving the ‘From date’ and ‘To date’. For example, if you select ‘current period’ in this parameter, AX will calculate the ‘From date’ and ‘To date’ based on the current AX session date. Let’s say the current AX session date is Jan 13 2017, then the ‘From date’ is Jan 1 2017 and the ‘To date’ is Jan 31 2017. If you don’t use date interval code, you can manually filling the ‘From date’ and ‘To date’ based on your need. Actually, ‘From date’ doesn’t change the report figures as the report will calculated the inventory value/quantity and GL balance cutting off on the ‘To date’.
There is one known issue. When you select the same date for both ‘From date’ and ‘To date’ and also enable ‘include beginning balance’ option in inventory value report ID, you may get incorrect beginning balance. This is a by-design scenario.
All the filters in the ‘inventory value’ section will be applied to the inventory transactions but not the G/L balance. So, when you try to use these filters, please keep this in mind. Otherwise, you may see the discrepancy between inventory and G/L account which is caused improper usage of the filters. This topic will be discussed furtherly in the following parts.
In Part 2, we will discuss how to create the most import parameter: inventory value report ID.