PI Price Cost Multiplier Setup overview

Product Import > Setup > Price Cost Multiplier

Function acronym: PISP

Use this page to set up specific calculation styles based on supplier group and, optionally, warehouse. The supplier group is used during the import process to calculate new prices and costs, and to determine how records are updated.

You can use these toolbar functions to manage information:
  • To create a new multiplier, click New in the toolbar. Specify the new multiplier in the form that is displayed.
  • To modify an existing multiplier, select the import type from the grid and click Edit.
  • To delete a multiplier, select the import type from the grid. Click Delete.

A supplier group may encompass several price types and categories, or may be set up as a different subset of price/cost information altogether. This means you might be required to set up a PI Price Cost Multiplier Setup record for each supplier group. This results in several price/cost multiplier records for one import type. Supplier groups are user-defined values, so the setup is not controlled by the Distribution SX.e system, nor are they table-driven.

The supplier group record that is used depends on the Product Catalog Setup or Product Setup records. When an item is imported, a check is made for an existing product record. Based on the supplier group defined on that product or catalog record, the PI Price Cost Multiplier Setup record is validated and its price/cost multipliers are applied. If a product record is not found, and the line item is a new product, the supplier group defined on the PI New Product Default Setup record is used. If no supplier group is defined on either the Product Catalog Setup or Product Setup record, the line item is not imported. The product is not updated by Product Import.

Price/cost multiplier records can be set up for a specific warehouse. They can also be used by all warehouses that do not have a specific PI Price Cost Multiplier Setup record attached.

The setup for PI Price Cost Multiplier Setup is separated into two tabs: General and Exceptions. The General tab contains these sections to set up how to handle data being imported.

  • Required
  • Price Cost Multipliers
  • Interchanges
  • Updating
  • Notes

Use the Exceptions tab to set up how to handle data being imported that has exceptions.