Transfer Order Inventory Transactions in Sage 500

Less than one minute read time.

Inventory Management provides you with a special transfer task allowing you to transfer items from one warehouse to another while tracking its progress from shipment to receipt. The transfer process consists of three steps:

  1. Enter and approve transfer orders in Inventory Management.
  2. Ship the items from the warehouse to the transit warehouse using the shipping tasks in Sales Order.
  3. Receive the items into the receiving warehouse from the transit warehouse using the receipt tasks in Purchase Order.

 

Each shipment line (tsoShipLine) will create two inventory transactions: InvtTranKey for Transfer Shipment (TranType=812), and TransitInvtTranKey for Transfer In Transit Warehouse (TranType=813).

 

Each receiver line (tpoRcvrLine) will also create two inventory transactions: InvtTranKey for Receipt from Warehouse (TranType=1112), and TransitInvtTranKey for Transfer Out Transit Warehouse (TranType=1113).

All inventory transactions will be logged in timInvtTranLog table and after committing or posting the records will be permanently stored in timInvtTran table.