Pre-live balancing report

The WL Audit Inventory Report is used to balance the Distribution SX.e on hand and unavailable quantity balances in Product Warehouse Product Setup with the available, reserved, and unavailable balances in TWL. Because the activities in the warehouse are controlled by TWL, the TWL quantity is considered the accurate quantity. The balances for all stocked items, with the exception of labor items, are audited.

The WL Audit Inventory Report is used to identify out-of-balance conditions between the two systems and is generally run in review mode first. This mode gives you the opportunity to review the edit errors and exception messages. 'Edit' errors should be reviewed to verify the source of the error. In most cases, the error is due to a timing difference between the two systems and is corrected after processing is completed. Exception messages show at the end of the WL Audit Inventory Report. Exceptions require intervention to isolate the problem.

After you have made the necessary corrections, you can run the WL Audit Inventory Report in update mode. Running the report creates stock adjustments to correct the out-of-balance conditions and updates the unavailable quantities in Product Unavailable Inventory Entry.

The WL Entry Batch Adjust Inventory Report must be generated to activate the stock adjustments and adjust the General Ledger and Product modules in Distribution SX.e. Because the activities in the warehouse are controlled by TWL, the TWL quantity updates Distribution SX.e quantities.