modify item costing method

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

Comments

  • chengalasettyvsrao
    chengalasettyvsrao Member Posts: 711
    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
    chad Member Posts: 25
    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
    sendoh Member Posts: 207
    It's ACIE = Adjust cost Item entries.

    see NAV help on this.
    Sendoh
    be smart before being a clever.
  • jannestig
    jannestig Member Posts: 1,000
    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.