The quick answer
Edit the item and open Sales / Pricing. In the pricing matrix, type the break quantity in an empty Qty header and enter the Base Price for that column. Check the calculated prices for your percentage price levels, then save. On a sales order line, Price Level picks the row and the quantity picks the column, unless something like customer-specific pricing or a manual rate overrides it. In this example, 24 units at Contractor (-8%) price at 53.36, which is the 12-unit Base Price of 58.00 less 8%.
The item is a mixing bowl with a Base Price of $64.00. Contractors get 8% off through a Contractor price level. Anyone buying 12 or more should start from $58.00 instead. The screenshots use sample data, and the person and operating-company names are fictional.
When a sales order rate looks wrong, the answer is usually in this matrix. Price levels are the rows and quantity breaks are the columns. Fix the item once and you don't have to override rates on every order.
Before you start
Your account needs the Multiple Prices and Quantity Pricing features. An administrator turns these on at Setup > Company > Enable Features. The number of Qty columns you can use comes from the maximum number of quantity-based price levels in Setup > Accounting > Accounting Preferences. You need at least two columns for one break. Set and save that preference before you edit the item.
Your role needs permission to edit items and enter sales orders. Percentage price levels such as Contractor (-8%) get their discount from the percentage set on the price level, which the matrix shows in its Default Discount % column. The name is only a label.
This example is an inventory item with no Quantity Pricing Schedule. It uses By Line Quantity for Calculate Quantity Discounts and leaves Use Marginal Rates clear. The quantities count in the line's unit, which is Ea here. If the item uses units of measure, check which unit your breaks count in. It prices in US Dollar. If your account uses multiple currencies, each currency has its own matrix tab, so enter the break on every currency tab that needs it.
01. Read the starting pricing matrix
Open the item, here SB-220 Stainless Mixing Bowl, and select the Sales / Pricing subtab. In the US Dollar matrix, Base Price is 64.00 in the Qty 0 column. Contractor (-8%) shows -8.0% and 58.88. The other Qty columns are empty, so every order quantity gets the Qty 0 prices right now.
02. Add the 12-unit quantity break
Click Edit and go back to Sales / Pricing. Confirm Calculate Quantity Discounts is By Line Quantity, Use Marginal Rates is clear, and Quantity Pricing Schedule is empty. An assigned schedule can supply the matrix prices itself. The first Qty column is fixed at 0. The other Qty headers are input boxes.
Type 12 in the second Qty header. Then enter 58.00 in the Base Price row of that column. In the recording, the percentage levels fill in for the new column as soon as the Base Price is entered: Contractor (-8%) shows 53.36 and Distributor (-15%) shows 49.30. Check these cells before you save. If yours stay blank, check the price level's percentage and the Quantity Pricing Schedule before typing prices in by hand.
Online Price has no default discount, so its Qty 12 cell stays blank. If customers on that level should get the break too, enter a price for it. The recording doesn't show how a blank cell prices on an order.
03. Save and check the matrix
Click Save. Open Sales / Pricing on the saved item and look at the matrix. The header now reads Qty 12, with Base Price 58.00, Contractor 53.36, and Distributor 49.30 in that column.
04. Price a 24-unit sales order line
Go to Transactions > Sales > Enter Sales Orders.
Select the customer, here Harbor Point Builders. On the Items subtab, select SB-220 Stainless Mixing Bowl and enter 24 in Quantity. In the recording, Price Level starts at Base Price. Your customer or form may default to a different level. At Base Price, the rate is already 58.00 and the amount is 1,392.00. That's the break working by itself. 24 is at least 12, so the line uses the Qty 12 column. Because Use Marginal Rates is clear, all 24 units get that price. With it checked, the first units would be priced in the Qty 0 bracket and the rest in the Qty 12 bracket.
Now choose Contractor (-8%) in Price Level. The rate changes to 53.36 and the amount to 1,280.64. That's 58.00 less 8%. Without the break it would have been 64.00 less 8%, or 58.88.
Click Add. The committed line shows 24, Contractor (-8%), 53.36, and 1,280.64. With one line and no tax or shipping, the Summary subtotal and total are 1,280.64. Add only commits the line to the unsaved order. The recording stops here, so nothing exists as a sales order until you click Save.
To check your own setup, compare the line rate with the matrix cell where the price level row meets the quantity column. For this example, that's Contractor at Qty 12: 53.36. No customer-specific item price, pricing group, promotion, or manual rate is involved here. Any of those can change the final price, so rule them out first if your rate doesn't match the matrix. If you want to test the boundary, try 11 units too. It should price from the Qty 0 column.
Common questions
Do price levels and quantity breaks stack?
In effect, yes, but not as two discounts applied at order time. The line picks the quantity column first, then uses the price level's cell in that column. In this example, Contractor's 8% comes off the Qty 12 Base Price of 58.00, and the matrix stores the result, 53.36. That's the rate the 24-unit line gets.
What does the number in a Qty header mean?
It's the minimum quantity for that column. Qty 12 applies to 12 or more units, up to the next higher break if you add one. Qty 0 covers everything below the first break.
What does By Line Quantity mean?
NetSuite picks the column from the quantity on that one sales order line. Other options, such as By Overall Item Quantity, can count the same item across several lines. This example only shows By Line Quantity, and the options available can depend on your account.
What does Use Marginal Rates change?
With it checked, each quantity bracket gets its own price, so part of a line is priced in one column and the rest in the next. With it clear, as in this example, the whole line gets the price from the column its quantity reaches. The recording doesn't show marginal-rate pricing.
Why doesn't my sales order rate match the matrix?
First check the obvious things: the currency tab, the quantity, and the price level on the line. Then look for pricing that sits on top of the matrix, like customer-specific item pricing, a pricing group, a promotion, or a manually changed rate. Units of measure and account settings can also change the result.
Where do I set how many Qty columns an item can have?
An administrator sets Maximum # of Quantity-based Price Levels at Setup > Accounting > Accounting Preferences, on the Items/Transactions subtab. Save the preference before editing items. The number of columns you can add depends on that setting.
What if a price level's cell is blank in a Qty column?
Don't assume it falls back to another column. In this example, Online Price has no default discount, so its Qty 12 cell stayed blank after saving, and the recording doesn't show how an order prices it. If customers on that level should get the break, enter the price yourself and test an order.