ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Sales Commissions
http://www.istechforum.com/YaBB.pl?num=1216740880

Message started by Tim Keating on 07/22/08 at 08:34:40

Title: Sales Commissions
Post by Tim Keating on 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

Title: Re: Sales Commissions
Post by lmk223a on 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.

Title: Re: Sales Commissions
Post by Tim Keating on 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.

Title: Re: Sales Commissions
Post by lmk223a on 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. ::)

Title: Re: Sales Commissions
Post by Lori on 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?

Title: Re: Sales Commissions
Post by Lori on 01/13/09 at 16:46:36

We are NOT using Price Code Commissions nor Contract Commissions...

Title: Re: Sales Commissions
Post by Lori on 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!