Unavailable stock

An inventory record can be temporarily out of balance when the corresponding Product Unavailable Inventory Entry record is outstanding. This may be true even though the inventory quantities are the same in both systems. The WL Audit Inventory Report finds the Product Unavailable Inventory Entry records and recreates them from the TWL count transactions.

In the WL Audit Inventory Report, you can use the Create WL Record For Qty Out Of Balance option. If so, then the unavailable types from TWL update the Product Unavailable Inventory Entry values and types based on the actual detail uploaded from TWL.

This update creates stock adjustments to correct the out-of-balance conditions. The unavailable quantities in Product Unavailable Inventory Entry are also updated.

You may receive a shipment containing more than one unavailable type. If so, then Distribution SX.e shows the sum of the unavailable quantity with the first unavailable reason. For example, you receive a line item that contains a quantity of 5 transportation hold and 12 quality assurance hold. The entire quantity of 17 is recorded on the line item and in Product Unavailable Inventory Entry as transportation hold.

The WL Entry Batch Adjust Inventory Report must be run to balance unavailable quantities if there are out-of-balance conditions. If there are adjustments to move quantities from the unavailable balance to other buckets, then they are processed first. To ensure transactions are sequenced correctly, transactions that adjust available quantities are processed before transactions that move quantities from available to unavailable.

Plus or minus adjustments are made to the unavailable quantity in Product Warehouse Product Setup based on the count data in TWL. All Product Unavailable Inventory Entry records are removed and rebuilt with the actual detail downloaded from TWL.