Skip to Content
0

Sales Employees Commission – Based on Item Aging

Nov 14, 2016 at 06:25 AM

81

avatar image

Dear Experts,


I want to know is it possible to calculate Sales Employees Commission – Based on Item Aging.?

Eg:-

  1. If sales people sell an item within 3 month from the date of purchase, Sales person will get 2% commission.
  2. If sales people sell an item between 3-6 month from the date of purchase, Sales person will get 5% commission.
  3. If sales people sell an item between 6-9 month from the date of purchase, Sales person will get 7% commission.
  4. If sales people sell an item between 9-12 month from the date of purchase, Sales person will get 10% commission.
  5. If sales people sell an item after 12 month from the date of purchase, Sales person will get 12.5% commission.



Main objective of this kind of sales commission calculation is to promote sales person to sell old stock.

If possible how we can configure or what kind of UDT & UDF need.

It is possible in standard SAP Business One or Need any Add-on?

Please recommend.



Thanks & Regards,

Abdul Rasheed.P

Abdulrasheed.co.in@gmail.com
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Nov 14, 2016 at 09:12 AM
0

Hi,

Create a line level UDF to enter commission.

Frame your logic in SPTN so that before adding a document, SAP will validate it against required commission and prompt the user to enter appropriate amount.

For writing code in SPTN, you can refer this to gain an insight

http://scn.sap.com/people/lisa.mulchinock/blog/2009/05/22/the-sptransactionnotification-stored-procedure

Regards

Pradnya

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Mr.Pradnya for your comment.

Please let me know in which table we will create UDF. ?

Thanks & Regards,

Abdul Rasheed.P

abdulrasheed.co.in@gmail.com

0
avatar image
Former Member Nov 14, 2016 at 12:34 PM
0

Hi,

Choose Tools --> Customization Tools --> User Defined Fields Management --> Marketing Document --> Rows --> Add

This will let you add a ow level user defined field in all the marketing document.

You can control display of this field through Form Settings so that it will appear only in the relevant field.

Regards

Pradnya

Show 1 Share
10 |10000 characters needed characters left characters exceeded

How I can calculate the commission in user defined field..?

Please help.

Thanks & Regards,
Abdul Rasheed.P

0
avatar image
Former Member Nov 21, 2016 at 05:35 AM
0

Hi,

The commission will be calculated in SPTN. When user will save the document, SAP will validate it against the calculated commission. If n the line level it is not there or it is incorrect, then it will prompt the user by appropriate message and will not save the document till correct amount is entered in the field.

You will have to frame the logic and calculate and capture at the back end. User will enter it there when system flashes the amount.

Regards

Pradnya

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 25, 2016 at 06:20 AM
0

Hi,

If your items are batch managed, then you have to drill down the document trail from GRN --> A/R Invoicing thereby finding through which batch the item has come and when it got sold off.

Regards

Pradnya

Share
10 |10000 characters needed characters left characters exceeded