Does anyone know how to find my top sales dates/ days with highest sales /highest z reports ? Does any one know how to find those in RMS? Is there a custom report for this ?
Thanks Robert
- posted
15 years ago
Top Sales days top z report days report
Loading thread data ...
- Vote on answer
- posted
15 years ago
Robert:
Do you want to look at your past journals/Z reports and print a new report in descending order by sales showing dates? Over what period of time: last month, quarter, year...?
Aloha, Miles snipped-for-privacy@pacificcomp.biz
Pacific Computer Systems Miles Baidack
Supporting Business Since 1985 Phone: (808)395-8156 or (808)277-8156
"Robert" wrote:
- Vote on answer
- posted
15 years ago
these sql queries could give you the quick answer:
Top Sales Dates: select top 10 left(time,11) date, sum(total) sales from [transaction] group by left(time,11) order by sum(total) desc
Top Transactions: select top 10 time, total, transactionnumber, storeid from [transaction] order by total desc
T> Does anyone know how to find my top sales dates/ days with highest sales
- Vote on answer
- posted
15 years ago
Than you so much this was exactly what i was looking for
Robert
"Matt Hurst" wrote: