Good afternoon!
I'm working to setup a new Commission schedule, and having some difficulty.
Our goal is to pay commission that is a percent of the gross profit on an invoice.
- I've created a custom transaction column field ("Gross Profit ($)"), that is a currency type field, set to store value, and set to display on sale transactions.
- I've populated the field on all the applicable invoices in October (last month).
- I have created a Commissionable Item Saved Search to ensure some specific criteria are met and that only qualifying invoices get included for calculation. For testing purposes I've made this really simple: Any invoices, where the custom Gross Profit ($) field is not empty, and where the date is on or after 10/1/2024. The search (correctly) returns 36 results.
- I've validated the sales reps are assigned on the sales team for the invoices.
- I've created a Commission Schedule (below) that I think is pretty straight forward. It's on the custom field I created, no quota, based on transaction lines, categorized by the commissionable item search, and eligible on collections. I've additionally specified the 5% commission to be paid for any transactions that match the criteria for that saved search.
When I recalc the Commission Plan, it runs for about 5 minutes, completes, and no commissions come up as available for authorization. I've validated by looking at the Commission Overview Detail report, and none of the invoices from 10/1/2024 forward show up at all, much less showing Base or Calculated amounts.
When I look at the list of Commission Schedules, it says my commission schedule is not in use, but it is clearly associated to the Commission Plan. I've included screenshots below reflecting that the Commission Schedule is actually associated to the Commission Plan, that there are Sales Reps associated to the plan, and that the plan dates are within the time frame that is relevant.
I'm feeling pretty stuck, and could use some suggestions. Any thoughts?
Thanks!