A.

Name the report

From the main Item & Cost window:

1. Click Request Cost Reports.

2. If desired, enter a different name in the Report Name field. This will be the title of the report, and will appear on each page of an RTF-format report.

_________________________________________________________________

B.

Select the Format and Delivery Type

1. Select a Format.

2. Select a Delivery Type.

_________________________________________________________________

C.

Select the type of costs and the Retailer

1. Select the type of costs to include in the report.  Choose as many types as needed.

• Regular Cost

• Temporary Cost

• Promotional Cost

• Informational Cost

• Regular Retail

• Temporary Retail

2. Using the drop-down list, select the Retailer to be included. Leave this set to Not Selected to include all of your retailers (subscribers).

_________________________________________________________________

D.

Choose the data to include

1. Choose a Report selected option to specify the data you want to include in the report.

2. If you chose a Report selected option with date-range fields, enter the date range in the From and Through fields. (Enter as mm/dd/yyyy.)

3. An option is defaulted to Print the beginning effective date on a report if a cost or a retail is in effect at the beginning of the date range. You will normally leave this box checked.

_________________________________________________________________

E.

Select the zones

1. Select the Cost Zones to include.

All cost zones are included in the report by default. If desired, click the list once and then select as least one cost zone from the Cost Zones list.

Hold down the Ctrl key while selecting to choose more than one zone.

2. If desired, select the Retail Zones to include.

All retail zones are included in the report by default. If desired, click the list once and then select any Retail Zones that are needed.

Hold down the Ctrl key while selecting to choose more than one zone.

_________________________________________________________________

F.

Specify the items

1. Enter search criteria to select the items that will be included in the report.

Hint:  You can enter an asterisk in the Description field to include all items.

Specifying the items to include

2. If desired, use the MCAT Categories – Choose button to select one or more merchandise categories (MCATs).

Note: This limits the report to only those items that are in the MCAT. If a specific merchandise category (MCAT) is not selected, all MCATs will be used for the report.

3. If applicable, you can select an Item Group to be used for the report.

Note: Some providers use item groups in addition to or instead of MCATs.  If no item groups are selected, all item groups (if any) will be used.

_________________________________________________________________

G.

Select the sort order and run the report

1. Use the three Order By drop-down lists to select the sort order for the report.

2. The report is sorted in ascending order (lowest to highest) by default. If you desire a descending order, de-select the Asc (ascending) box.

3. Run the report.

• To display the report in a window, click Display.

• To generate a report you can place on your computer, click Report.

_________________________________________________________________

Note:  If a report is over 2MB in size, it normally will not be sent as an e-mail attachment.  Instead, you are notified by e-mail that the report is ready to download.  

Click Download from any Prescient window, Find and select the file, then click File Download to transfer it to your computer.

_________________________________________________________________