Hi,

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.

   1. Warehousing allowance – 0.25% of subtotal or <$2.50>

   2. Spoilage allowance – 1% of subtotal <$100>

   3. Distribution allowance – 2% of subtotal <$200>

3. 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:

   1. Warehousing allowance – 0.25% of subtotal or <$2.25>

   2. Spoilage allowance – 1% of subtotal <$90>

   3. 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?