Cover Page Notes:

Requested Distributor vs. Reported As

Not Authorized Brand Rep

No Records Found

A.

Name the report

From the main distribuLink window:

1. Click Request Chain Division Pricing Reports.

2. If desired, enter a different name in the Report Name field.  

_________________________________________________________________

B.

If desired, select a query

The Selected Query and Name for New Query fields are used to save and re-use report setups.  See Saving and using queries for more information.

_________________________________________________________________

C.

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.

_________________________________________________________________

D.

Select the type of costs and the grouping

1. Select the type of costs to be included in the report by clicking any combination of Regular Cost, Promotional Cost, and/or Informational Cost.

Note: Always leave both Promotional and Informational Costs checked when promotion information is required.  

2. Select how the report will be grouped from the Group By options.  

Items lists each item, followed by each distributor’s pricing for that item.

Distributors lists each distributor, followed by the items sold by that distributor.

Normally you will select to group by Items.  This will allow you to compare the cost for an item across all distributors.  See the Sample reports for a visual description.

_________________________________________________________________

E.

Select one or more Chain Divisions

1. Enter the first part of the Chain Name, followed by an asterisk.

2. Click Find.

3. Select one chain from the Chains list.

4. Select one or more areas from the Geography list.

5. Click Refresh Chain Division.

6. Select one or more Chain Divisions.

_________________________________________________________________

F.

Select one or more Maintained Brands

1. Select one or more Maintained Brands.  

Note: If you prefer, you can leave the list with all brands selected.  However, including all brands may generate a very large report.  Reports over 2MB cannot be e-mailed.

_________________________________________________________________

G.

If desired, select Package/Size Criteria

1. If desired, use the Package/Size Criteria (Optional) fields to limit the report to specific packs or sizes.  These fields are not required.

• Size Description: The size of a single unit. For example, enter 16 and select OZ to limit your report to 16-ounce cans.

Important Note: Use OZ for products measured in ounces or fluid ounces.  Do not select FL OZ, as this will not return any data.  

• Packaging: Select from the drop-down list to choose a specific item packaging, such as BOT (bottle) or CAN.    You can leave this at Not Selected if you do not need to specify the packaging.

• Select Pack Configuration: The pack configuration describes the components of the item.  To limit your report to cases of four 6-packs, select Case of 24 CONTAINS 4 - 6 packs.

Note:  If your pack configuration is not listed, you can click Enter Pack Configuration and complete the containing and of fields.

_________________________________________________________________

H.

Select the Format, Delivery Type, and run the Report

1. Select a Format.

2. Select a Delivery Type.

3. Click Report.

_________________________________________________________________