Price Lists by Products (ICPLP.IM18)

The Product Price List by Product (ibis_icplp.im18) view is used to assign products to a price list. Using this view, you can see all of the products associated with the price list entered.

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

• Ad Space - this field is reserved for internal TECSYS use only.

• 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 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.

• Company - the company field is available when you create a new price list by product 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 product creation process only. Once the price list by product record is created, the company to which the record is associated displays in the General section (at the top of the view).

• Contract Cost - enter the unit cost of the product for the current contract price list. For sales priced with this contract price list, this cost is reported on the S/A Contract Sales Print (SA87) report. When a contract price is used, the report displays a more realistic gross margin for the contract than when an average cost is used. If the contract cost is left blank, the average cost is reported.
  • The average cost is used to calculate gross margins on all other sales reports and is used for general ledger costing entries. The Contract Sales Report is the only report that uses contract cost.

  • The contract cost is used in the calculation of the contract/flyer landed cost field in this view.

• Contract/Flyer Landed Cost - this is a system populated field that is used with contract and flyer prices lists only. The landed cost is calculated based on the cost entered in the contract cost field or in the flyer cost field. The landed cost calculated here may be different from the landed cost for the product calculated in P/O Purchasing Information (ibis_po13) due to different base costs.
  • Note: The P/O Landed Cost Recalculation (ibis_po17) view does not recalculate the contract landed cost because it is intended to represent the landed cost of the contract at the time the contract was created.

• 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 for the product 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 Cost - enter the unit cost of the product for the current flyer price list. For sales priced with this flyer price list, this cost is reported on the S/A Flyer Sales Print (SA85) report. The flyer cost is used in the calculation of the contract/flyer landed cost field in this 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.

• Gross Margin Percentage for Quantity Break 1 - this field is available when the pricing method is set to Gross Margin. Enter a percentage for quantity break 1. The selling price is automatically calculated. The Gross Margin pricing method uses the entered GM% and the replacement cost for the product (for the primary supplier only) to calculate the selling price.

• Gross Margin Percentage for Quantity Break 2 - this field is available when the pricing method is set to Gross Margin. Enter a percentage for quantity break 2 (as required). The selling price is automatically calculated. The Gross Margin pricing method uses the entered GM% and the replacement cost for the product (for the primary supplier only) to calculate the selling price.

• Gross Margin Percentage for Quantity Break 3 - this field is available when the pricing method is set to Gross Margin. Enter a percentage for quantity break 3 (as required). The selling price is automatically calculated. The Gross Margin pricing method uses the entered GM% and the replacement cost for the product (for the primary supplier only) to calculate the selling price.

• Gross Margin Percentage for Quantity Break 4 - this field is available when the pricing method is set to Gross Margin. Enter a percentage for quantity break 4 (as required). The selling price is automatically calculated. The Gross Margin pricing method uses the entered GM% and the replacement cost for the product (for the primary supplier only) to calculate the selling price.

• Gross Margin Percentage for Quantity Break 5 - this field is available when the pricing method is set to Gross Margin. Enter a percentage for quantity break 5 (as required). The selling price is automatically calculated. The Gross Margin pricing method uses the entered GM% and the replacement cost for the product (for the primary supplier only) to calculate the selling price.

• Gross Margin Percentage for Quantity Break 6 - this field is available when the pricing method is set to Gross Margin. Enter a percentage for quantity break 6 (as required). The selling price is automatically calculated. The Gross Margin pricing method uses the entered GM% and the replacement cost for the product (for the primary supplier only) to calculate the selling price.

• Gross Margin Percentage for Quantity Break 7 - this field is available when the pricing method is set to Gross Margin. Enter a percentage for quantity break 7 (as required). The selling price is automatically calculated. The Gross Margin pricing method uses the entered GM% and the replacement cost for the product (for the primary supplier only) to calculate the selling price.

• Master Price List - 1st QB - if the pricing method is set to Discount off Master Price or Master Price Multiplier, the master price list price for the first quantity break of the product displays in this field.

• Master Price List - 2nd QB - if the pricing method is set to Discount off Master Price or Master Price Multiplier, the master price list price for the second quantity break (as required) of the product displays in this field.

• Master Price List - 3rd QB - if the pricing method is set to Discount off Master Price or Master Price Multiplier, the master price list price for the third quantity break (as required) of the product displays in this field.

• Master Price List - 4th QB - if the pricing method is set to Discount off Master Price or Master Price Multiplier, the master price list price for the forth quantity break (as required) of the product displays in this field.

• Master Price List - 5th QB - if the pricing method is set to Discount off Master Price or Master Price Multiplier, the master price list price for the fifth quantity break (as required) of the product displays in this field.

• Master Price List - 6th QB - if the pricing method is set to Discount off Master Price or Master Price Multiplier, the master price list price for the sixth quantity break (as required) of the product displays in this field.

