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!

[attachment=658]

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...

[attachment=656]

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 weberp.org for people to submit their reports. Not sure if this still exists?

Tim
Reference URL's