Ticket Report
From FloristWiki
|
The Ticket report provides you with an analysis of each ticket type, the products ordered on each ticket, and the cost and quantity of products ordered per ticket, for the given sales date or date range. You can select which ticket types you want to include: Order Entry, Manual Ticket, and/or Point of Sale tickets.
Generating a Ticket Report
To generate a Ticket report:
- On the FTD Mercury Main Menu, click Business Reports.
- Double-click Mercury Forms.
- Double-click on the Ticket Report icon to open the template.
- If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
- In the Select Store field, click the arrow and select the store’s data that you want to use for the report.
- In the Sale Type section, select the types of tickets that you want to include in your report: Order Entry, POS, and/or Manual Ticket.
- In the Sort Option section, decide if you want to sort the report by Customer, Date, or Type.
- In the Date Range section, select a sales start and end date for the data that you want to include in the report.
- In the Date Type section, select whether you want to generate the report by Delivery Date or Sale Date.
- Click Finish. The report generates and opens in Excel.
- To print your report from Excel, on the File menu, click Print.
- If you want to save the report from Excel, on the File menu, click Save.
Ticket Report Window
The Ticket Report window allows you to configure settings for the Ticket report. When you have finished configuring settings, click Finish to generate the report. It will open in Microsoft Excel.
The Ticket Report window contains the following settings:
Setting | Description |
Select Store | Select the store for which you want to generate the report. If you have multiple stores, you can select All Stores to generate a report that includes data from all of your stores. |
Sale Type | Select the type of tickets to include in the report. You can select Order Entry, Manual, and POS. |
Sort Option | Select to sort the report by customer, date, or type of sale. |
Date Range | Select the sales start and end dates for the report. |
Date Type | Select whether you want to run the report by delivery date or sale date. |