Calculating the Final Pricing for the Configurable Item
NetSuite CPQ Configurator automatically calculates and updates the configurable item price based on the features and options selected by users on the interface to ensure consistent and accurate pricing. All active pricing records combined provide the final price for the configurable item. Active prices are those where questions or answers in the rule match questions or answers selected by users on the interface.
NetSuite CPQ Configurator cannot dynamically determine the price of item groups used as base items because their price depends on the member item prices that this SuiteApp does not handle.
Pricing records are provided with an internal name and a label for the user interface. The sequence number determines the order in which the price is displayed on the summary. Prices with a lower sequence number are displayed higher on 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.
On the user interface, all active prices are displayed on the summary with their amount, unless you want to hide a particular price or amount. Users can also find more information about active prices under Pricing in the Audit menu. The price per unit is displayed in the Total field of the summary and the Unit field of the top bar.
After submitting the configuration, the transaction receives the values of the Unit and Total fields in the top bar. The Total field in the top bar takes into account the quantity selected for the configurable item. For more information about pricing data on the user interface, see Working with the Product User Interface.
You can dynamically obtain the unit price of the configurable item from the Unit field on the user interface to use it in pricing records as a base for other calculations. For example, you want the shipping charges to correspond to a certain percentage of the unit price. To create a pricing record that depends on the unit price of the configurable item, check the Recalc subtotal box. After enabling this option, you can use the unit price in the Price field by entering the {SOLE/MAT_PRICE} resolve expression. Then, you can multiply the unit price by the multiplier and the discount or one of them and follow the basic steps to create a 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 user interface.
-
Provide a sequence number to determine the order in which the price is displayed on the summary.
You can enter a negative or positive number. For example, −2 or 5.
-
(Optional) To define a specific date range in which this price is included in the calculations for the final item price and displayed on the user interface:
-
In the Effective Date field, select a start date.
Before this date, the price is inactive.
-
(Optional) In the Cancel Date field, select an end date.
After this date, the price is inactive.
Note:If you define a date range, the price must meet the date range and the conditions expressed in the rule to be active.
-
-
In the HTML Content field, enter the price label displayed on the summary and the Audit > Pricing menu on the user interface. You can format the text by changing the paragraph font and size or making the text bold, italic, or underlined.
Note:You can also include information from questions or answers on the user 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}. NetSuite CPQ Configurator replaces question and answer codes with the corresponding answer value. For more information, see Obtaining Answer Data with Resolve Expressions.
-
In the Price field, enter a number without the currency symbol. You can also obtain the price value by using resolve expressions.
The price is multiplied by the multiplier and the discount.
The currency depends on your account settings defined at Setup > Company > Company Information. For more information about currency, see Enter Basic Company Information and Currency Management.
-
In the Discount field, enter a number or a resolve expression to apply a reduction in the usual price. For example, 0.5.
If you leave this field blank, the assumed value is 1.
-
In the Multiplier field, you can enter a number or a resolve expression. NetSuite CPQ Configurator multiplies the price 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 assumed value is 1.
-
In the Rule field, provide the question and answer combination that determines whether the price is added to the summary and the price per unit in the Unit 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 Building Blocks with Rules.
-
(Optional) To include an additional rule in the pricing rule, select a category. The price is active if its rule and the category rule match an answer selected by users. For more information, see Working with Categories in NetSuite CPQ Configurator.
-
To include this price in the Total field on the 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 on the summary, check the Hide pricing box. The price label is still displayed on the user interface, and the amount is included in all pricing calculations.
-
To hide both the price label and amount on the summary, check the Hide price (total 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.