Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Commission saved search based on percentage of quota reached per month
Hello there, this is a general question and appreciate it's probably going to be a tricky one, we're introducing new commission criteria, details are below:
75% Percent of monthly quota reached = 6% of gross profit paid in commission (Sales Order)
90% and over Percent of monthly quota reached= 10% of gross profit paid in commission (Sales Order)
I'm aware that there's no easy way to join Quota data to transaction data in a Saved Search, but searches rather than reports are our primary analysis and calculation tool within the business, so in the first instance would like to ask if there's any way we can calculate the above in a saved search, as i said, i think this is going to be incredibly tricky if not impossible to achieve in a saved search but would appreciate any feedback or advice either way, thanks for your help.