Serial and lot items

In Distribution SX.e, lot information is maintained in Product Extended Lot Number Setup and in the ICETL table records. In Distribution SX.e, linear cut information about lot products is maintained in Product Extended Lot Number Setup-Cuts and in Sales Linear Cut Maintenance Entry. In Distribution SX.e, serial information is maintained in Product Extended Serial Number Setup and the ICETS table records. In TWL, corresponding information is maintained on the TWL Configuration-Item master record.

Before you can edit serial or lot records, the TWL item quantity must balance to the actual quantity in the warehouse. 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. This sequence provides a high-level workflow of the serial or lot balancing:

  1. Prepare:
    1. Clear unavailable stock from the warehouse.
    2. Clear WL Transaction Inquiry of open, error, work-in-process transactions.
    3. Finish processing WT, KP, OE, VA orders.
  2. Balance:
    1. Count inventory.
    2. Generate the WL Audit Inventory Report to update item quantities only; that is, no serial or lot updates.
    3. Generate the WL Entry Batch Adjust Inventory Report.
  3. Validate:
    1. Generate the WL Audit Inventory Report to validate updates.
    2. Run the Product Warehouse Inventory Audit Report to validate updates.