Wire Reconciliation Report

From FloristWiki

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.

The following message types are excluded from the report: Error, EFOS Rejected, Pending, Rejected, Cancel, and Confirmation.

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:

Setting	Description
Wire Service	Select the wire service for which you are generating this report.
Reconciliation Status	Select the status(es) you want to include in the report. You can select Disputed, Reconciled, and/or Not-Reconciled.
Delivery Date Range	Select the start and end delivery dates for the report.
Data Source	Select whether you want the data source to be statement reconciliation items or system wire/phone orders.
Sort Option	Select whether you want the report sorted by Mercury ID, shop code, or reconciliations status.

---

Back to Business Reports