I’ve been asked to create a CRM for sales with multilevel commission.
First level - Carlos recommends Mario and signs up for service. Carlos gets $25.00.
Second Level - Mario recommends Maria and signs up for service. Mario gets $25.00, Carlos gets $10.00.
Third Level - Maria recommends Susane and signs up for service, Maria gets $25.00. Mario gets $10.00 and Carlos gets $5.00.
Only 3 levers are necessary, if Susane recommends Tom, Susane gets, $25.00, Maria gets $10.00, and Mario gets $5.00. Carlos is out of the loop.
Hopefully someone can help me with this puzzle. I don’t even know where to start and designs the database structure.
Jorge
Upon careful analysis, it’s actually not that hard.
You need a table/grid with an add form like this:
Recommendations is a many to many connection to itself:
Count is a count of the connections for a given record:
And Commission is a currency field with some validation rules like this:
The grid is editable in my case. You just add the names of those who are granted under the particular person’s name. It’s a little redundant but it works perfectly.
Cheers!