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:

1. On the FTD Mercury Main Menu, click Business Reports.
2. Double-click on the Standing Order Log icon to open the template.
3. If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
4. 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).
5. Select whether you want the report sorted by Customer, Frequency, or Store.
6. In the Report Type area, select Summary.
7. 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.
8. Click Finish.
9. To print your report from Excel, on the File menu, click Print.
10. 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.

---

Back to Business Reports