Sales Employees Commission – Based on Item Aging

[Former Member]

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

[narayanis]

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

[narayanis]

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

[narayanis]

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

[Former Member]

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

Please help.

Thanks & Regards,
Abdul Rasheed.P

[narayanis]

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-proce...

Regards

Pradnya

[Former Member]

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