Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sales Commission Report
12-29-2017, 08:20 AM, (This post was last modified: 02-14-2018, 10:31 PM by VortecCPI.)
Sales Commission Report
I made this and I figured perhaps some of you can make use of it.

It makes use of the Comm Rate 1, Break, and Comm Rate 2 fields for sales People.

PLEASE NOTE!!! You MUST increase fieldname length to 255 in reportfields table for this to work due to the very long SQL string!


The report calculates commission based upon how long a customer has been on board. If <= BREAK (months) it uses RATE 1 and if > BREAK (months) it uses RATE 2.

Perhaps some of you can use this as a starting point for other sorts of commission reports...


If you do come up with something based upon this please share it back with the community!

Attached Files
.txt   SalesCommissionReport r8.txt (Size: 4.76 KB / Downloads: 0)
01-01-2018, 12:51 AM,
RE: Sales Commission Report
At one point I created a place on for people to submit their reports. Not sure if this still exists?


Forum Jump:

Users browsing this thread: 1 Guest(s)