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

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