Processing inventory adjustments

These adjustments and updates can be processed concurrently with the WL Entry Batch Adjust Inventory Report:

  • Stock adjustments
  • Unavailable adjustments
  • Nonstock adjustments,
  • Primary bin location updates

The data being communicated from TWL is set up so that duplicate data is not communicated more than once if two reports are running simultaneously. The WL Entry Batch Adjust Inventory Report opens and closes the journals per adjustment accordingly.

  1. Select Warehouse Logistics > Entry > WLE Reports > WL Entry Batch Adjust Inventory.
  2. Click New > One Time.
  3. Specify the report, printing, and scheduling information, and then click Next.
  4. On the Ranges page, specify a warehouse or product range to limit the qualifying warehouses. The warehouses are validated in Product Warehouse Description Setup.
  5. Click Next.
  6. On the Options page, specify this information:
    Stock/Unavail Adjustment - ICEPA/ICEU
    Select Yes. With this option, you can process active stock and unavailable adjustments that have been communicated to the system from TWL.
    This option launches the appropriate Product Adjustment Entry or Product Unavailable Inventory Entry function. If processing a stock adjustment, a journal opens after a valid product is found to process and the system updates are made. Product Unavailable Inventory Entry does not open a journal. Instead it moves the quantities to or from Unavailable. The products can be flagged as available or unavailable and must be stocked products.
    Non-Stock Adjustment - ICEAN
    Select Yes. With this option, you can process all the active nonstock adjustments that have been communicated to the system from TWL. The ICENH and ICENL table records are created or updated.
    Bin Locations - ICSW
    Select Yes. With this option, you can process all the primary bin location changes that have been communicated to the system from TWL. The corresponding Product Warehouse Product Setup record is updated with split case, full case, and counter sale locations.
    If the Product Warehouse Product Setup record is locked, then the record cannot be updated. An exception is printed and the transaction record is flagged as an error. Then, the record is processed the next time the report is run.
    WL Product Update - WLICSW
    Select Yes. With this option, you can update Product Warehouse Product Setup fields in the Warehouse Logistics view with modifications that occur dynamically between the RF system and the TWL Web module. The parameter 3613, P.P.- Overwrite of Item Zone?, must be set to Yes. These fields are updated in Product Warehouse Product Setup:
    • Box Quantity
    • Case Quantity
    • Pallet Quantity
    • Warehouse Zone
    • Counter Bin
    • Kit Build Department
    Check for Locks Prior to Processing
    Select Yes for this report to check for record locks before the report attempts to process a transaction. If a lock is found, then the transaction is skipped. A WL Transaction Inquiry transaction is not applied to a company and warehouse because stock adjustments must be processed in the correct order.
  7. Click Finish.

The WL Entry Batch Adjust Inventory Report presents a summary of the total adjustments processed for the corresponding options selected. The function totals are per warehouse. The report exceptions are listed by function, and the print interval exceptions are printed at the end of the report.