Delayed Item Report

Delayed Item Report lists Delivery Note lines that went out after the delivery date promised on the Sales Order, with the customer, the item, the promised date, the actual posting date and the number of days late. It joins Delivery Note Items to their Sales Order Items and keeps rows where the posting date is after the promised date. Measured per item, it exposes which products cause delays, such as a line that always waits for a supplier, rather than which orders. Use it monthly to set honest delivery dates and to see whether a warehouse or supplier is the bottleneck. It has no accounting effect.

Delay days = Delivery Note posting date - Sales Order item delivery date, for rows where the difference is positive

1. 01Go to Stock > Delayed Item Report.
2. 02Set Company, From Date and To Date for the delivery period.
3. 03Filter by Customer, Item or Warehouse if needed.
4. 04Read Delivery Date (promised), Posting Date (actual) and Delay Days per row.
5. 05Sort by Delay Days and find the items that repeat.
6. 06Fix lead times, reorder levels or promised dates for those items.

Open to measure delivery performance per item.

An item promised Ashwin 5 but delivered Ashwin 9 shows 4 days late.