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 |