Change costing method - only Opening entries

hansika

Hi All ,

I have done the positive adjustment for item opening . Actual Costing method is FIFO , but by mistake costing method was uploaded Average and posted the Opening balances. Against these items there is no other ILE 's , Open purchase orders , sales orders except those opening entries . So i need to change the costing method to FIFO . Shall i directly change the Costing method at Item Master level.

Please tell me the process.

Faithie_Robertson

Hansika,

NAV will not allow you to change the costing method once transactions are posted - even if the entries are closed.

However, a VAR can use their application designer license to allow this. It is, however, VERY TRICKY, and can lead to long term costing issues. If you're talking about only a few items, you might find it cheaper and easier to just remove all sales orders, qty. on hand, and any other connections to the item(s), block the item(s), and create a new one(s) with the proper costing method.

And...if I may, I'd suggest you have someone change your Costing Method field on the item table to have an InitValue property of FIFO if you want to always use FIFO. That sets it to FIFO without a user having to remember to do so. (Just be sure they document the change in the table. Property values populating fields is hard to find otherwise.)

dans

Faithie Robertson wrote:

If you're talking about only a few items, you might find it cheaper and easier to just remove all sales orders, qty. on hand, and any other connections to the item(s), block the item(s), and create a new one(s) with the proper costing method.

the way to go :thumbsup:

pantula2000

Since you say these are opening entries i presume it is a new implementation.

Suggest you go to the respective tables (82, 5802 etc) and remove all the data with your developer license and then change the costing method for the Items and reimport the data.

Regards,

Sridhar

jflynn

We just had the same issue and renaming the item worked much better for us. We already had that item published in our catalogs. We just renamed it to something out of our norm, blocked it, and recreated the original item number.