webERP Forum
Sales Commission Report - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: How To ? (http://www.weberp.org/forum/forumdisplay.php?fid=6)
+--- Thread: Sales Commission Report (/showthread.php?tid=8016)



Sales Commission Report - VortecCPI - 12-29-2017

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!


RE: Sales Commission Report - TimSchofield - 01-01-2018

At one point I created a place on weberp.org for people to submit their reports. Not sure if this still exists?

Tim