Advanced shift and till reporting

[Scott]

These topics may help you with generating reports per terminal.

Payments by Terminal Report

This custom report displays payments by terminal. @@PaymentsByTerminal select PT.Name, SUM(Amount) as Amount from Payments inner join PaymentTypes as PT on PT.Id = PaymentTypeId where TerminalId in (select Id from Terminals where Name = '@1') and Date > '{Start}' and Date < '{End}' group by PT.Name Template [Payments by Terminal:1, 1] >Server| @@PaymentsByTerminal:Server >Till 1| @@PaymentsByTerminal:Till 1 This report displays results for 2 Terminals named Server and Till 1.…

Individual Work Period Report Per Till

Currently, I’ve hooked up 2 tills to a sql database, and the message server hooked up and it’s all working. What currently happens is that no matter which till you are on, when you view the work period report, it shows the grand total of everything that both tills have done. I’ve managed to follow the amount per terminal tutorial which shows individual amount of sales made per till, but If someone could point me in the right direction, in creating a report which shows everything as it does in …