Question Status

Verified
RCarlson asked a question on 27 Mar 2013 9:02 AM

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

Reply
Verified Answer
André Arnaud de Calavon responded on 6 Apr 2013 1:28 PM

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.

Reply
Suggested Answer
André Arnaud de Calavon responded on 3 Apr 2013 2:07 PM

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.

Reply
Suggested Answer
André Arnaud de Calavon responded on 3 Apr 2013 2:07 PM

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.

Reply
RCarlson responded on 3 Apr 2013 7:43 PM

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

Reply
Verified Answer
André Arnaud de Calavon responded on 6 Apr 2013 1:28 PM

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.

Reply
RCarlson responded on 7 Apr 2013 11:11 AM

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

Reply