modify item costing method

chad

How to modify item costing method (with existing entries-item ledger, GL, Value, etc) from FIFO to Average Costing?

chengalasettyvsrao

just block the item and create the new item, without this there is no alternative way.

1. Run the AICE batch Job

2. do the negative adjustment for that stock

3. Block the item

3. create the new item and select the costing method

4. Postive the adjustment the stock

5. Run the AICE batch job.

chad

What is AICE batch job?
what will happen to entries created during PO posting (receipt/Invoice) like item ledger entry? GL entry? Value entry....etc?
Thanks!

sendoh

It's ACIE = Adjust cost Item entries.

see NAV help on this.

jannestig

There are other ways to do this as well,

Read this one from MS about changing from AVG to FIFO

https://mbs.microsoft.com/knowledgebase ... ykzpsvsrzu

and this one discusses why not to change costing methods

https://mbs.microsoft.com/knowledgebase ... vrmxqzwvko

I have changed the costing methods for whole inventories a few times but i will only do during an upgrade process so i can control the carry over values and any adjustments.