Hi All — I have a question on multiple % discounts in an order - How to treat that? We have some customers that have multiple discounts % on an order that need to be applied on the subtotal of the order. 1. They cannot be lumped together as they are hitting different GL’s. 2. We are receiving those through EDI (or entered manually), here’s an example: Order subtotal is $1000. 3. Warehousing allowance - 0.25% of subtotal or <$2.50> 4. Spoilage allowance - 1% of subtotal <$100> 5. Distribution allowance - 2% of subtotal <$200> 6. When we invoice the customer, if the subtotal invoice doesn’t match the subtotal of the order, these different discounts need to be adjusted to the right $ (but still same % based on subtotal), as example if the invoice subtotal is $900, the discounts would end-up being: 7. Warehousing allowance - 0.25% of subtotal or <$2.25> 8. Spoilage allowance - 1% of subtotal <$90> 9. Distribution allowance - 2% of subtotal <$180> When adding the subtotal in NetSuite, I can add one discount, but that doesn’t do the trick, I need to have multiple different type of discounts all calculated vs the original subtotal (not the subtotal - discount 1, etc...) Any suggestion on how to do get to this?

Have you used a subtotal item before applying all these discounts?

Yes, but I’m under the impression that only one discount can be applied on the subtotal, not three separate one. Am I understanding this wrong?

No idea - never had a reason to try it

Trying to avoid that as part of automation. I was also suggested to evaluate the Rebate Management module

i'm not familiar with that tool

You could just use a journal to shift the cash around afterwards, and use a text item to break out the percentages on printed documents. Or a G/L lines plugin might work

@PNJ Thank you for the suggestion, but I’m looking for something that’s going to be a little more straight-forward.

I'd probably just add fields to the header for the various discounts - and then have a script or workflow add the lines when the order is created using non inventory items - and then you get the right totals and GL impacts.