Welcome, Guest. Please Login.
11/15/24 at 04:43:24
News:
Home Help Search Login


Pages: 1
Send Topic Print
Sales Commissions (Read 804 times)
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Sales Commissions
07/22/08 at 08:34:40
 
We just started looking at using Sales Commissions to pay sales reps to replace an offline method we've used for years.  
 
1. A particular Salesperson is set up with a 10% Commission rate in CS-A.
2. This Saleperson is selected for a particular Customer as SLSP1 in AR-A.
3. All Invoices to this Customer yesterday transacted with a 7% Commission.
4. All those Invoices were for the same Part.
 
Here are the facts:
 
1. The Commission Rate was not overridden in the Bill-to or Ship-to customer screen in AR-A (left at 0%).
2. We are not using Price Code Commissions.
3. We are not using Contract Commissions.
 
Here's something else:
 
1. In the BKARHINV Sales Order Header file, the Commission Rate for this Invoice is 10%.
2. In the BKARHIVL Sales Order Line file for this Invoice/Part, the Commission Rate is 7%.
3. In the MTICMSTR file for this Part, the Commission Rate is 0%.  
 
Any insight would appreciated as I'm not sure what I'm missing.
 
Tim Keating
Motor Guard Corporation
Manteca, CA
v 2002.4
 
 
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 379
Re: Sales Commissions
Reply #1 - 07/22/08 at 11:16:13
 
My experience has shown that the commission percentage indicated on the sales order line item, takes precedence over what has been set up for the sales person, or originally entered in the sales order header, especially if there has been a change.  The system will not change line items already entered if a change occurs in the header.  I suspect a change from 7 to 10% must have occurred somewhere along the line.
 
If the sales person's rate is 10%, the sales order line item needed to be changed from 7% to 10% in order to book the proper 10% commission when the invoice is posted in SO-G.  You may want to scroll through the line items on the sales order to ensure all line items reflect the 10% commission rate.
 
Side item, you may also want to check your commissionable part numbers in IN-B to verify the commission flag is set to "y" and not "n", otherwise commission will not be calculated.
 
Back to top
 
« Last Edit: 07/23/08 at 09:17:38 by lmk223a »  

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: Sales Commissions
Reply #2 - 07/22/08 at 15:34:27
 
Thanks Linda.  I agree that the line item commission would override the others but we don't enter commissions at sales order entry.  The option is turned off.
 
I must be missing something.
 
Commissions are set as follows:
 
Salesperson: 10%
Bill-to Customer: 0%
Ship-to Customer: 0%
Part Number: 0% (Commissions Flag in IN-B set to 'Y')
 
But, on Invoice, this item was assigned a 7% commission.
 
I understand if a commission was changed before and after invoicing this could happen but, since I'm the only one messing with commissions, I don't see how.
 
I would assume this is not related to the program function or someone would have run into it before me.
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 379
Re: Sales Commissions
Reply #3 - 07/23/08 at 09:16:52
 
We use CS-A also to enter Sales People and their rates, then enter the sales person's number in the Sales Order header screen which triggers the commission in the sales order line items.  
 
As this differs from your usage, at least I can share with you this method works for us. Roll Eyes
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Lori
Browser
*




Posts: 40
Gender: female
Re: Sales Commissions
Reply #4 - 01/13/09 at 16:40:36
 
Yikes!  We recently began paying commissions and are getting some crazy commission figures.    
 
Example:
 
Rep 800    10% (in the SO header)
Total Product Sales $270.40 - this was 8 each of one item
Commissionable (per CS-O report) $142.08 - - - wha ???
 
Also, one invoice on this report of 5 shows a payment amount that includes freight, the others do not.
 
Where is the problem in our system?
 
 
 
Back to top
 
 

DBA Classic since 1997, some users on EVO since 8/09
Current Version
Windows NT Server 2000
10 workstations
  IP Logged
Lori
Browser
*




Posts: 40
Gender: female
Re: Sales Commissions
Reply #5 - 01/13/09 at 16:46:36
 
We are NOT using Price Code Commissions nor Contract Commissions...
Back to top
 
 

DBA Classic since 1997, some users on EVO since 8/09
Current Version
Windows NT Server 2000
10 workstations
  IP Logged
Lori
Browser
*




Posts: 40
Gender: female
Re: Sales Commissions
Reply #6 - 02/04/09 at 10:49:29
 
It was my mistake, I had selected to pay on NET sales rather than GROSS sales!  Thanks for the help, Lynn!
Back to top
 
 

DBA Classic since 1997, some users on EVO since 8/09
Current Version
Windows NT Server 2000
10 workstations
  IP Logged
Pages: 1
Send Topic Print