SAP Business One Training Tips #3

Shipping Performance Report – Monitor your on time shipping performance

Great report to measure your on-time delivery performance.

SELECT DISTINCT DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) AS ‘Lapsed Days’, CASE
WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) >= 5 THEN ‘Late by 5 Days or More’
WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) BETWEEN 1 AND 4 THEN ‘Late by 1 to 4 Days’
WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) = 0 THEN ‘On Time’
WHEN DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate) < 0 THEN ‘Early Shipment’
ELSE ‘Not Shipped’
END AS ‘Ship Stat Results’, T2.DocNum AS ‘Sales Ord’,
T2.DocDueDate AS ‘Exp Del Date’,
T3.DocNum AS ‘Del Num’,
T3.DocDueDate AS ‘Del Date’ FROM RDR1 T0 LEFT OUTER JOIN DLN1 T1
ON T1.BaseType = 17
AND T0.DocEntry = T1.BaseEntry
AND T0.LineNum = T1.BaseLine
AND T0.ItemCode = T1.ItemCode LEFT OUTER JOIN ORDR T2
ON T0.DocEntry = T2.DocEntry
AND T2.Canceled = ‘N’ LEFT OUTER JOIN ODLN T3
ON T1.DocEntry = T3.DocEntry WHERE T2.DocType = ‘I’ ORDER BY DATEDIFF(DD, T2.DocDueDate, T3.DocDueDate),
T2.DocDueDate DESC,
T2.DocNum,
T3.DocDueDate,
T3.DocNum FOR BROWSE


Phone: 888.239.2818 | Fax: 312.621.9200

 Copyright © 2012 Clients First Business Solutions (North America) LLC. All rights reserved

CFBS Locations: New Jersey (Head Office)Alabama | California | FloridaIllinois | Minnesota | TennesseeTexas