Post-live quantity update differences
Distribution SX.e and TWL quantities are updated at different times during processing cycles. These transactions cause temporary out-of-balance conditions, which are resolved after the transaction is completely processed. This table shows the type of transaction and the resulting discrepancy and resolution:
Type of Transaction | Discrepancy and Resolution |
---|---|
Processing Errors | Received purchase orders and warehouse transfers, shipped orders, and stock adjustments that contain errors cannot be updated by their respective processing function. This is even though TWL has already been updated. An out-of-balance condition exists until the error is corrected and the processing function updates Distribution SX.e. |
Purchase order receipts | Stock partially or completely received in TWL has not been processed through the WL Entry Batch Receiving Report, or an open receipt transaction causes an out-of-balance condition. |
Purchase order returns | Vendor returns that are on hold in WL Transaction Inquiry cause an out-of-balance condition until you release them and complete the processing. |
Warehouse transfer shipments | When you ship a transfer, inventory is released by TWL. There is an out-of-balance condition until you generate the WL Entry Batch Shipping Report to reduce the Distribution SX.e inventory. |
Warehouse transfer receipts | When you receive a warehouse transfer, the inventory balances are updated in TWL, but the Distribution SX.e balances are not updated until the WL Entry Batch Receiving Report is generated. |
Orders picked | When you print a pick ticket in Distribution SX.e, reserved 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 by TWL. If you assign lot numbers when you enter the order, the committed lot quantities are included in the total quantity calculation. |
Orders shipped | Inventory is reduced by Distribution SX.e when an order is invoiced. Inventory is reduced by TWL when an order is shipped. An out-of-balance condition exists until you run the WL Entry Batch Shipping Report and invoice an order. |
Customer returns | When the warehouse receives the returned merchandise in TWL, inventory is updated. This does not occur in Distribution SX.e until the order is invoiced. |
Counter Sales (CS) orders | Inventory is committed by Distribution SX.e when the order is printed. The order is downloaded by Distribution SX.e when the order is invoiced. The inventory is considered by TWL to be available for sale until the downloaded order is received by TWL. |
Inventory used for kitting | If stock has been moved to the TWL work center for fabrication, that stock is included in the unavailable balance. The status is work-in-process, because the stock is not available for sale. In Distribution SX.e, this stock is included in the on hand, reserved or committed, balance. |
Unavailable inventory | If stock has been moved to the TWL work center for fabrication, that stock is included in the unavailable balance. The status is work-in-process, because the stock is not available for sale. In Distribution SX.e, this stock is included in the on hand, reserved or committed, balance. |
Stock adjustments | Stock adjustments that are in WL Transaction Inquiry waiting for the WL Entry Batch Adjust Inventory Report to update inventory and General Ledger cause an out-of-balance condition. |