(ITA) About fiscal LIFO workflow [AX 2012]

Updated: March 16, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You can use the fiscal Last In, First Out (LIFO) calculation to create a yearly report that declares the value of your inventory. The report can be used as the basis for a tax report.

To calculate fiscal LIFO, all items in stock must be set up to be included in the fiscal LIFO calculation. However, you can exclude individual items.

The calculation for the final yearly fiscal LIFO report is set up in a journal, and the report is printed from the journal. You can also create several internal reports for your own reference. These can serve as drafts for the final report.

Various methods can be used to control how the inventory and the contents of the yearly report are assessed. For example, you can set the value to a normal value or you can include work in progress in the calculation. For more information, see (ITA) About the calculation engine.

You must attach all items on the Released products list page to a fiscal LIFO reporting group to calculate fiscal LIFO. You can also exclude items from the calculation by specifying each item to be excluded.

  1. Click Product information management > Common > Released products.

  2. Double-click an item to open the Released product details form.

  3. Click the Manage costs tab.

  4. Select the Avoid LIFO calculation check box to exclude the item from the fiscal LIFO calculation.


    Items of the Service type are created when this check box is selected.

  5. Close the form.

The yearly average value of an inventory item is calculated as the financial value of purchased plus produced items divided by the current quantity. If the stock from previous years has decreased, the value of the items that remain in stock is calculated according to the LIFO principle.


Number of items

Total value



100 (EUR 10 per item)



200 (EUR 20 per item)



100 (EUR 20 per item)

At the start of 2011, you have 30 items in stock. By the end of the year, you have nine items left. The amount of stock has decreased by 21 items.

The decrease in stock is deducted in the following order, where items that were most recently added to the stock are deducted first.


Items deducted


5 (EUR 20 per item)


15 (EUR 20 per item)


1 (EUR 10 per item)

By the end of 2011, the value of the inventory is 9 X 10 = EUR 90. That is, the nine remaining items in stock have appreciated by EUR 10 per item, which is the value registered for the items in 2009.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).