Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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.