SAP Business One 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 */

© 2009, Mark Chinsky. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.

Mark is a partner at Clients First Business Solutions, LLC. He is based out of the NY/NJ office. Mark has been in ERP sales and service for more than 20 years and at least 15 with Sage

Mark Chinsky

View all posts by Mark Chinsky
Mark's website

« SAP Business One Query to Show Open Balances by Customer (or Vendor) | Home | SAP Business One Why do I have different passwords for each company? »

• 
  
  
  
  
  
  
• Ask a Question on Ask The 90 Minds Group