Change Costing Method from FIFO to Average Costing

Not Answered This post has 0 verified solutions | 1,612 Views | 2 Replies | 1 Follower

9 Posts
54 Points
Joined: 2013-4-18
Last Online:
2013-8-7 9:34
Location: Manama, Kingdom of Bahrain
Sujith posted on 2013-5-16 16:56 rated by 0 users


I am using Ms. Dynamics Nav 2009 R2 and my costing method followed currently is FIFO for my inventory and I want to change this to Average Costing.

When I try to change it shows the below error: You cannot change Costing Method because there are one or more open ledger entries for this item.

How can I change the Costing Method? Kindly help


All Replies

31 Posts
279 Points
Joined: 2011-8-12
Last Online:
2015-6-25 14:51
Location: ...


there are several thread available in the forum where you can find interesting tips,

I strongly advise you to make a test db and test.


Microsoft suggest the following steps:
1. negative adj the item to zero. 
1a. make sure there are no partial po / so / to. 
2. run ACIE. 
3. renumber the item and block. 
4. create new item. 
5. positive adjust inventory

6. run ACIE


If you don't want create new items you can try:

1. negative adj the item to zero. 
1a.. make sure there are no partial po  /so / to
2. run ACIE. 
3. change item cost (via sql) 
4. positive adjust inventory

5. run ACIE


Good luck!

  • | Post Points: 6
3,577 Posts
48,351 Points
Joined: 2006-4-10
Last Online:
2016-2-7 16:09
Location: Thailand / Pune India

It is showing message because you are trying to change the costing method for those item which is having inventory .IF you want to change the method then system will automatically adjust the cost according to new method



Don't forget to  the post(s) that solved your problem

  • | Post Points: 5
Page 1 of 1 (3 items) | Get this RSS feed