Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #1
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 File(s)
.txt  SalesCommissionReport r8.txt (Size: 4.76 KB / Downloads: 0)

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
01-01-2018, 12:51 AM
Post: #2
RE: Sales Commission Report
At one point I created a place on weberp.org for people to submit their reports. Not sure if this still exists?

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)