In this part, we will discuss how to use inventory value report to do inventory reconciliation. Firstly, let’s imagine a company who has two item groups: Bike and Accessory. The inventory GL account for Bike is 140100. The inventory GL account for Accessory is 140200. Then we have a total GL inventory account 149999.
In this part, we will discuss the columns’ meaning showing in the inventory value report after you create the inventory value report ID. For how to set up the inventory value report ID, please click here. In AX, there are two import conceptions, financial updated and physical updated.
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.
In this part, we will discuss the most import parameter: inventory value report ID. You can go to Inventory management/Setup/Costing/inventory value reports to create IDs. (In AX 2009, the menu path is Inventory management/Setup/inventory value). You can create different IDs for different reporting requirement.
