SAP Business One – Sales Summary total for last 24 hours

Sales Summary total for last 24 hours

This query in SAP Business One returns 1 value, the total sales dollars in the last 24 hours. This is a great query to turn into an alert, or use in a Dashboard on release 8.8 or SAP Business One.

SELECT sum(T0.[DocTotal]) AS ‘SO$’ FROM ORDR T0 WHERE T0.[DocDate] >= getdate()-1

2019-01-16T11:22:41+00:00 February 3rd, 2016|SAP Business One|Comments Off on SAP Business One – Sales Summary total for last 24 hours