Does anyone know of a report that will show sales by batch for HQ? I have a report that works at Store Operations but not HQ.
Sales by Batch Report for HQ
Feb 15, 2008
1 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required