Updating TWL for bulk delivery orders

Use BD Entry TWL Update Report to update the inventory quantities and transactions in TWL for bulk delivery orders that have been invoiced. We recommend you set up BD Entry TWL Update Report to run as a stored report nightly after Sales Entry Invoice Processing Report.

BD Entry TWL Update Report processes all sales order lines that meet these conditions:

  • The order is flagged for TWL update (as set during Sales Entry Invoice Processing Report)
  • The order is in Invoiced or Paid stage
  • A Bulk Delivery transaction record (BDET) exists for the order line
  • The product is set up as a TWL item with a quantity greater than 0

The report reduces the quantity of each TWL item in its locations by the shipped quantity and creates a WL Transaction Inquiry record and flags it as ‘U’pdated.

Before you run the BD Entry TWL Update Report, verify that you have set up a TWL RF Employee record and specified the employee ID in the TWL RF Employee field in SA Administrator Options-Documents-Sales Orders Processing.

  1. Select Bulk Delivery > Entry > BDE Reports > TWL Update.
  2. Select One Time to run an on-demand report. Otherwise, select Stored to set this up as a stored report.
  3. Specify the printing information and click Next.
  4. Specify your TWL warehouse in the Warehouse range, or a range of TWL warehouses.
  5. Click Next and then Save.