How to change item costing method?

HollandPoland

Hi all!
My customer needs to change item costing method from average to standard, but items have more 1 row in Item Ledger Entry. So, I read in this forum that I have Inventory=0 and every order (sales, purchase, production) close. I've that situation, but I'm not able to change item costing method. I don't close the G/L account relates this item, must I close them too?
My customer doesn't want to rename the Item and create new one again (like manual say...).

Thank you for your replies.

Alex_Chow

If you do a search on this forum, there are a ton of discussions regarding this.

HollandPoland

I read the discussions in this forum, but I don't understand good, as my customer doesn't want to rename item (he loses the statics about that item) and I want to understand how I can close the item. Is it enought to post all orders (sales, purchase and production)? I've post all orders, but I've the same message from Nav ("You cannot change costing method because there are one or more ledger entries for this item")...

Karenh

If you have a developer's license, you can comment out the code in the costing method validation trigger in the item table which checks for entries and presents an error if there are entries. You should also add code that checks that inventory is zero.

Alex_Chow

The official way from Microsoft Support:
1. Rename the item
2. Create new item with correct costing method
3. Block the old item

This is the supported method to ensure consistency for your item costing.

HollandPoland

Alex Chow wrote:

The official way from Microsoft Support:
1. Rename the item
2. Create new item with correct costing method
3. Block the old item

This is the supported method to ensure consistency for your item costing.

But, in this way do I have two kind of statistics? One about a certain cost and other in other one?

HollandPoland

Karenh wrote:

If you have a developer's license, you can comment out the code in the costing method validation trigger in the item table which checks for entries and presents an error if there are entries. You should also add code that checks that inventory is zero.

But, If I comment the code in validation trigger, how Nav involves? Will my inventory cost be real?

Alex_Chow

HollandPoland wrote:

But, If I comment the code in validation trigger, how Nav involves? Will my inventory cost be real?

Most likely no...

You would need to hire a very experienced developer to ensure the costing does not screw up if you use code.