Reconciling item quantities in post-live environment

Use the WL Inventory Balance Report to view orders and receipts in different stages. Use the report to view active and error transactions in WL Transaction Inquiry. This report includes the transactions received from TWL and transactions sent to TWL that are not in the process of passing through the systems.

Because partially processed transmissions cannot be analyzed for balancing purposes, there should be no work-in-process or open transactions in WL Transaction Inquiry. After you review the exceptions, run the report in update mode to create stock adjustments. After the stock adjustments have been made, run the WL Entry Batch Adjust Inventory Report to process and update balances and the General Ledger.

  1. Select Warehouse Logistics > Reports > WL Reports > Inventory Balance 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.
    View A)ll or O)ut of Balance Results
    Indicate whether to view all balances or only the items with discrepancies.
    Buckets: A,B,C,D,E,F,G...K or X for all
    Indicate which buckets to view.
    Legend: Each P)age or E)nd of Report
    Indicate whether the legend printed on each page or at the end of the report.
    L)ive WL Whse, N)ot Live, or B)oth
    Specify the letter that indicates the status of the TWL environment.
    Show Bucket Detail
    Specify Yes to view the details of the out-of-balance buckets, or accept the default.
    Subtract Committed from Distribution SX.e Quantity
    Specify Yes to subtract the committed and in-process quantities from the Distribution SX.e balance, or accept the default.
    Show Inventory Detail
    Specify Yes to include inventory on the report, or accept the default.
    Show Serial/Lot Detail
    Specify Yes to include serial or lot details on the report, or accept the default.
  7. Click Finish.