Sales Per Hour Report

[QMcKay]

@emre

That will also work:

{REPORT BLAH BLAH DETAILS@@SalesPerDay:‘Sun’

… as @@SalesPerDay:'Sun' handler replaces whole tag with the result of SQL Script.

Well that is interesting to note Can that behavior be changed @emre?

@emre

can you remember how we used it?

The first time we used it is in the Account Statement Tutorial - but in this case, the tag is used inside a Printer Template with a @@GetStatement, with no parameters …

@QMcKay

The Template fields must match the names of the SQL fields being returned, so I modified the field names to match the SQL names:

Customer Account Statements and Payments (Custom)

This Tutorial will demonstrate how to build a Custom Account Handling Screen for Customers. It allows for Printing detailed Customer Account Statements, making Payments to Customer Accounts (via the built-in Payment Screen), and Crediting Customer Accounts. Requires SambaPOS 5.1.56 or higher Operations The Customer Account Operations Screen we will build and Automate is shown on the right. [image] Quick Nav: Account Type and Account for Transfers (for Account Payments via Paym…