Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Percentage Quota/Commission Brackets
We have created a commission schedule that pays a specific amount based on a percentage of quota achieved (i.e. 80% pays $1000). We need to map out every percentage from 1-1000 within NetSuite. The issue is that each schedule calculates commissions independently of each other and only allows 10 brackets.
Problems:
1. We can't use a linear calculation because each schedule will caculate independently of each other (i.e. schedule 1 is 0-9%, schedule 2 is 10-18%, therefore if a rep hits 18% both schedules will run).
2. We decided to use marginal (i.e. each percentage point increase by $1, so if a rep hit 18%, the following schedules will run: schedule 1 is 0-9% would total $9 and schedule 2 is 10-18% would also be $9 for a total of $18). The issue with this is that if a rep hits 300%, it would need to use around 33 separate schedules to calculate the total commision.