Setting up price cost multipliers for Product Import

Use PI Price Cost Multiplier Setup 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 determines how records are updated.

  1. Select Product Import > Setup > Price Cost Multiplier.
  2. Click New.
  3. Specify this information:
    Import Types
    Specify the import type you want to define price/cost multipliers for. This must be a valid import type set up in PI Import Definition Setup.
    Supplier Group
    Specify a supplier group. Each import type must be identified with at least one supplier group.
    Warehouse
    Optionally, specify a warehouse. To define price/cost multipliers for this supplier group that apply to all warehouses, leave this field blank.
  4. Click Save.
  5. In the Required view, complete the required fields and other fields appropriate for your import type.
  6. In the Price Cost Multipliers view, set up a sequence in which prices and costs are calculated. You can specify a numeric value ifrom 1 to 5 n the Calculation Order field for Base Price, List Price, Replacement Cost, Standing Cost, or Last Foreign Cost. Use each number once. If you specify the same number in two or more fields, you are prevented from saving the record.

    Use this sequence to control values that may be calculated using other values, such as Method, Multiplier, or Addon. For example, to calculate the base price using the new replacement cost, you would set the replacement cost calculation order to occur before the base price calculation.

  7. In the Cross References section, define the cross reference fields 1-4 mapped in PI Import Definition Setup. These fields, Interchange, Bar Code, Auto Price, and Vendor Part, determine how records are created or updated in Product Extended Product Cross Reference Setup using the values in the cross-reference fields.
  8. In the Updating section, select an update code. The update code determines if all good records imported for this supplier group, and warehouse, if applicable, default with a code of Update, Hold, or Ignore. Records that are ignored are not updated, but may be saved depending on the selection in the Save Detail field. A record placed on hold requires operator intervention before it can be updated.
  9. In the Notes section, select an option: Hold, Ignore, or Update. If you have mapped the Notes field in PI Import Definition Setup, you can control how the notes update the catalog or product notes files in the product entity.
  10. In the Exceptions view, specify how to handle exceptions. The settings in the Exceptions view determine whether information in each import file record is imported and whether data used has changed. You may want to identify certain information on each import record that should not be updated. Otherwise, the record is placed on hold if it is different than the current product record. These exceptions can be set up in PI Price Cost Multiplier Setup-Price/Cost Multipliers. Only those records that currently exist in your Product entity files are impacted by these settings.
  11. Click Save.