As a NetSuite consultant, I constantly find myself using NetSuite Workflow to automate business process in lieu of having a developer write code.  In this use case, we’ll help you use NetSuite Workflow to create an After Field Edit triggered action to calculate a commission value for a sales rep based on the sales rep’s participation percentage in a deal.


A field on an order form tells us the value of the deal, but it’s up to the user entering the order to set the percentage participation of the rep in this deal. Rather than manually doing the math, the user would like the value due to the sales rep automatically calculated upon entering the participation percentage.

In this example:

  • The order value is $250,000.00
  • The sales rep’s participation was 20% of the total order value
  • The user would like the “Rep Commission” field to display $50,000.00 ($250,000 * 20%) automatically


A workflow using an ‘After Field Edit’ trigger could accomplish this by running the calculations after edit of the Order Value Field or the Rep Percentage field.

  • The ‘After Field Edit’ trigger on Workflow actions allows fields to be updated automatically, in real-time.
  • Setting this trigger type allows the user to update a field value based on whether one or more other fields on that form are updated by the user.
  • When setting up a new workflow action, choose trigger on “After Field Edit.”
Workflow Action

Special Considerations:

  1. Choosing the ‘After Field Edit’ trigger will require the user to select one or more ‘Triggering Client Fields.’ These are the fields which must be edited in order to trigger the workflow to update the field in question, not the fields whose values will be changed by this workflow state.
  2. If this field should only be updated under certain conditions, you can specify those conditions in the ‘Condition’ area. If this workflow state is calculating a value based on one or more other fields, it is recommended to set a condition that these fields contain data. If you neglect to do this, you may receive errors from NetSuite relating to null values.Workflow Action Condition
  3. In the ‘Parameters’ area, select the field you want this workflow action to update. You can set it to:
  • A static value (the value will always be set to that value on update of the triggering client field)
  • A value from another field on the record
  • A custom formula to calculate a new value – this is what we’ll be using in our example
Workflow Action Formula
  1. If your workflow contains more than one action with the ‘After Field Edit’ trigger, be mindful of dependencies between them. If one action cannot properly function without a field value being set by another action, put them in the right order by clicking and dragging the workflow actions in the workflow editor. Save your changes when finished.
  2. Ensure the workflow is in a mode of ‘Testing’ or ‘Released’ to view the workflow in action on your forms.
There you have it.  You’ve just used NetSuite powerful workflow engine to calculate a sales rep’s commission share without writing any code!  And this is just the tip of the iceberg – there is so much more that you can do with NetSuite workflow.
If you’re looking for some guidance building NetSuite workflows – or if you feel like you’re under-utilizing this extremely powerful application and are looking for more out of you’re NetSuite investment, please get in touch with us – our dedicated team of NetSuite consultants are here to help!

Additional NetSuite Resources

Creating Filtered Dropdown Lists in a Custom Field in NetSuite

6 Tips for NetSuite Advanced PDF Templates

Dynamically Print Items on a Netsuite Sales Order Using Advanced PDF Templates

NetSuite: A Unified Platform for Business Data

Wait! Before You GoWould you like to talk to a business software expert to answer your questions?

When you schedule a free consultation with MIBAR, you will experience a one-on-one conversation with a business technology expert who is passionate about understanding your unique needs or issues. Schedule a free consultation today at the link below or give us a call at (212) 869-9300.

Learn More
NetSuite Offer: Save $15,000 With Our Limited-Time Discount

If you’ve been evaluating NetSuite, there is no better time to make the switch. With a NetSuite subscription through MIBAR by December 31, 2020, we will offer you 75 hours of professional consulting services for FREE.

Not only can a new ERP system like NetSuite help you reduce operating costs by automating manual processes, but this limited time offer can also help save you a substantial amount of money upfront.