Balancing serial and lot items

To automatically update serial or lot records, the item quantities in TWL must balance to the serial or lot detail records. Use these instructions to find exceptions for serial or lot records.

  1. Clear serial records with an unavailable status from the warehouse.
  2. Clear WL Transaction Inquiry of open, error, and work-in-process transactions.
  3. Finish processing orders a) in shipped stage in Distribution SX.e, and b) in picked and packed stages in TWL.
  4. Complete the initial load or physical count in TWL.
  5. Generate the WL Audit Inventory Report with these options to isolate quantity differences:
    1. Set the Create WL Record For Qty Out of Balance option to Yes.
    2. Set the Create Missing WL ITEM Records option to Yes.
    3. Set the Serial/Lot: E)dit, U)pdate, or N)either option to Neither.
    Although you can update quantities and serial or lot detail records concurrently without first balancing the item quantities, your report can be confusing. You create a better audit trail by balancing the item quantities first, and then adjusting the serial or lot records.
  6. Run the WL Entry Batch Adjust Inventory Report and set the Stock/Unavail Adjustment - ICEPA/ICEU option to Yes.
  7. Rerun the WL Audit Inventory Report with these options:
    • Set the Create WL Record For Qty Out of Balance option to Yes.
    • Set the Serial/Lot: E)dit, U)pdate, or N)either option to Update.
    Note: When there are multiple cut pieces available for a lot, the adjustment created by the WL Audit Inventory Report is applied to the first piece with the necessary length for the adjustment. The WL Balance Inventory Report lot balancing functionality includes lot cut pieces in the Lot Cut Piece Detail report section, giving the user a detailed view of what is and what should be associated with the lot.
  8. Run the Product Warehouse Inventory Audit Report to validate the serial or lot quantities to the Product Warehouse Product Setup quantities and find discrepancies between the on hand and unavailable quantities.

    This verifies that the serial or lot totals balance with the Distribution SX.e on hand and unavailable quantities set by the WL Audit Inventory Report and the WL Entry Batch Adjust Inventory Report.