Sunday, August 30, 2015

AX 2012 | moving average costing method - Part 3

After we discussed the Handling of price differences between a product receipt and the invoice in part 1 and Revaluation for moving average in part 2. in this post we will discuss the Backdating with moving average.

When you backdate a product receipt or an invoice, it is revalued to the current moving average cost. Also, a backdated issue is posted at the current moving average cost. With backdating, you cannot change the moving average going forward.

Example: Backdate a transaction

In this example, you want to backdate a transaction by adding a quantity of 1, because of a receipt that happened before the current date. The current moving average cost is 15.00, and you set the price of the backdated transaction to 20.00. When you backdate the receipt, the following cost calculations occur:

  • Your inventory is updated by the quantity of 1 as of the date of the backdate, but the moving average cost remains 15.00.
  •  The additional 5.00 out of the 20.00 is expensed as of the date of the backdate.
to see the previous example in action please follow the steps:

1- Go to account parables >  Common  > purchase orders > create new purchase order with backdate

2- In the purchase order lines enter item no D0007 with quantity of 1, price 20. then confirm > go to product receipt > enter backdate in the product receipt date field to then post (make sure to select the same site warehouse that you used in part 1 and part 2) .

3- to see the voucher go to receive  > product receipt > voucher.

4- as you can see The additional 5.00 out of the 20.00 is posted to the Price difference for moving average account.

see also