FAQ# 2140: How do I look up sales totals on a specific date in Store Manager Classic?

Question

How do I look up sales totals on a specific date in Store Manager Classic?

Answer

Open Proxis Office.
Select the File menu -> Open Database Table -> Transaction Log
Select the Report Query menu -> Build New Report Query

Construct the following report

Select: SELECT * FROM [Transaction Log]
Where: WHERE [Transaction Date]=#mm/dd/yyyy#
Order by: ORDER BY
Click OK

Once the query is entered, it should only display transactions made on the specified date. Select the column you with to total (ie. Sales Total) then select the Records menu -> Sum/Add Column

To reset the log, select File then Reset

Need Help? We have answers to all your Tech Support needs!

This question is associated with products:

Proxis Store Manager Classic Proxis Store Manager Classic Retail Point of Sale Software