Reconcile Cost Detail to Quantity

SOLVED

Is there a utility that I can use to push the quantity of an item from the cost detail into quantity of that lot / serial in the quantities tab?

  • 0
    verified answer
    Yes, It is the Inventory Balance Utility. Go to File, Run *UTL and it will come up. But you should read up on it first. Look in the Knowledge Base
  • 0
    First run the "Balance Inventory Quantity and Cost" utility from the *utl menu. This will sync the Lifo/Fifo/Lot/Serial cost detail table with the transaction table by creating adjustment transactions. After this utility is run, you should run the "Recalculate Item History" utility from the I/M utility menu. This will use the transaction table to reset the rest of the inventory history tables.