Scenario:
The user needed to apply a flat-rate discount per quantity sold on a Sales Order or Invoice. When using a standard Discount Item inside an Item Group, the discount was only applied once per group instead of multiplying by the quantity sold, resulting in incorrect total discount calculations.
Solution:
Currently, NetSuite standard Discount Items do not support quantity-based flat-rate discounts within Item Groups.
This limitation is tracked under:
Enhancement #96044
Allow Quantity for Flat Rate Discounts And Show Subtotal
As a workaround, a Non-Inventory Item for Sale can be created and used as a custom discount item because non-inventory items support quantities on transaction lines.
To create the custom discount item:
- Navigate to:
Lists > Accounting > Items > New - Select:
- Non-Inventory Item for Sale
- Enter the:
- Item Name/Number
- Example:
Discount for Order Shipment
- Enter the:
- Display Name/Code (optional)
- Go to the Sales/Pricing tab.
- Enter the Base Price using a negative amount.
- Go to the Accounting tab.
- Select the preferred:
- Save the item.
After creating the item:
- Edit the Item Group record.
- Add the Non-Inventory Discount Item into the group.
- Set the Quantity field appropriately (typically
1 in the group setup).
Because the item supports quantities on transactions, the discount amount will properly multiply based on the quantity sold on the Sales Order or Invoice.
This workaround allows businesses to simulate per-unit flat-rate discounts until native quantity-based flat-rate discount support becomes available in NetSuite.