How to change the Inventory Costing Method from Average to F

jlett

How to change the Inventory Costing Method from Average to FIFO once transactions are entered?

What Navision support says :
To actually make the change, a user must make sure that all entries are closed (i.e. The 'Open' field in Item Ledger Entry Table must be unchecked) and all value has been posted to the General Ledger. To make sure all entries are closed, an entry will be made through the Item Journal as a Positive or Negative Adjustment to bring Inventory to zero remaining Quantity level and make sure that all negative Quantity entries have been properly matched against positive Quantity entries - (i.e. make sure that Quantity is 0 by Location, Variant, Serial Number, Lot Number, AND in Total). You will also want to ensure that there are no OPEN Sales Orders or OPEN Purchase Orders containing these items. These documents will not allow you to edit the Costing Method.

Once Inventory is brought to zero and all entries are closed ('Open' flag unchecked), go into the trigger code for the 'Costing Method' field of the Item table (Table 27) and comment out the following code:

Navision:

dbSELECTKEY(ItemLedgEntry."Item No.");
dbSETRANGE(ItemLedgEntry."Item No.","No."); IF dbFINDREC(ItemLedgEntry,'-') THEN
ERROR('%1 cannot be changed because\'+
'there are ledger entries for this item.',dbFIELDNAME("Costing Method"));

BUT IT S AN IDEAL SOLUTION IN A WONDERFUL WORLD.


We need in fact to change all items with Ledgers entries in few minutes.
Is somebody have a solution ?

For us, we propose to reevaluate the cost on the Revaluation Journal with the averaged cost.
Then change the costing method.
Do you agree with my solution ? :?:

johnson_alonso

My opinion is that you must close financial year first and then use revaluation journal, but there may be some topics here relates to your questions but just use the "search the forum" facility here.


au revoir,
Johnson