Balancing buckets
The WL Inventory Balance Report uses buckets to separate the different stages an item progresses through as a transaction is processed. These buckets determine whether quantities in TWL and Distribution SX.e are out of balance. This table defines the buckets that print on the report:
Bucket | Contents |
---|---|
A | Warehouse transfers that were shipped from a TWL warehouse, passed through the interface, but could not be processed in the WL Entry Batch Shipping Report. Therefore, the Product Warehouse Product Setup balances and General Ledger have not been updated. These transactions remain in WL Transaction Inquiry in error status. Correct the problem and set the status to active so the WL Entry Batch Shipping Report can attempt the updates again. |
B | Warehouse transfers that have been shipped from a TWL warehouse and are waiting to be processed in the WL Entry Batch Shipping Report. These transactions could potentially show in bucket 'A' if the WL Entry Batch Shipping Report detects errors during the update process. |
C | Orders that were shipped in Distribution SX.e, but have not been invoiced. This excludes Corrections (CR) orders. Inventory quantities and General Ledger balances are updated by Distribution SX.e when the orders are processed in the Sales Entry Invoice Processing Report. |
D | Orders that were shipped in TWL but contained errors. The WL Entry Batch Shipping Report could not update inventory quantities or the General Ledger because of the errors that were encountered during the report run. These transactions remain in WL Transaction Inquiry in error status. Correct the problem and set the status to active so that the WL Entry Batch Shipping Report can attempt the updates again. |
E | Orders, including loaded orders, that were shipped in TWL and have an active status in WL Transaction Inquiry and are waiting for the WL Entry Batch Shipping Report to pick them up. These transactions could potentially show in bucket 'D' if the WL Entry Batch Shipping Report detects errors during the update process. |
F | Purchase orders that were partially or completely received in TWL, but the receipt transaction (RT) is still open. After you close the RT, the WL Entry Batch Receiving Report updates inventory and General Ledger. This bucket might also contain customer returns that have been received. It may include line items that were added during receiving, but the carton has not been shipped. After you ship the carton, the WL Entry Batch Shipping Report picks up the order and you can invoice the order. |
G | Purchase orders that were received in TWL but contained errors. The WL Entry Batch Receiving Report could not update inventory quantities or the General Ledger because of the errors that were encountered during the report run. These transactions remain in WL Transaction Inquiry in error status. Correct the problem and set the status to active so that the WL Entry Batch Receiving Report can attempt the updates again. |
H | Return Merchandise (RM) purchase orders that are in WL Transaction Inquiry with a hold status waiting to be released. Then, the WL Entry Batch Receiving Report can complete the processing and update inventory and General Ledger. |
I | Purchase orders (POs) that were received in TWL. POs that have an active status in WL Transaction Inquiry. These POs are waiting for the WL Entry Batch Receiving Report to pick them up to update inventory and General Ledger. |
J | Stock adjustments that were created in TWL but contain errors. The WL Entry Batch Adjust Inventory Report could not update inventory quantities or the General Ledger because of the errors that were encountered during the report run. These transactions remain in WL Transaction Inquiry in error status. Correct the problem and set the status to active so that the WL Entry Batch Adjust Inventory Report can attempt the updates again. |
K | Stock adjustments that were created in TWL and have an active status in WL Transaction Inquiry. The status is active as they wait for the WL Entry Batch Adjust Inventory Report to pick them up to update inventory and General Ledger. |