ANS-1009 · SALES ORDER PROCESSING

How to Apply NetSuite Sales Order Discounts to Specific Items?

Learn how to selectively apply discounts on NetSuite sales orders by strategically utilizing subtotal items and line sequencing.

Short answer

To apply a discount to only certain items on a NetSuite sales order, use a subtotal item. Place the items to be discounted above the subtotal, then the discount item. Any items that should not receive the discount should be entered after the subtotal and discount lines. This ensures precise discount calculation.

Scenario

A client seeks to apply a discount at the sales order header level but needs to exclude specific markup items from receiving this discount. The challenge is to prevent the header-level discount from affecting these particular items while still applying it to others on the same transaction.

Solution

The recommended approach for selectively applying discounts on a NetSuite sales order is to utilize subtotal items rather than a header-level discount. This method provides greater control over which items are included in the discount calculation.

  1. Ensure a subtotal item has been set up in NetSuite.

  2. When entering the sales order, add all items that should receive the discount before the subtotal item.

  3. Insert the subtotal item on the transaction line after all discountable items.

  4. Add the discount item immediately after the subtotal item. The discount will then apply only to the amount subtotaled above it.

  5. Enter any items that should not be discounted after the discount line.As per NetSuite's help documentation:"A subtotal item can be inserted on any line of a transaction and will subtotal the items above it, up to the next subtotal line. This allows you some added flexibility when calculating discounts. If you want to calculate a discount on the entire transaction, you can enter a subtotal line and then enter a discount item after it. Discounts entered above a subtotal line are figured into the subtotal. Discounts entered after the subtotal line apply to the subtotal amount."

Expert NetSuite Support

Need help with this NetSuite issue?

Sales Order Processing consulting and configuration support

Talk to a consultant