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