Saturday, September 5, 2015

AX 2012 | moving average costing method - Part 5


This is the last part of the  moving average costing method in Dynamics AX 2012. in this part we will discuss the reports which show how moving average was calculated.

If you sort transactions on the inventory value report according to transaction time, transactions are listed chronologically, and you can view the costs from a moving average perspective. This way, you can verify that the cost of a moving average product has not been changed retroactively, even though the product has, for example, been adjusted by using backdating.


In the following  2 examples, you’ll see how the cost of a product changes with the flow of business events. The two examples that follow are based on the same business events, but they are sorted differently.


  • The first example  is sorted by transaction time. With this sorting order, the business events are aligned with the moving average perspective, where transactions are listed in chronological order.
  • The second example is sorted by posting date. This sorting order shows the financial impact of the business events; however, for a product that is calculated by moving average, the calculation of the average unit cost is not reflected the way you would assume for a moving average product.
To print the inventory value report according to transaction time do the following:

1- Go to Inventory and warehouse management > Setup > Inventory > Inventory value reports to create an inventory value report setup.


2-  In the Inventory value reports form, click New, enter an ID and a name for the report, and then, in the Range field, select Transaction time. The transaction time is the actual date that the transaction is reported and the moving average cost for the product is updated.



3- Click Inventory and warehouse management > Reports > Status > Inventory value > Inventory value.


4- In the ID field, select the ID of the report that you created, Under Date interval, enter your date interval information, In the From date and To date fields, enter a date interval, and then click OK to run the report.


5- please note that there is two transaction was posted in 07/01/2015. but they appear in the report according to the transaction time (08/30/2015)


To print the inventory value report according to posted date do the following:

6Go to Inventory and warehouse management > Setup > Inventory > Inventory value reports to create an inventory value report setup.


7- Select the ID which you created in step 2 then change the range field to posting date. save and close.


8-   Repeat step 4 and 5 to print the report.


9- please note that transactions are not listed chronologically, so the two transaction was posted in 07/01/2015 is listed on 08/01/2015 as a transfer from the previous month.


The end. see you in the next series

See Also