Sales Commissions

Steps to Setting Up Commissions:

1. Go to main menu option: Administration -> General Settings -> BP (Tab)
2. In the upper right portion of the window select how you would like to define commission percentages. You can select all three if you like, but for this discussion we will deal with just the Sales Employee. Click OK/Update.
3. Go to main menu option: Administration -> Setup -> General -> Commission Groups. Define new groups and their commission percentages.
4. Go to Main menu option: Administration -> Setup -> General -> Sales Employees. Assign a Sales Employee to a commission group.

Note: Alternatively, you can just enter in a commission percentage for a Sales Employee instead of selecting a group.

The Sales Employee table is called: OSLP and it is tied to...
The Commission Group table: OCOG by the group code found on the OSLP. If the GroupCode on the OSLP is 0 then it is considered a user defined percentage amount (i.e., no based on a commission Code).

Here is a simple query to retrieve the commission percentage for a sales employee:

SELECT T0.slpcode, T0.slpname
,CASE WHEN T0.GroupCode = 0 THEN T0.Commission ELSE T1.Commission END Commission_Pct
FROM OSLP T0
LEFT OUTER JOIN OCOG T1 ON T0.GroupCode = T1.GroupCode
/*Remove comments below to filter out the negative slpcode*/
/*WHERE T0.slpcode > 0 */

(SAP Business One, SBO)