Query - Period and Volume Discounts for a Prompted Item

#1 · June 4, 2020, 2:11 pm

This SAP Business One query is an ideal query to run from a sales order or other SAP Business One marketing document, that shows all valid period and volume discounts for the prompted item.

SELECT T0."ItemCode",
T3."ItemName",
T1."FromDate",
T1."ToDate",
T3."OnHand",
T1."Price" "MSRP",
T2."Amount",
T2."Price"
FROM OSPP T0 INNER JOIN SPP1 T1 ON T0."ItemCode" = T1."ItemCode"
INNER JOIN SPP2 T2 ON T1."ItemCode" = T2."ItemCode"
INNER JOIN OITM T3 ON T0."ItemCode" = T3."ItemCode"
WHERE T0."ItemCode" =[%0]
AND CURRENT_DATE >= T1."FromDate"
AND CURRENT_DATE <= T1."ToDate"