What criteria is used in populating Daily Sales Report (Summary) by SalesRep or by Category? Is it governed by the "Time" field in Public_Transaction? The reason to my question is, when I access RMS data, and run a query using MS Access, the sales figures differ, when the grouping is done by the "Time" field in Public_Transaction file.
Thank you all for your guidance.