Scheduling a Report

Scheduling a Report

Overview

Scheduling reports can enhance the efficiency and profitability of retail businesses by offering insights into key metrics such as sales volume, customer satisfaction, and delivery times. These insights are instrumental in pinpointing areas requiring enhancement and fine-tuning operational strategies. 

FTx Cloud POS supports report automation. You can configure specific reports that can be printed or emailed at set times and recurrences. The system will send the scheduled report to the indicated email IDs at the defined frequencies (daily, weekly, bi-weekly, monthly, quarterly, etc.). You can create as many schedules as required, each with unique settings. 

You can schedule, replace, and manage any report included in List Reports, Sales Reports, Smart Till Reports, Inventory Reports, and Lottery Reports following the steps mentioned in this article. You can also replace or edit the existing scheduled report.

1. Scheduling a New Report

Prerequisite: Please ensure you have configured a report. This means you have made the required selections for date ranges and filters. (You don't have to click "Generate Report" to schedule a report.)

Please follow the steps below to schedule a new scheduled report: 
  1. Navigate to the report you wish to schedule. For example, a Buydown Sales Report, Invoice Summary Report, or Time Clock List Report. 
  2. Configure a report as per your requirements using the filter options.
  3. Click the "Schedule Report" button highlighted in Figure 1.1.

 Figure 1.1
  1. The pop-up screen will appear as shown in Figure 1.2. Click on "Create New Scheduled Report."

Figure 1.2
  1. The "Schedule Options" screen will appear, as Figure 1.3 shows.

Figure 1.3

Fill in the appropriate information in the fields:
  1. Name: Enter the name for your report.
  2. Section: For the Cloud POS, the section will be POS by default. 
  3. Run Frequency: Select the run frequency (Daily, Weekly, Bi-weekly, Monthly, Quarterly, etc.) as per your requirements from the Run Frequency drop-down. The system will display additional options depending on the frequency you choose. 1.1 Run Frequency explains further details.
  4. Run Time: Select the time when you want the system to send the report by email.  
  5. Export Type: Select the report format, i.e., PDF, CSV, and Excel, from this Export Type drop-down. 
  6. Users: Select the users to whom you need to send the report.
  7. Email Addresses: Enter the selected users' email addresses. Please ensure that you write only one email address per line. 
  8. White Background: Enable this toggle button if you want the report to have a white background. 
  9. Include Header: This toggle button will be enabled by default. Please set it to NO to exclude the report's header from the report. 
  10. Print Title on Every Page: This toggle button will be enabled by default. Set it to NO if you do not want the title printed on each page.
  1. Click "Schedule Report."
  2. A success message will appear, and the system will send the scheduled report to the indicated email IDs.

1.1 Run Frequency

Use the Run Frequency drop-down to set the report frequency you are scheduling.  
Daily: Choose the Daily option to schedule the report to run every single day. The system will send the configured report to specified email addresses or user IDs daily. 

Figure 1.1.1
  1. The Start Time and End Time fields specify the time interval for the reports. The system defaults Start Time to 12:00 AM and End Time to 11:59 PM. You can modify it if necessary. 
  2. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 
Weekdays: Choose the Weekdays option to schedule the report to run on weekdays. The system will send the configured report to specified email addresses and/or user IDs on weekdays. 

Figure 1.1.2
  1. The Start Time and End Time fields specify the time interval for the reports. The system defaults Start Time to 12.00 AM and End Time to 11.59 PM. You can modify if necessary. 
  2. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 
Weekly: Choose the Weekly option to schedule the report to run weekly. The system will send the configured report to specified email addresses and/or user IDs every week. 

Figure 1.1.3 
  1. The Run On field specifies the day for the report to run. The system defaults to Run On on Monday. You can change it to any other weekday if necessary. 
  2. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 
Monthly: Choose the Monthly option to schedule the report to run monthly. The system will send the configured report to specified email addresses and/or user IDs every month. 

Figure 1.1.4
  1. The Run On field specifies the day for the report to run. The system defaults to Run On on First Day. You can change it to Last Day if necessary. 
  2. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 
Daily - Today: Select the Daily - Today option to schedule the report to run daily AND include the current day.

Figure 1.1.5
  1. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 
Bi Weekly: Choose the Bi Weekly option to schedule the report to run bi-weekly. The system will send the configured report to specified email addresses and/or user IDs bi-weekly. 

Figure 1.1.6
  1. The Run On field specifies the day for the report to run. The system defaults to Run On on Monday. You can change it to any other weekday if necessary. 
  2. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 
Quarterly: Choose the Quarterly option to schedule the report to run quarterly. The system will send the configured report to specified email addresses and/or user IDs quarterly. 

Figure 1.1.7
  1. The Run On field specifies the day for the report to run. The system defaults to Run On on First Day. You can change it to Last Day if necessary. 
  2. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 
Yearly: Choose the Yearly option to schedule the report to run once a year.. The system will send the configured report to specified email addresses and/or user IDs yearly. 

Figure 1.1.8
  1. The Run On field specifies the day for the report to run. The system defaults to Run On on First Day. You can change it to Last Day if necessary. 
  2. The Run Time field specifies the time for the report to run. The system defaults to 11:59 PM. You can modify this setting if necessary. 

2. Replacing an Existing Scheduled Report 

Please follow the steps below to replace a scheduled report: 
  1. Navigate to the report you need to schedule and configure a report as per your requirements using the filter options.
  2. Click the "Schedule Report" button highlighted in Figure 1.1. 
  3. The pop-up screen will appear, as Figure 1.2 shows.
  4. Click "Replace Existing Report." The Select Scheduled Report screen will open, as shown in Figure 2.1.

Figure 2.1
1: Enter the report name or its part in this Search bar and click the "Search" button.  
2: The system will display the existing reports relevant to your search. Click on the report you need to replace. 
3: Click "Apply." 
  1. The selected report will open in the Edit mode. Make the required changes and click "Replace."
  2. A success message will appear, and the system will send the replaced report to the indicated email IDs. 

3. Managing the Scheduled Report

You can manage all your scheduled reports from any of the report screens. Please follow the steps below to manage the scheduled reports.
  1. Click on the "Schedule Report" drop-down and click "Manage Reports." 

 Figure 3.1
  1. The Manage Scheduled Reports screen will appear, displaying the list of all scheduled reports, as Figure 3.2 shows. 

Figure 3.2
1: Use this Search box to search for a specific scheduled report. 
2: Use this drop-down to view the scheduled reports based on specific sections, such as All, POS, Loyalty, Admin, Cube, Signage, and Unknown. 
 
Figure 3.3
You will be able to see the section options based on your FTx Cloud POS subscription plan. 
3: Use this drop-down to view the scheduled reports based on the report frequency, such as All, Daily, Weekdays, Weekly, Monthly, Daily - Today, and Bi-Weekly.  

Figure 3.4
4: Edit or delete the report: 
  1. Click the respective Edit button to edit the scheduled report. The Scheduled Report will open in the Edit mode. Make the required changes and click "Save."
  2. Click the respective Delete button to delete the scheduled report. The system will show a confirmation message. Click "Yes, Delete."

    • Related Articles

    • Scheduled Price Change Report

      Scheduled Price Change Report This report type will display, only the scheduled cost or price change data for each pricebook zone. The records of the manually changed price will NOT be displayed in this report. Different types of sorting ...

    • Buydown Sales Report

      Buydown Sales Report Overview Reports -> Sales Reports -> "Buydown Sales" Tobacco manufacturers and distributors have long made refund/rebate payments to retailers for the retailer’s purchase of cigarettes and other tobacco products. Sometimes ...

    • Price Change Report

      Price Change Report Overview In the retail business, changing the product's price is common for various reasons. FTx Cloud POS provides the Price Change Report, including both the cost change and the price change for the selected date range, so that ...

    • Summary Sales Report

      Summary Sales Report Overview Reports -> Sales Reports -> "Summary Sales Report" As a sales manager or super-admin user, you need to keep an eye on the overall sales and earnings from different payment modes during the specific date range. This will ...

    • Vendor Parts List Report

      Vendor Parts List Report Overview The "Vendor Parts List Report" displays vendor parts, UPCs that they are tied to, and details based on a set of filters that are set to narrow down parts. 1. Reaching the "Vendor Parts List Report" To reach the ...