Setting Items to Calculate Quantity Discounts by Pricing Group

Setting Items to Calculate Quantity Discounts by Pricing Group

Calculating quantity discounts in NetSuite often involves one of two paths. The first path sets quantity prices on the item record with actual amounts.
Tip Image 1

Click image to enlarge

The second path utilizes a pricing schedule. On a pricing schedule a user can define the percent discount an item or group of items receives when a specific quantity is sold.
Tip Image 2

Click image to enlarge

The second path is often reviewed when a company looks to provide quantity discounts on a group of items within one sales order. However, this is often not the most desirable path as many quantity discounts are defined in dollars and not as a percentage off the base price.

An alternate option for calculating quantity discounts on a group of items is the Pricing Group feature in NetSuite. This option is available because NetSuite looks at Pricing Groups to set quantity pricing when the item is set to Calculate Quantity Discounts “By Overall Schedule Quantity“.
Tip Image 3

Click image to enlarge

To implement this functionality, start by creating a new Pricing Group. To create a new Pricing Group navigate to Setup > Accounting > Accounting Lists > Pricing Group > New.
Tip Image 4

Click image to enlarge

Set the new Pricing Group on all applicable item records and set the Calculate Quantity Discounts field to “By Overall Schedule Quantity“. After all applicable items have been set, the next sales order will automatically set the quantity pricing based on the total of all items assigned to the same Pricing Group.

Tip Image 5

Click image to enlarge

*Note: NetSuite will still respect the QTY of the specific item in calculating discounted prices.