Wire Reconciliation Report

From FloristWiki

Current revision

The Wire Reconciliation report lists disputed, reconciled and/or not-reconciled orders for a specified delivery date or date range. You may choose to pull your data from the Combined Report or from the Message Log within FTD Mercury.

Generating the Wire Reconciliation Report

To generate the Wire Reconciliation report:

1. Double-click on the Wire Reconciliation icon to open the template.
2. If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
3. When the Wire Reconciliation window opens:
   1. In the Wire Service field, click the arrow to display a list of wire services. Highlight and select the wire service for which you want to generate this report.
   2. In the Reconciliation Status section, click in any combination of the Disputed, Reconciled, and Not-Reconciled check boxes so check marks appear to indicate which statuses you wish to include in this report.
   3. In the From field of the Delivery Date Range area, click the arrow to display a calendar. Use your mouse to click on the date from which you want to list orders.
   4. In the To field, click the arrow to display a calendar. Use your mouse to click on the date that your system will end listing orders.
   5. In the Data Source section, choose to pull your reconciliation data either from the Statement Reconciliation Items (data from the Combined Report) or your System Wire/Phone Orders (data from your Message Log).
   6. In the Sort Option section, select whether you want to sort the report by Mercury ID, Shop Code, or Reconciliation Status.
   7. Click Finish. The report generates and opens in Excel.
4. To print your report from Excel, on the File menu, click Print.
5. If you want to save the report from Excel, on the File menu, click Save.

Wire Reconciliation Window

The Wire Reconciliation window allows you to configure settings for the Wire Reconciliation Report. When you have finished configuring your settings, click Finish to generate the report and open it in Microsoft Excel.

The Wire Reconciliation window contains the following settings:

Back to Business Reports