Sales by Batch Report for HQ

If you know how, use Excel to do a SQL query on the BATCH table in HQ. Or just do it in HQ Administrator.

Query:

Select * From Batch

You will get a wealth of data. Warning - you have to sum the Returns and Sales columns to get actual sales. To get just what you want, you could do:

Select BatchNumber, ClosingTime, StoreID, Sales + Returns AS 'Total Sales' from Batch