Skip to content
Dynamics 365 Blog
janna wang avatar

janna wang

Posts

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...

Read more

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. Financial updated means the inventory transactions are...

Read more

  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...

Read more

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. For example, you can create the report only showing the total...

Read more

Normally, we use inventory value report to view the inventory value and quantity. Sometimes, we cannot see some inventory dimensions in the report. To make the inventory dimensions showing in the report, you need to make sure: 1) Go to USMF/Inventory management/Setup/Inventory/Inventory value reports, select the inventory value report ID which you use to view...

Read more