How can the No Sales be tracked other that on Z out to say how many there were. I would like to run a report to show when they occured as Date Time. Is this possible?
*This post is locked for comments
I can't find an existing report to do this, and I don't have time to write one, but if you open up Administrator, connect to your database, and run the following query, it should give you the data you're looking for:
SELECT store.name AS Store, ntt.Time, Cashier.name AS Cashier FROM nontendertransaction ntt JOIN store ON ntt.storeid = store.id JOIN cashier ON ntt.cashierid = cashier.id AND ntt.storeid = cashier.storeid WHERE ntt.transactiontype = '13' AND ntt.time BETWEEN '01/01/2012' AND '09/06/2012' ORDER BY ntt.Time ASC
replace '01/01/2012' with your start date and '09/06/2012' with the day after your end date, leaving the single quotes
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
