webERP Forum

Full Version: Sales Commission Report
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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!
At one point I created a place on for people to submit their reports. Not sure if this still exists?

Reference URL's