Changing the Costing Method

Comments

• themave Member Posts: 1,058

  2006-08-11

  Not that I recommend it, but if you are going to do it. My appoach would be to:
  
  1. Make sure you have no items on any orders still outstanding, purchase or sales orders
  2. do a negative adjustment to all items still in inventory to bring balance to zero
  3. run adjust cost item entries routine
  4. post Inventory cost to g/l
  5. verify your inventory balance is zero, and your g/l inventory balance is zero for all the items
  6. run a special processing only report made up as follows:
  
  variable Name - IT
  datatype - Table
  subtype - Item
  
  Data item is integer
  
  calcode
  
  
  It.RESET;
  It.SETFILTER("Costing Method",'FIFO');
  IF It.FIND('-') THEN BEGIN
  REPEAT
  It."Costing Method" := It."Costing Method"::Average
  It.MODIFY;
  UNTIL It.NEXT = 0;
  END;
  MESSAGE('Process complete');
  
  Once complete,
  
  do a positive adjustment for all items with the average cost you want to bring items back into inventory.
  
  Now, I haven't completely thought out all the ramifications for changing from fifo to average and how future transactions will unfold. But I leave that up to you to decide if you want to take such a drastic step
  
  We have occasionally used this method to change a few items from standard cost to specific cost. But I don't worry about that, since specific cost is linked to each individual serial number and not on historical fifo or average cost.

  0
• Kowa Member Posts: 925

  2006-08-14

  do a positive adjustment for all items with the average cost you want to bring items back into inventory.

  
  It is recommended to use new item nos. for the positive adjustment to prevent any influence between old and new costing method.

  Kai Kowalewski

  0