Menu Path: Customer Service Order Options Pricing Price Book/Product Profit Price Maintenance
Define pricing for a price book / product using product gross profit information.
Use Price Book/Product Profit Price Maintenance to link a product to a price book to create a price record. This window is similar to Price Book Price Maintenance, with the difference being that you can view gross profit percentage and percentage off the base price at each break level for the selected product. The base price is the first quantity break price. For more information, see Price Logic FAQ.
Note Use the Sales tab in Customer Maintenance to associate customers to price books.
Use the top of the window to select the type of record being created, updated, or deleted. Use the three tabs at the bottom of the window to enter or update information for that record. You must first select from the top section before you can enter pricing in the tabs.
Note Navigation is by ascending product code, and then by descending start date for the selected price book. For example, if you have three price records for the same price book/product code with start dates of 01/01/2020, 01/01/2021, and 01/01/2022, you would see the 01/01/2022 record first. Clicking the Next button displays the 01/01/2021 record second, and then clicking the Next button again displays the 01/01/2020 record last.
Button |
Description |
Exit |
Click this button to close the Price Book/Product Profit Price Maintenance window. |
New |
Click this button to create a new price book price record. |
Update |
Click this button to edit the selected price book price record. |
Delete |
Click this button to delete the selected price book price record. |
OK |
Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon. |
Cancel |
Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon. |
First |
Click this button to display the first price book price record. |
Prev |
Click this button to display the previous price book price record. |
Next |
Click this button to display the next price book price record. |
Last |
Click this button to display the last price book price record. |
Cost Matrix |
Click this button to display Purchase Cost Matrix Maintenance, which allows you to define a cost matrix for a selected supplier and product or cost class. |
Commission Rate Maintenance |
Click this button to display Commission Rate Maintenance, which allows you to define sales representative commissions. |
Ship and Debit |
Click this button to display Ship and Debit Maintenance, which allows you to define criteria for shipper rebates. |
Product Inventory Reservations |
Click this button to display Product Inventory Reservation Maintenance, which allows you to reserve product quantities for specific customers or customer divisions. Note If you do not have permission to access Product Inventory Reservation Maintenance, click this button to display Product Inventory Reservation Inquiry, which allows you to view reserved product quantities for specific customers or customer divisions. |
Customer Inventory Reservations |
Click this button to display Customer Inventory Reservation Maintenance, which allows you to reserve product quantities for specific customers or customer divisions. Note If you do not have permission to access Customer Inventory Reservation Maintenance, click this button to display Customer Inventory Reservation Inquiry, which allows you to view reserved product quantities for specific customers or customer divisions. |
Sales Restrictions |
Click this button to display Sales Restriction Maintenance, which allows you to define sales restrictions on products, product categories, or product subcategories. Note If you do not have permission to access Sales Restriction Maintenance, click this button to display Sales Restriction Inquiry, which allows you to view sales restrictions on products, product categories, or product subcategories. |
Companion Order |
Click this button to display Companion Order Inquiry, which allows you to view orders for a companion product. |
Notes |
Click this button to display Notes Entry, which allows you to view and enter notes for a selected price record. |
Field or Button |
Description |
Enter a price book, or click the Lookup button to select a price book. |
|
This field displays the short description for the selected price book. |
|
Select this check box if you want this price to be ignored by margin checking, if margin checking is turned on for the related product. This check box is cleared by default. Note For more information, see Gross Margin Testing FAQ. |
|
Enter a product code, or click the Lookup button to select a product code. |
|
Enter a product name, or click the Lookup button to select a product name. |
|
Select this check box to indicate this price matrix is for a special promotion. Quantity sold for special promotions is tracked separately for sales analysis and DRP purposes. Note Promotional Items displays products for which this check box is selected. |
|
Enter the first date in a range of dates for this price record, or click the drop-down arrow to select a date. Note Effective dates cannot overlap for the same price book/product/unit of measure combination. |
|
Enter the last date in a range of dates for this price record, or click the drop-down arrow to select a date. Note Effective dates cannot overlap for the same price book/product/unit of measure combination. |
|
Select Plan, Review, or Active. For more information, see Pricing Authorization Level FAQ. |
|
Select this check box to view records that have a status code of Plan or Review. If this check box is cleared, you can only navigate through records with an Active status code. For more information, see Pricing Authorization Level FAQ. |
|
Select this check box to view records with an end date before the current date. If this check box is cleared, you can only navigate through records that are not yet expired. |
|
Enter the unit of measure for the price matrix, or click the Lookup button to select a unit of measure. If this field is blank, the price matrix is based on the default selling unit of measure. |
|
This field displays the default selling unit of measure for the selected product. |
|
Click the Lookup button to select the currency of the price. This defaults to the general ledger home currency. Note The pricing logic only considers price records that are the same as the order currency. |
|
Enter a price region, click the Lookup button to select a price region. If the price is not region specific, enter All. This defaults to the price region associated with the default sales or shipping location for your user ID. Note On the Cost/Pricing tab in Customer Service Control Maintenance, you designate whether the price region will be based on sales or shipping locations. For more information, see Sales Location / Shipping Location. |
|
Enter a country for the price record, or click the Lookup button to select a country. For information on setting up countries, see Country Maintenance. |
|
Click the Lookup button and select one of the following price types for the price matrix:
|
|
Click the Lookup button to select the price or cost type to multiply against or subtract from when creating a price matrix for a product. This field is only available if an option other than Fixed Price is selected for the Price Type field. Example If you select List Price 1 for the Multiply Against field and enter 0.75 in the Mult. 1 field, then the product is sold at 75% of List Price 1. |
|
Select one of the following options when entering a price matrix that includes a price multiplier or discount off of a specific price:
These radio buttons are only available if an option other than Fixed Price is selected for the Price Type field. |
|
The labels for these user-defined fields are set up on the Cost/Pricing tab in Customer Service Control Maintenance. |
|
Enter a cost to use as the basis for determining the values in the GP% and %Off fields at each price break level. This cost is stored for this price record, and can be manually changed if you update the record. Note This cost is never automatically updated. So, if the actual cost changes radically, you will need to manually change this cost to reflect the current situation. |
|
This field displays the average cost for the selected product. For more information, see cost basis. |
|
This field displays the last receipt cost for the selected product. For more information, see cost basis. |
|
This field displays the standard cost for the selected product. For more information, see cost basis. |
|
Enter a family price code if applicable, or click the Lookup button to select a family price code. For more information, see Price Logic FAQ. |
|
Select whether the prices for the price matrix include or exclude VAT. These radio buttons are only available if VAT-inclusive prices are allowed for the selected price region. |
Field or Button |
Description |
Enter up to 10 price break quantities. Example You enter 1000 in the Break 2 field, 10 in the Price 1 field and 7 in the Price 2 field. If a customer orders 1-999 units, the price is 10 for each unit. If a customer orders 1000 or more units, the price is 7 for each unit. |
|
Enter prices, multipliers, discount amounts, or discount percentages related to the price break quantities. The values you enter are based on the selected Price Type option. |
|
This field displays the percentage of each entered price break compared to the base price entered in the Price 1 field. |
|
This field displays the gross profit percentage for each price break. |
Field or Button |
Description |
Enter an additional charge/ credit related to the price break quantity that will automatically be created during order entry, or click the Lookup button to select an additional charge/credit. Example Charge 2 relates to Break 2; there can only be one automatic charge per price break quantity. |
|
Enter a + or - sign to designate the operation for the relevant charge. |
|
Enter an amount or percentage, depending on the additional charge selected. A $ sign or % sign appears next to the amount. |
|
Select this check box if all additional charges will be calculated for each unit of the product sold. |
Field or Button |
Description |
These fields display the price break quantities for the price matrix (entered on the Breaks - Prices tab). |
|
These fields display the prices, multipliers, or discounts related to the price break quantities for the price matrix (entered on the Breaks - Prices tab). |
|
Enter the ship and debit amount for each price break quantity. |
Field or Button |
Description |
Select one of the following options:
|
|
Select one of the following options:
|
|
Enter any notes to display during order entry when asking the user whether to add companion products to an order. This field is only available if the Prompt User radio button is selected. |
|
Select this check box if the companion product has a maximum number of uses, and then enter the number of uses. EXAMPLE You only want to give away a free product once for a companion product combination. To set this up, select this check box, and enter 1. |
|
Enter a product code for a product that is going to be a companion product for the selected rules, or click the Lookup button to select a product code. |
|
Enter a product name for a product that is going to be a companion product for the selected rules, or click the Lookup button to select a product name. |
|
Enter the unit of measure to use as a basis for calculating companion quantities, or click the Lookup button to select a unit of measure. |
|
Select one of the following options:
|
|
Enter a special price for the companion product. This field is only enabled if you select Special Price for the Pricing Option field. |
|
These fields display the price break quantities for the price matrix (entered on the Breaks - Prices tab). |
|
Enter up to 10 quantities of the entered companion product to add to orders for each price break quantity. |
|
Enter up to 10 percentages of the cost that can be billed back to the supplier if the companion product is added to an order for each price break quantity. |
|
Click this button to add the companion product to the Companion Products grid. |
|
Click this button to remove a selected companion product from the Companion Products grid. |
|
This grid displays companion products for the price matrix. Double-click a product if you want to view or edit the settings for it. |