800-903-6571 POSGuys Knowledge Base – Help and Advice from the Pros!
Order Tracking |  My Account |  View Cart

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:
Store Manager Classic Product Image
Proxis Store Manager Classic Proxis Store Manager Classic Retail Point of Sale Software
Need Live Help? Live Chat