Queries is a powerful system for creating custom reports and event notifications (using the Job Master Export to Query job).
To create a custom report showing the Top 10 Customers Month to Date add a new Query with the following properties:
  • Description - Top 10 Customer Month To Date
  • Sql - SELECT TOP 10 Cus_No, Cus_Name, Sls_PTD FROM ARCusFil_Sql ORDER BY Sls_Ptd Desc

Click the Preview button to view the results.