Product Comparison Report

From FloristWiki

Jump to: navigation, search

Contents

The Product Comparison report allows you to view a comparison of two sales date ranges or the same sales date range for two stores. For example, you may want to compare Valentine’s Day sales from last year to this year. Or you may want to compare two stores’ performance on a certain day. Detail and Summary reports can be printed. The Detail report compares sales by product code and product category, while the Summary report compares sales by product category only.

The Product Comparison – Date Range Summary Report compares data by product category. The Product Comparison – Date Range Detail Report compares data on a product code level. The product codes are also totaled out by product category

Generating a Product Comparison Report

To print the Product Comparison report:

  1. On the FTD Mercury Main Menu, click Business Reports.
  2. Double-click on the Product Comparison Report icon to open the template.
  3. If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
  4. Specify the information that you want to compare:
    • Select Store – Select a store. If you are comparing data between stores, you will select the second store in the next field.
    • Comparison Type – If you are comparing two dates or date ranges, select Date. If you are comparing two store’s data for a given date or date range, select Store and then select the store in the drop-down list.
    • Report Type – Select if you want to print the Detail or Summary report. The Detail report lists totals by product category. The Summary report lists totals by product code.
    • Sale Type – Select if you want to include Inventory sales, Wire Out sales, or Both.
    • Date Range – Specify the sales date range you want to compare. If you are comparing two stores’ data, this is the date range that you are comparing between the two stores.
    • Comparison Dates – This field is active only if you are comparing dates ranges for the same store. Specify the date range that you want to compare to the first date range.
    • Date Type – Specify whether you want to generate the report by Delivery Date or Sale Date.
  5. Click Finish. The report generates and opens in Excel.
  6. To print your report from Excel, on the File menu, click Print.
  7. If you want to save the report from Excel, on the File menu, click Save.

Product Comparison Report Window

The Product Comparison Report window enables you to configure settings for the Product Comparison report.When you are finished configuring settings, click Finish to generate the report and open it in Microsoft Excel.

The Product Comparison Report window contains the following settings:

Field Description
Select Store Select the store for the report. If you are comparing data between two stores, you select the second store in the Comparison Type area.
Comparison Type Select whether you want to generate a comparison report by date or by store. If you select Store, choose the store you are comparing the store in the Select Store list against.
Report Type Select whether you want to generate a Detail Report or a Summary Report.
Sale Type Select whether you want to include Inventory sales, Wire Out sales, or Both.
Date Range Specify the sales date range you want to compare. If you are comparing data from two stores, this is the sales date range you are comparing between the two stores.
Comparison Dates This area is only enabled if you are comparing date ranges from the same store. Specify the date range you want to compare to the values set in the Date Range area.
Date Type Select whether you want to generate the report by delivery date or sale date.



Back to Business Reports

Personal tools