Inventory transactions can originate from Purchase Order, Sales Order, Manufacturing, or Inventory Management modules. Here are the tables that are inserted and/or updated when an inventory transaction is posted:
- Insert a record into the inventory transaction log table (timInvtTranLog).
- Insert a record into the inventory transaction table (timInvtTran).
- Insert one or more records into the transaction distribution table (timInvtTranDist).
- Insert one or more records into the transaction costing table (timInvtTranCost).
- Insert or update a record in the warehouse-bin inventory summary table (timWhseBinInvt).
- If item is ‘lot’ or ‘both’ tracked, insert or update a record in the inventory lot table (timInvtLot).
- If item is ‘lot’ or ‘both’ tracked, insert or update a record in the inventory lot-bin summary table (timInvtLotBin).
- If item is ‘serial’ or ‘both’ tracked, insert or update a record in the inventory serial table (timInvtSerial).
- Insert or update a record in the cost tier table (timCostTier).
- Insert or update a record into the inventory transaction history table (timInvtTranHist)
- Insert or update a record into the inventory fiscal period history table (timInvtFiscPerHist)
- Insert or update a record into the inventory calendar period history table (timInvtCalPerHist)
- Insert a record into the batch log table (tciBatchLog)
In addition, if an item has a Valuation Method of Standard Cost and the Standard Cost in Maintain Inventory does not equal the sum of the transactions calculated standard cost, a warning will be issued and Standard Cost in Maintain Inventory (timInventory.StdUnitCost) will automatically be updated with the calculated standard cost.