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 already invoiced (For production orders, it’s production order end.). Physical updated means the inventory transactions are not invoice but received or shipped. (For production order, it means material picked or production order report as finished). After understanding the two concepts, it will be easy to understand the below columns.
Inventory: Financial Quantity – the quantity that are financially updated.
Inventory: Financial Amount –the amount value of inventory that are financially updated.
Inventory: Physical Quantity Posted – the quantity that are physical updated.
Inventory: Physical Amount Posted – the amount value of inventory that are physical updated.
Inventory: Physical Quantity Not Posted –the quantity that has inventory transactions but not posted to the GL. For example, you have item model group which has the options ‘post physical inventory’ and ‘post financial inventory’ disabled. Then you have an item which linked to this item group. Then you have a purchase order, you receive it and invoice it. Then if you check the inventory value report for this item, you will see the quantity and the value in this purchase order are actually under the column ‘Inventory: Physical Quantity Not Posted’ and ‘Inventory: Physical Amount Not Posted’
Inventory: Physical Amount Not Posted – please do not include this amount when you do the inventory reconciliation because this amount is not post into G/L.
Inventory: Quantity –the total quantity of all the qty columns in the report.
Inventory: Amount – the total quantity of all the amount columns in the report. Like the note above, please do not use this column to do the inventory reconciliation if you have the ‘Inventory: Physical Amount Not Posted’ showed in the report. You need to exclude ‘Inventory: Physical Amount Not Posted’ from the total amount.
Average unit cost – total amount divided by total quantity.
How to use inventory value report: part 1
How to use inventory value report: part 2
How to use inventory value report: part 3
与本文相关的文章
- Finance and Operations (Dynamics 365) 移动应用程序将被弃用 / Finance and Operations (Dynamics 365) mobile app to be deprecated
- 在 Power Platform 管理中心管理 Finance and Operations 应用 / Manage Finance and Operations apps in the Power Platform admin center
- 通过数据湖集成解锁财务和运营数据中隐藏的洞察力 / Unlock hidden insights in your Finance and Operations data with data lake integration
- 使用 Dynamics AX 2012 R3 的俄罗斯工资单功能为我们的客户更新 / Update for our customers using Russian payroll capabilities of Dynamics AX 2012 R3
- 获取更新的工具包,以更轻松地部署解决方案特定的帮助内容 / Get the updated toolkit for easier deployment of solution-specific Help content
- 向Dynamics 365应用程序和通用数据服务同时写入自动化数据流/Dual-write automates data flow between Dynamics 365 applications and Common Data Service