RE: Multiple % discounts in an order – How to treat that?

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?

ypoulin Rookie Asked on October 27, 2020 in Order Management.
Add Comment
2 Answers

Use Line-Item Discounts, preferably in combination with Subtotal Items if the customization and reporting in your account can handle it.

Intermediate Answered on October 27, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.