Calculating the Final Pricing for the Configurable Item
The configurable item price can be dynamically calculated and updated based on the features and options users select to ensure consistent and accurate pricing. All active pricing records are combined to provide the final price for the configurable item. An active price has a rule that matches answers users select on the product interface.
The price of item groups used as base items can't be dynamically calculated. Their price depends on the prices of their member items, and NetSuite CPQ Configurator doesn't handle those prices.
Pricing records have an internal name and a label for the product interface. You can use the sequence number to sort prices in the product interface summary. Prices with a lower sequence number are displayed higher in the summary. You can also apply multiplier and discount values to create a flexible price structure that adapts to changes in quantities and rates.
Use a dot to add decimals to price, discount, and multiplier values.
Price amounts can be sourced from materials using the Source Price from Material field. Materials derive their price from the associated item record. For more information, see Sourcing Price Information from Materials.
You can view pricing information on the product interface and use the Subtotal from the product interface as the base price. For more information, see Viewing Price Amounts on the Product Interface and Using the Subtotal as the Base Price.
To create a price:
-
In NetSuite, go to CPQ > Configurator > Product Maintenance.
-
Click Edit next to the product you want to modify.
-
On the Pricing subtab, click New CPQC Pricing.
-
Enter a descriptive name for this price.
This name is displayed under Pricing in the Audit menu of the product interface.
-
Provide a sequence number to sort the prices in the summary.
You can enter a negative or positive number. For example, -2 or 5.
-
(Optional) To define a specific date range during which this price is included in the calculations for the final item price and displayed on the product interface:
-
In the Effective Start Date field, select a start date.
Before this date, the price is inactive.
-
(Optional) In the Effective End Date field, select an end date.
After this date, the price is inactive.
Note:If you define a date range, the price must meet both the date range and the rule conditions to be active.
-
-
In the Label field, enter the price label displayed in the summary and in the Audit > Pricing menu on the product interface. You can format the text by changing the paragraph font and size or by making the text bold, italic, or underlined.
Note:You can also include information from answers users select on the interface by using resolve expressions. Enter question and answer codes separated by the forward slash character and enclosed in curly braces. For example, {A/1}. Question and answer codes are replaced with the corresponding answer value. For more information, see Obtaining Answer Data with Resolve Expressions.
-
To provide the price amount, two options are available:
-
In the Price field, enter a number without the currency symbol. You can also obtain the price value using resolve expressions.
-
In the Source Price from Material, select the material from which you want to source the price amount. For more information, see Sourcing Price Information from Materials.
Regardless of the option you choose, the price amount can be multiplied by the multiplier and the discount.
The currency depends on the one assigned to the customer selected on the transaction.
-
-
In the Discount field, enter a number or a resolve expression to apply a reduction to the usual price. For example, 0.5.
If you leave this field blank, the default value is 1.
-
In the Price Multiplier field, you can enter a number or a resolve expression. The price is multiplied by this value.
For example, you can use a resolve expression to multiply the price by the quantity selected by users in an answer. If you leave this field blank, the default value is 1.
-
In the Rule field, provide the condition that determines whether the price is added to the summary and the Subtotal field of the top bar.
Enter question and answer codes separated by the forward slash character— for example, A/1. Use operators to combine multiple question and answer sets—for example, A/1&B/2. For more information, see Activating or Hiding Building Blocks with Rules.
If you source the price from a material, the material rule is applied to the pricing record through the Material Rule field.
-
(Optional) To include an additional rule in the pricing rule, select a rule category. The price is active if its rule and the rule of the category match an answer selected by users. For more information, see Working with Rule Categories.
-
To include this price in the Total field on the product interface top bar one time only, check the One time charge box.
For example, you can use this option for shipping charges.
-
To hide the price amount in the summary, check the Hide price amount box. The price label is still displayed on the product interface, and the amount is included in all pricing calculations.
-
To hide both the price label and amount in the summary, check the Hide price line box. The price amount is still included in all pricing calculations.
-
Click Save.
To copy or delete prices, see Working with Product Building Blocks.
Sourcing Price Information from Materials
Price amounts can be sourced from materials using the Source Price from Material field. Materials derive their price from the associated item record. If you use the Multiple Prices and the Multiple Currencies features, item records include price levels organized by currency where you can specify price amounts for each level. If the item record include multiple price levels and currencies, the price level and currency for the material depends on those assigned to the customer specified on the transaction. For more information, see Setting Up Item Pricing and Using Multiple Pricing.
If you use the Multiple Quantity feature, also the quantity ranges specified on the item record are taken into account for the material price. For more information, see Using Quantity Pricing.
When prices change based on the quantity you sell for a material, the Subtotal amount for a single configured item may change when users increase or decrease the quantity on the product interface.
Viewing Price Amounts on the Product Interface
On the product interface, all active prices are displayed in the summary with their amount—unless you hide a particular price amount or an entire price line. Users can find more information about active prices under the Pricing option in the Audit menu. The price for a single configured item is displayed in the Subtotal field in both the summary and the top bar.
After users submit the configuration, the transaction receives the values of the Subtotal and Total fields from the top bar. The Total field takes into account the quantity selected for the configured item. For more information about pricing data on the product interface, see Working with the Product User Interface.
Using the Subtotal as the Base Price
You can dynamically obtain the price for a single configured item from the Subtotal field in top bar of the product interface. This subtotal amount can be used in a pricing record as the base for other calculations.
For example, you want the shipping charges to correspond to a certain percentage of the price of a single configured item. To create a pricing record that depends on the subtotal, check the Calculate subtotal box. After enabling this option, use the subtotal in the Price field by entering the {SOLE/MAT_PRICE} resolve expression. Then, you can multiply the subtotal by the multiplier, the discount, or both and follow the basic steps to create a price.
Related Topics
- NetSuite CPQ Configurator Products
- Working with the Product User Interface
- Including Additional Items Related to the Configurable Item
- Creating Work Orders for Configured Items
- Creating Items Required by the Configuration
- Creating Records Required by the Configuration
- Setting Transaction Body and Line Fields Based on Configuration Data