<Solved> How do I reset our Costing Method from FIFO to Average Cost?

ghamiltonghamilton Member Posts: 6
edited 2019-10-08 in NAV Three Tier
When setting up our retail items, the Costing method is defaulting to FIFO rather than the original setup of Average. Where do I change that default?

Best Answer


  • golfergolfer Member Posts: 80
    edited 2019-09-25
    If you are on newer versions you can set the default in Inventory Setup. Older versions through Item Categories.
  • ghamiltonghamilton Member Posts: 6
    We are using NAV Dynamics 2017. When I look at Inventory Setup I can't where we would change it.
  • SanderDkSanderDk Member Posts: 362
    Hi Ghamilton,
    Do you want to change the Costing method of current item or just on new item?
    If on new items, how to you create Item (Ex. with a template)

    If you want to change Costing Method on current item, you can change the Costing Method on the item card (With a tiny report), but fair warning you do not "just" change cost method.
    If you change the costing method without consulting with a finance specialist you can end destroying your your data.

    Some country also have rules about how your are allow to change costing method, ex. some places you will need the company's board's approval before hand
    For help, do not use PM, but use forum instead, perhaps other people have the same question, or better answers.
  • KowaKowa Member Posts: 889
    edited 2019-09-26
    ghamilton wrote: »
    We are using NAV Dynamics 2017. When I look at Inventory Setup I can't where we would change it.
    The field for the default value was introduced there in NAV 2018.
    Kai Kowalewski
  • ghamiltonghamilton Member Posts: 6
    First of all, thanks very much to everyone who offered help on this issue! It truly is appreciated.

    Perhaps there is a difference between our LS Retail version of NAV 2017 from what you are referencing.

    What I feel I should find is a default New Item template that is used to create default values on new item setup.

    We don't use category templates, nor is there is a reference on the store card. Somewhere, Average has changed to FIFO as a default. We must always correct the costing method when setting up new items, but sometimes users forget and miss the correction.
  • KTA8KTA8 Member Posts: 301
    Look the item category configuration.
  • mucamuca Member Posts: 42
    P.S. LS Retail also do not manage it.
  • ghamiltonghamilton Member Posts: 6
    Thank you Muca for the definitive answer! It looks like we will need to proceed with the use of category templates to resolve the issue.

    Again, thanks to everyone for your assistance with this sticky issue..
  • ghamiltonghamilton Member Posts: 6
    As a follow-up - I updated the init_value of the Costing-Method(Item) as Muca suggested and the problem was resolved instantly. Thanks again!
  • krikikriki Member, Moderator Posts: 8,902
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2020: 19 & 20 November 2020, Antwerp (Belgium)
Sign In or Register to comment.