Item quantity balances

Although the Distribution SX.e system controls inventory within the four walls of the warehouse, you can use TWL to track all items in the warehouse by location. Because all locations in which items are stored are tracked in TWL, warehouse accuracy is measured in quantity variances and item variances per location.

Warehouse accuracy is the highest priority. Certain data is anticipated by TWL, and when unexpected information is received a discrepancy is created. The goal is to correct the inventory before other errors are introduced.

The quantity balances on the TWL Configuration-Item master and the Distribution SX.e system's Product Maintain Balance Entry records are updated by the respective systems in a slightly different manner. To compare the quantities between the two systems, this table shows how to balance the quantities:

Distribution SX.e TWL
On Hand + Reserved + Unavailable On Hand
On Hand Available + Reserved
Net Available Available To Promise
Unavailable Unavailable
Committed Reserved

The unavailable balance on both systems has a one-to-one relationship, with the exception of the stock being assembled in the work center. In Distribution SX.e, the Work Center stock is included in the on hand balance. In TWL, this stock is included in the unavailable balance because this stock is considered to be work in process.

When a pick ticket is printed in Distribution SX.e, quantities are moved to the committed balance. In TWL, a pick record is created when an order is dropped to be picked. When an item is picked or packed, the quantity is moved to the reserved balance in TWL.