Product Price List by Commodity (ICPLC.IM18)

The Product Price List by Commodity (ibis_icplc.im18) view is used to assign commodity code(s) to a Price List. Using this view, you can view all of the commodity codes associated with the Price List entered.

Notes:

• If you have added a product to a price list in Product Price List by Product (ibis_icplp) and you are adding commodity pricing to the same price list, the price for the individual product will override the price for the product in the commodity code, even if the commodity pricing is lower.

• If you have commodity pricing where the Product Line and Product Group are ** AND you have commodity pricing for the same price list for a specific product line and product group (i.e. product line is not **), the price for the specific product line and product group will be considered as the best price even if the price for the ** commodity is lower.

• If you have commodity pricing where the Product Group is a specific group and the Product Line is ** AND you have a product line/group of **, the record for the specific product group will override the price for the product line/group that is ** even if the commodity pricing is lower.

The following list defines every field available in the product price list by commodity (icplc) table in alphabetical order:

• Apply to All Quantity Break Levels - from the drop list, select Yes to apply the percentage or multiplier entered in QB1 to all quantity break levels for the pricing method entered, or No (default) to have the system disregard quantity break levels.
  • If you select Yes, you must enter the pricing method values for the quantity breaks required in the pricing method value section. Note: Once you add the pricing method value for the required quantity breaks, the Apply to All Quantity Break Levels field returns to its default value of No.

• Classification - enter or select from the look up a classification code for the commodity. This field is validated against the ABC Class Codes (ibis_icc.im09) table. Once the price list by commodity record has been created, you cannot edit this field.
  • Note: You cannot enter a classification code of X; this classification code is reserved for products scheduled to be deleted.

  • You can enter * in this field to select all classification codes with the exception of class code X.

  • This field defaults to * when you enter ** in the product line field, to select all product lines or when you enter ** in the product group field to select all product groups associated with the product line.

• Commodity - displays the commodity code associated with the product line and product group entered when the product price list by commodity record was created. You cannot edit this field.

• Company - the company field is available when you create a new price list by commodity record. The company defaults to the company assigned to your user id in the Session Parameters view. You can change the default company during the price list by commodity creation process only. Once the price list by commodity record is created, the company to which the record is associated displays in the General section (at the top of the view).

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Expiry Date - enter or select from the calendar query the date on which the price list by commodity expires. This field is an optional field used with special, contract and common quote price lists. The expiry date field defaults to the end date assigned to the price list from Product Price Lists (ibis_icpl.im18). You can modify this field as required.
  • Note: To change the expiry date for a flyer type price lists, please use the End Date field in the Product Price Lists (ibis_icpl.im18) view.

• Flyer Page Number - this field is only available for flyer type price lists. Enter the page number on which the product line/product group appear for the current flyer. This is a mandatory field for flyer type price lists.

• Modification Counter - this field is not maintainable. The date and time the record was last modified.

• Modified By - this field is not maintainable. The user or system process that last modified the record.

• Modified On - this field is not maintainable. The date on which the record was last modified.

• Price List - enter or select from the look up a price list code. This field is validated against the Non Master Price Lists (ibis_icpl.non_mpl_lookup) view. You can enter any price list code with the exception of master price lists (MPL); commodity pricing cannot be based on a master price list.

  Once a Price List is entered, specific fields are available depending on the price list type. The following fields are available for each price list type:

• Pricing Method - enter or select from the drop list a pricing method for the product price list by commodity record. Valid options include:
  • D - Discount off Master Price
    • When you use Discount off Master Price, the discount entered in the pricing method value field for each QB (as required) must be between -100.00 and 100.00 or a valid chain discount with no more than 11 characters.

  • M - Markup on Cost
    • When you use Markup on Cost, enter a markup value in the pricing method value field for each QB (as required). The selling price is calculated based on the primary supplier's replacement cost for the product plus the markup value entered.

  • G - Gross Margin
    • When you use Gross Margin, enter a percent in the pricing method value field for each QB (as required). The selling price is calculated based on the primary supplier's replacement cost for the product multiplied by the gross margin percent entered.

  • A - Master Price Multiplier
    • When you use the Master Price Multiplier method, enter a factor (multiplier) in the pricing method value field for each QB (as required). The multiplier must be between 0.0 and 99.9999. The selling price is calculated based on the master price for the product multiplied by the factor entered.

• Pricing Method Value - 1st QB - enter a value for the 1st quantity break to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Pricing Method Value - 2nd QB - enter a value for the 2nd quantity break to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Pricing Method Value - 3rd QB - enter a value for the 3rd quantity break to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Pricing Method Value - 4th QB - enter a value for the 4th quantity break to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Pricing Method Value - 5th QB - enter a value for the 5th quantity break to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Pricing Method Value - 6th QB - enter a value for the 6th quantity break to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Pricing Method Value - 7th QB - enter a value for the 7th quantity break to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Product Group - enter or select from the look up the product group to attach to the price list. This field is validated against the Product Group (ibis_icc2.im09) table. You can enter ** in this field to select all product groups associated with the product line entered.
  • Note: If ** is entered in the product line field to select all product line codes, the product group field defaults to ** and cannot be modified.

• Product Line - enter or select from the look up the product line assigned to the price list by commodity record. This field is validated against the Product Line (ibis_icc1.im09) table. You can enter ** in this field to select all product line codes.

• Start Date - enter or select from the calendar query the date on which price list by commodity comes into effect. This field is an optional field used with special, contract and common quote price lists. The start date field defaults to the start date assigned to the price list from Product Price Lists (ibis_icpl.im18). You can modify this field as required.
  • Note: To change the start date for flyer type price lists, please use the start date field in the Product Price Lists (ibis_icpl.im18) view.

  • If a sales order is dated prior to the start date, the special, contract, common quote or flyer pricing is not applied.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.