Use the Pricing Level Control Table from the Level Pricing Settings to create and store the calculations you use to define different price levels. This table integrates with the Pricing Level Table. For a given product, you can either enter price levels directly into the Pricing Level Table, or use the Pricing Level Control Table to calculate the price level based on the prices entered in the Pricing Level Table for the product.
The results of the calculations made by this table appear in the Pricing Level Table. Each time you edit a price level in the Pricing Level Control Table, you must recalculate the formula. Therefore, price levels are already calculated before they ever appear in a sales order.
Fig. 1 - Pricing Level Control Table
The table below describes the columns of Pricing Level Control Table.
Column |
Description |
Price Level |
This value identifies the price level to be calculated. The result of the calculation appears in the Pricing Level Table. If a price level appears in both the Pricing Level Table and the Pricing Level Control Table, the calculation in the Pricing Level Control Table overrides the value in Price column of the Pricing Level Table for that price level. |
Discount Code |
The system automatically applies the amount you enter here, in the form of a discount percent, to line items at sales order entry time. For example, for price level two (see above), the system applies a 10 percent discount to sales order line items. |
Base Level |
This value identifies the price level in the Pricing Level Table you want to use as a base level when calculating a new price level. For example, price level three has a base level of two. The system pulls the price from price level two in the Pricing Level Table to use as a base price. The system then multiplies the base price by the value in the Multiplier column to produce price level three. |
Multiplier |
The system multiplies the values in the Base Level column by the values in this column, providing the main functionality of Level Pricing. The multiplier determines how much more or less than the base level price you want the calculated price level to be. For example, to increase the base level price by 50 percent, enter a multiplier of 1.50. To decrease the base level price by 50 percent, enter a multiplier of 0.50. |
Recalculate |
Each time you edit a level pricing formula, you must recalculate it. Otherwise, the system does not recognize the edit. To recalculate a formula, select the price level containing the formula, check the box at the Recalculate field , then click Add to save the changes. The system recalculates level pricing for all products at the selected price level. |
Fig. 2 - Pricing Level Table