AX 2009 Change inventory valuation method from weighted average to FIFO

This question is answered

Can anyone tell me if there is a utility to accomplish this feat?  I see there is a utility to convert to standard cost.  So is there one to convert to FIFO as well?  Thanks

Verified Answer
  • First check if it is allowed to change and what rules applies to do this.

    This answer is just a suggestion, so first test in a separate environment before messing up!

    It is possible change the inventory model on your item model group.

    But you have to take care of correct postings. Except for Standard cost, you need te recalculate and close your inventory to have the appropriate costprice on the issued inventory transactions periodically. During daily postings an average cost is used for the inventory transactions. The real FIFO, LIFO or average cost will be applied by using the periodic closing and adjustment.

    Try if you can close your inventory on a given date and directly after, change the inventory model to FIFO. Then create some transactions, recalculate the transactions and see if some scenarios are working correctly.

    Again: first test, before you get in any trouble.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

All Replies
  • There is only a utility for converting to standard cost. This is introduced within AX2009 as the standard cost was newly introduced. It is a better option for "fixed purchase price" which was often used as standard cost in prior versions of AX.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • Thanks, Andre.  However, we want to change from Average Cost to FIFO.  How does one do that?

  • First check if it is allowed to change and what rules applies to do this.

    This answer is just a suggestion, so first test in a separate environment before messing up!

    It is possible change the inventory model on your item model group.

    But you have to take care of correct postings. Except for Standard cost, you need te recalculate and close your inventory to have the appropriate costprice on the issued inventory transactions periodically. During daily postings an average cost is used for the inventory transactions. The real FIFO, LIFO or average cost will be applied by using the periodic closing and adjustment.

    Try if you can close your inventory on a given date and directly after, change the inventory model to FIFO. Then create some transactions, recalculate the transactions and see if some scenarios are working correctly.

    Again: first test, before you get in any trouble.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • Thanks Andre,  I will try that in our test environment.