Hi Guys, First things first would like to thank everybody for there help so far Ive managed to implement Sambapos across a holiday park spread over 8 terminals 2 kitchens and 3 bars. So far no problems and the staff are finding it a doddle to use. Now the old EPOS system the site used generated an…

Custom Report Help Hourly Sales

QMcKay July 5, 2016, 8:21pm 2

Report Template: [Sales Per Hour: 15, 25, 15, 20, 20] >Hour|Sales|Tx|AvgTx|%Sales @@SalesPerHour:6,22 Change the 6,22 parameter above to set your Start and End hours. For example, a full day would be: @@SalesPerHour:0,23 [image] @@SalesPerHour (SQL Script in Automation > Scripts) declare @StartDate datetime = convert(varchar(25),'{Start}',126) declare @EndDate datetime = convert(varchar(25),'{End}',126) declare @StartHour int = @1 -- set the First Hour you want to track declare @EndHour…

1 Like

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled