Building the Strategic Pricing Analysis File

Prior to viewing the analysis data for strategic prices and strategic freight, run the Strategic Pricing Analysis Build utility to gather data from your sales transactions about how items on orders were priced and how freight was calculated. The system gathers the information for the date range you set. You can then review and analyze the information in the Strategic Pricing Analysis window .

Only one analysis build file can exist at a time. If you have an existing file, creating a new file overwrites the old file. If you want to analyze data for a different date range, a different branch type, or customer type, you need to rebuild the file with different selections.

Note: The build is not required to analyze price overrides.

The parameters included in the analysis file display at the bottom of the Strategic Pricing Analysis window.

To build the Strategic Pricing Analysis file:

  1. From the Maintenance > Price Maintenance > Strategic Pricing > Strategic Pricing Analysis menu, select Strategic Pricing Analysis Build to display the Strategic Pricing Analysis Build window.

  2. In the Start Date and End Date fields, enter the first and last dates in a range of dates for which to collect data.

  3. In the Branch Selection area, select whether to collect data by price branch or ship branch on each order. The selection you make here determines which branch data is available when you analyze the pricing data by branch.

  4. In the Customer Selection area, select whether to collect data by ship-to customer or bill-to customer on each order. The selection you make here determines which customers are included in the file.

  5. Do one of the following to create the Strategic Pricing Gap Analysis file:

  1. To run the build immediately - Select File > Begin.

  2. To schedule the file to run later - Select Options > Schedule and select when and how often to run the build.

See Also:

Strategic Pricing Analysis Tools Overview

Strategic Pricing Gap Analysis Overview