Standing Order Log Detail Report
From FloristWiki
The Standing Order Log Detail Report provides you with a list of every standing order template that has had orders generated from it during a selected delivery date range. Depending on the options selected in the FTD Mercury Standing Order Log window, this report may be sorted by customer, frequency, or store.
The Standing Order Log Detail Report contains the following information:
| Column | Description |
| Customer | The name of the customer with whom the standing order template is associated. |
| Recipient | The recipient of the orders generated by this standing order template. |
| Total | The total order price for each order generated by the standing order template. |
| Recurrence Pattern | The frequency at which the order recurs. This does not display any additional dates added to the standing order template, nor any dates removed. |
| Start Date | The start date of the standing order template, and the date on which the first order was (or is to be) delivered. |
| End Date | The date on which the standing order template will expire. This may be different than the Last Delivery Date. |
| Template ID | The ID of the standing order template in the system. |
| Creation Date | The date this order was or will be generated from the standing order template. |
| Delivery Date | The delivery date for this order. |
| Status/Order Number | Either the order number for this order, or the status of the order if it either has not been created yet (Pending) or if it could not be created (Failed). |
| Store | The store with which the standing order template is associated. |
Generating a Standing Order Log Detail Report
To generate a Standing Order Log Detail report:
- On the FTD Mercury Main Menu, click Business Reports.
- Double-click on the Standing Order Log icon to open the template.
- If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
- In the Standing Order Report window, select the store for which you want to generate the report. You can also select All Stores to generate a report for all stores (if you are a multi-store shop).
- Select whether you want the report sorted by Customer, Frequency, or Store.
- In the Report Type area, select Summary.
- In the Date Range area, specify the start and end dates for the range. Orders created from standing order templates during this date range will be included in the report.
- Click Finish.
- 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.
Standing Order Report Window
The Standing Order Report window allows you to customize the Standing Order Log Summary and Standing Order Log Detail reports.
The Standing Order Report window contains the following settings:
| Setting | Description |
| Select Store | Select the store for which you are generating the Standing Order Log Summary report. If you are multi-store, you can also select All Stores to generate a combined list. |
| Sort By | Select whether you want to sort the report by customer, store, or frequency (recurrence pattern). |
| Report Type | Select whether you want to generate a Detail report or a Summary report. |
| Date Range | If you are creating a Detail report, specify a date range. The report will include all orders created from standing order templates in the range. |
