Balancing item quantities in a pre-live environment

The WL Audit Inventory Report includes stocked and nonstocked items that have inconsistent quantities in both Distribution SX.e and TWL. The report can be run for one WL location at a time. After you review the exceptions, run the report in update mode to create stock adjustments. After the stock adjustments have been made, process the WL Entry Batch Adjust Inventory Report to update balances and the General Ledger.

  1. Select Warehouse Logistics > Reports > WL Reports > Audit Inventory Report.
  2. Click New > Stored.
  3. Specify the report, printing, and scheduling information, and click Next.
  4. Optionally, specify a warehouse or product range on the Ranges page.
  5. Click Next.
  6. On the Options page, specify this information:
    WL Location
    Specify the WL location for which the report is being generated. This location was set in Product Warehouse Description Setup.
    Individual stored reports can be set up per location if multiple WL Locations exist on the system.
    Create WL Record For Qty Out Of Balance
    Set the this option to No. We recommend you first run the report with this option set to No. After researching the discrepancies, rerun the report with the option set to Yes to create internal transaction records and update files.
    If you are running the report for a warehouse that is not live, set the Create WL Record For Qty Out Of Balance option to No. Before going live, this report can be used to get the quantities in balance after the full warehouse inventory is complete.
    Create Missing WL ITEM Records
    Set this option to Yes to create missing TWL Configuration-Item master records from Product Warehouse Product Setup records. If this option is No, and an item master record is missing, an exception is printed on the report. The items set up in the selected warehouses are compared by Distribution SX.e and matching records are created.
    Serial/Lots:E)dit, U)pdate, or N)either
    Set the this option to Yes to audit serial or lot records. Exceptions for serial or lot out-of-balance quantities, nonexistent serial or lot records, and unmatched lot quantities provide the information to reconcile the items.
    L)ive WL Whse, N)ot Live, or B)oth
    Indicate whether you are running the report for a live TWL warehouse or not.
    Show Error Details
    Set the this option to Yes to view detail for the reasons the WL Audit Inventory Report could not make a stock adjustment.
  7. Click Finish.
  8. Research the discrepancies, rerun the report, and set the Create WL Record For Qty Out Of Balance option to Yes to create WLET transactions.
  9. Run the WL Entry Batch Adjust Inventory Report report to update the Product Warehouse Product Setup balances.