• Master Price List - 7th QB - if the pricing method is set to Discount off Master Price or Master Price Multiplier, the master price list price for the seventh quantity break (as required) of the product displays in this field.

• Maximum Discount - enter the maximum discount percentage allowed for the product.
  • If a discount percent greater than the maximum discount is assigned on a sales order or invoice, a warning message can display advising the operator that the discount given is greater than the maximum discount percentage for the product. This warning message only displays when the Enable Gross Margin/Discount Warning check box is selected in CC00/Order Entry.

  • Note: A minimum discount of 0.00% means that any discount applied to the product will trigger the warning message if Enable Gross Margin/Discount Warning is selected in CC00/Order Entry.

• Maximum Quantity Limit - this field applies to contract price lists only. Enter the maximum quantity that can be sold of the current product on the current contract. Sales-to-date priced per this Contract are accumulated. If unit sales-to-date exceed the maximum limit, a warning message displays during order entry in Order and Quote Entry (OE30), Invoice Direct Bill and Credit Note Entry (IN41) or Retail Cash Counter Invoice Entry (RS41).
  • For example, a customer contracts to buy 5,000 pens at a special price of $1.00 (which you brought into stock at a special cost of $.50). You may wish to stop selling those pens for $1.00 once 5,000 have been sold. Any pens sold beyond 5,000 will be priced at the regular price because your cost on sales beyond 5,000 units is not $.50.

• Minimum Gross Profit - enter the minimum gross margin percent (GM%) acceptable for the product. A minimum gross percent is assigned to products to ensure that the selling and discounted prices for the product still result in a profit.
  • If the minimum gross percent on a sales order or invoice falls below the value entered here for the product/price list record, a warning message can display advising the operator that the minimum gross percent is less than the minimum gross percent allowable for the product. This warning message only displays when the Enable Gross Margin/Discount Warning check box is selected in CC00/Order Entry.

• 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.

• Net Price Item - from the drop list, select Yes to exclude the product from commodity based discounts, or No (default) include the product in commodity based discounts. This field is only available for Master Price Lists.
  • A value of Yes indicates that the current product is not included when the commodity code assigned to the product is used to discount prices in the Product Price List by Commodity (ibis_icplc.im18) price list is used.

  • Here's an example to illustrate how this field works: all products within commodity code XXXX are discounted at 20%, except for product 1234 which has the net price item field set to Yes.

  • Note: The net price item field only applies to commodity discounts. If a product level discount is defined in Price Lists - Products, the discount is applied regardless of the setting in the net price item field.

• Price List - enter or select from the look up a price list code. This field is validated against the Product Price Lists (ibis_icpl.im18) table. Once the record is saved, you cannot edit this field.

  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:

Note: If the product and price list have been transferred to the future price file in Future Product Price Lists (ibis_im21), a warning message displays advising that any changes made now may be lost once the future prices have been transferred by Future Pricing Transfer (ibis_im22). You may continue making changes in Price Lists - Products, however when Future Price Transfer runs the pricing from im21 will replace any changes made in im18.

• Price Per - 1 - displays the price per quantity break 1 for the quantity break code from the Quantity Break Codes (ibis_im05). If there is no per value for the QB in IM05 then this field defaults to the value entered in the price per UOM field.

• Price Per - 2 - displays the price per quantity break 2 for the quantity break code from IM05. If there is no per value for the QB in IM05 then this field defaults to the value entered in the price per UOM field.

• Price Per - 3 - displays the price per quantity break 3 for the quantity break code from IM05. If there is no per value for the QB in IM05 then this field defaults to the value entered in the price per UOM field.

• Price Per - 4 - displays the price per quantity break 4 for the quantity break code from IM05. If there is no per value for the QB in IM05 then this field defaults to the value entered in the price per UOM field.

• Price Per - 5 - displays the price per quantity break 5 for the quantity break code from IM05. If there is no per value for the QB in IM05 then this field defaults to the value entered in the price per UOM field.

• Price Per - 6 - displays the price per quantity break 6 for the quantity break code from IM05. If there is no per value for the QB in IM05 then this field defaults to the value entered in the price per UOM field.

• Price Per - 7 - displays the price per quantity break 7 for the quantity break code from IM05. If there is no per value for the QB in IM05 then this field defaults to the value entered in the price per UOM field.

• Price Per Unit of Measure - enter or select from the look up a unit of measure (UOM) code. This field is validated against the Units of Measure (ibis_icm.im09) table. The UOM code, when applied to the Product, describes the way the selling price is expressed.

  The price per UOM field can be updated for Contract, Special, Common Quote and Flyer Price Lists when the Pricing Method is one of the following:

  • Fixed Price
  • Markup on Cost
  • Gross Margin

  Note: Price per UOM codes can also be assigned to a quantity break level in Quantity Break Codes (ibis_im05). For example, QB1 might have a Price per EA, and QB2 might have a Price per DZ. If the quantity break has a Price per Unit code assigned, the QB Price per Unit code has a higher priority than the price per UOM code from icplp.im18.

