Hourly Sales Report

(0) Share

Report

Posted on by Community Member

Hi Folks

Due to Covid, our sales are down and we would like to shorten our hours of operations.

Does anybody have a report that shows sales and transactions per hour, to help us make this decision? Looking into maybe making a pivot table in excel from a csv download - any help with this would be appreciated.

Thanks

Danny L

All responses (1)

Answers (0)

ToddB on at

Like (0)

Report

RE: Hourly Sales Report

Hi Danny,

Please try the attached.

This should let you group by Time; and show the total number of transactions in that time period:

[View:/cfs-file/__key/communityserver-discussions-components-files/106/Custom-_2D00_-Detailed-Sales-by-Hour-Transaction-Count.qrp:320:240]

_______________________________________________

Just a note that Mainstream support for Microsoft Dynamics RMS 2.0 ended on July 10, 2016; and extended support ends on 7/13/2021:

https://community.dynamics.com/rms/b/rmssupport/archive/2015/10/22/microsoft-dynamics-rms-2-0-mainstream-support-discontinuation-july-10-2016

Dynamics Retail Management System 2.0 - Microsoft Lifecycle | Microsoft Docs

This is around 5 weeks from now; and you can continue using RMS after this date, but technical support will not be available.

I would recommend checking with your partner regarding what they may recommend as a replacement system after the extended support end date.