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

ghamilton · 2019-09-25

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?

muca · 2019-09-27

FIFO as a default
>>>>>>>>>>>>>>>>>>
Costing Method field on Item Table is Option with following values
FIFO,LIFO,Specific,Average,Standard

For all New records (Item Cards) there first option will be set.
No Way
To set Average as default for new cards there Item Category or Item Template can help.

sometimes users forget and miss the correction.
>>>>>>>>>>>>>>>>>>>>>>>>
Without additional development I think You can not get it when You do not want to use categories or templates
but then it will work for all companies in Your database. (not a good practice)

for example....
If You have Development environment You can try to find table 27 Item -> button <Design> -> select field 21 Costing Method -> from menu View - Properties -> Find property InitValue and set it to Average -> Close all windows opened, Save and compile Table 27 Item

golfer · 2019-09-25

If you are on newer versions you can set the default in Inventory Setup. Older versions through Item Categories.

ghamilton · 2019-09-25

We are using NAV Dynamics 2017. When I look at Inventory Setup I can't where we would change it.

SanderDk · 2019-09-26

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

Kowa · 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.

ghamilton · 2019-09-26

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.

KTA8 · 2019-09-26

Look the item category configuration.

muca · 2019-09-27

FIFO as a default
>>>>>>>>>>>>>>>>>>
Costing Method field on Item Table is Option with following values
FIFO,LIFO,Specific,Average,Standard

For all New records (Item Cards) there first option will be set.
No Way
To set Average as default for new cards there Item Category or Item Template can help.

sometimes users forget and miss the correction.
>>>>>>>>>>>>>>>>>>>>>>>>
Without additional development I think You can not get it when You do not want to use categories or templates
but then it will work for all companies in Your database. (not a good practice)

for example....
If You have Development environment You can try to find table 27 Item -> button <Design> -> select field 21 Costing Method -> from menu View - Properties -> Find property InitValue and set it to Average -> Close all windows opened, Save and compile Table 27 Item

muca · 2019-09-27

P.S. LS Retail also do not manage it.

ghamilton · 2019-09-27

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..

ghamilton · 2019-09-27

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!

kriki · 2019-10-08

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

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

Best Answer

Answers

Categories