• Pricing Method - enter or select from the drop list a pricing method for the product price list by commodity record. Valid options include:
  • F - Fixed Price
    • When you use the Fixed Price method, enter a percent in the gross margin percentage fields for each QB (as required). The selling price is calculated based on the price for the product multiplied by the gross margin percent.

  • 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 - this field is only available when the pricing method is discount off master, markup on cost or master price multiplier. 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 - this field is only available when the pricing method is discount off master, markup on cost or master price multiplier. Enter a value for the 2nd quantity break (as required) 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 - this field is only available when the pricing method is discount off master, markup on cost or master price multiplier. Enter a value for the 3rd quantity break (as required) 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 - this field is only available when the pricing method is discount off master, markup on cost or master price multiplier. Enter a value for the 4th quantity break (as required) 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 - this field is only available when the pricing method is discount off master, markup on cost or master price multiplier. Enter a value for the 5th quantity break (as required) 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 - this field is only available when the pricing method is discount off master, markup on cost or master price multiplier. Enter a value for the 6th quantity break (as required) 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 - this field is only available when the pricing method is discount off master, markup on cost or master price multiplier. Enter a value for the 7th quantity break (as required) to be applied to the pricing method selected. The value entered is used to determine the selling price for the product.

• Product Code - enter or select from the lookup a product code. This field is validated against the Products (ibis_ici1.im13) table. Once the record is saved, you cannot edit this field.
  • Note: If you are updating the price for a common product that is on any price list except a master price list, you can use the wild card (*) to update the price for all of the common products. For example, if your common products are PENCIL-HB, PENCIL-2B, PENCIL-3B, and PENCIL-4B, you can enter PENCIL-* to update the price for all of the PENCIL common products.

• Quantity Break Code - enter or select from the lookup a quantity break (QB) code (as required). This field is validated against the Quantity Break Code Query (ibis_icq) view. The QB defines the quantities at which selling price breaks occur.

  The QB code can be updated for contract, special, common quote and flyer price lists when the pricing method is one of the following:

  • Fixed Price
  • Markup on Cost
  • Gross Margin

• Replacement Cost - displays the replacement cost for the product. This is a system calculated field.

• Selling Price - enter the retail price of the product in this field. The retail price is the manufacturer's suggested retail price (MSRP) for the product. This field is only available for master price lists, and is not used in pricing on sales orders or invoices. The retail selling price prints on Inventory Price Book Print (ibis_ic84) and on Product Price List Print (ibis_im19).

• Selling Price - 1st QB - enter the selling price for the product on the current price list. The gross margin percent (using replacement cost) is automatically calculated once the selling price is entered.

• Selling Price - 2nd QB - enter the selling price for the second quantity break (as required) for product on the current price list. The associate gross margin percent QB (using replacement cost) is automatically calculated once the selling price is entered.

• Selling Price - 3rd QB - enter the selling price for the third quantity break (as required) for product on the current price list. The associate gross margin percent QB (using replacement cost) is automatically calculated once the selling price is entered.

• Selling Price - 4th QB - enter the selling price for the forth quantity break (as required) for product on the current price list. The associate gross margin percent QB (using replacement cost) is automatically calculated once the selling price is entered.

• Selling Price - 5th QB - enter the selling price for the fifth quantity break (as required) for product on the current price list. The associate gross margin percent QB (using replacement cost) is automatically calculated once the selling price is entered.

• Selling Price - 6th QB - enter the selling price for the sixth quantity break (as required) for product on the current price list. The associate gross margin percent QB (using replacement cost) is automatically calculated once the selling price is entered.

• Selling Price - 7th QB - enter the selling price for the seventh quantity break (as required) for product on the current price list. The associate gross margin percent QB (using replacement cost) is automatically calculated once the selling price is entered.

• Space - this field is reserved for internal TECSYS use only.

• Start Date - enter or select from the calendar query the date on which price list by product 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.

• Ticketing and Misc. Cost Component - this is an optional field. Enter the ticketing and miscellaneous costs associated with the current product. These costs appear in the ticketing recovery GL account when the product is invoiced. If the cost to have the product ticketed is $0.05, then the ticketing recovery GL account is credited $0.05. (The ticketing recovery GL account is defined in CC00/Invoicing/General Ledger.)

• Ticketing and Misc. Price Component - this is an optional field. Enter the price associated with the ticketing and miscellaneous costs required to ticket the current product. For example, the cost to have the product ticketed is $0.05 when the Product is manufactured overseas. As a result, you increase the selling price by $0.05 to cover this cost. You can have the ticket and miscellaneous price component excluded from the commission calculation and royalty calculation depending on the set up in S/A Commission Rates (ibis_sa02) and S/A Royalty Rates (ibis_sa05).

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