RE: Workflow that auto-populates DISCOUNT item when CUSTOMER chosen

How can I create a work order, or designation, that automatically assigns a discount item to a sales order, once the customer is populated? One of our customer’s receives a 17% discount to their entire sales order, every time. We want to avoid creating additional price levels – but it is easy to forget to manually click this discount item when creating the sales order.

Kayla Jane Rookie Asked on December 18, 2020 in How To's.
Add Comment
1 Answers

I understand you want to avoid price levels, but this is the way I would do it as it is the ‘cleanest’, uses no customisation (which means NS runs quicker) and is scalable (if there are more customers that you want to apply a 17% discount to, or a different % discount).

  1. Create a new Price Level
  2. Enter “-17%” into the “Markup/Discount %” field
  3. Tick “Update Existing Prices”
  4. Set the “Price Level” on the Customer Record (normally under the “Financial” tab)

Here are the advantages:

  1. When you create a new order for this customer, it automatically applies that price level, no manual intervention needed.
  2. Other customers can use that price level in the future
  3. You can easily add other price levels for other customers with different discounts
  4. If you change the price of the base price, it automatically updates the price levels

If you want the customer to ‘know’ that they are on a special discount level, you could add the price level name to the email/PDF template too (and you could call the price level “17% off” or something).


In theory you could do what you have asked for with a workflow. But because I suspect you have more than one SKU per order, I haven’t been able to get it to work (because I can’t add a “Subtotal” line via Workflow.

Rookie Answered on December 21, 2020.

I found this forum when my search results for this exact same question showed me this page! The disadvantages of using price levels is that it erodes true gross margin. It doesn’t allow you to capture gross sales as gross sales on your P&L with any price less than gross as a discount.

I tried doing the workflow route but I’m stuck. We created a custom field at the customer master with discount % and the discount name. I set my State 1 to set field value using Customer as the Record (Join Field).

If I set Field = Discount Item then no fields come up as selectable in the From Field. If I set Field = Discount Rate then I don’t see the Rate fields we added at the customer record.

Anyone know why, or have any success going this route?

Many thanks!

on August 12, 2022.
Add Comment

Your Answer

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