BD Entry TWL Update Report overview

Bulk Delivery > Entry > BDE Reports > BDEPT

Function acronym: BDEPT

Use this report to update the inventory and transactions in TWL for bulk delivery orders that are invoiced.

TWL quantities are reduced by the shipped quantity on the order. If a bulk item exists in multiple locations in a TWL warehouse, quantities are removed from each location or bin in bin number order until the shipped quantity is met. If there are not sufficient quantities in all locations, the total TWL quantity is allowed to go negative.

This report may be set up as a stored report to run immediately after invoice processing. Use the Warehouse range to run stored reports for different warehouses.

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 Stage 4 (Invoiced) or Stage 5 (Paid)
  • A Bulk Delivery transaction (BDET) exists for the sales order line
  • The product is set up as a TWL item
  • Inventory exists in a TWL warehouse for the item
When an RM order is invoiced for a TWL warehouse, the BD Entry TWL Update report updates the TWL inventory. The return quantities are added to the first available inventory record that matches the company, warehouse, and product of the return order line. The return order lines in the generated report are marked as RM. Labor items are not considered for the TWL inventory update.
Note: To update the TWL inventory for RM orders, you must set the Allow BD Returns to Update TWL checkbox to checked, in the Bulk Delivery section of the SA Administrator Options-Documents-Sales Orders-Processing screen.