Showing results for 
Search instead for 
Did you mean: 

Query - Sales Incentives

Former Member
0 Kudos


My customer needs a Query for sales Incentive.

Can any one provide me the solution.

Version: SAP Business One 2005B

PL; 38

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos


It is better that you start to try the query and post it here if you need help.



Active Contributor
0 Kudos


Your message is like a telegram. It is too brief to help.

Please state your complete requirement and tell us what you need as a output.

Have you gone through the Business One e-learning or Certification curriculam? If you haven't it would be a good place to start knowing more about what B1 can do.


Former Member
0 Kudos


Sorry for stating so. I'm SAP Business One Certified Consultant.

Sales Incentive:

For Example there are 5 sales Executives to an Area Manager, like this there are 4 Area Manager, all these Area Managers are under one Sales Manager.

  • Sales Executive will get incentive if the achieve more than 60% of their Sales Target in that month.

  • Area Manager will get incentive for the 60% of that Area's target. (overall achievement i.e of all the Sales Executives)

  • Sales Manager will get incentive for the achievement of 60% of the whole sales Target inclusive of all the area's.

I want a Query which calculates the Sales Incentive in this category.

Edited by: Rui Pereira on Jan 27, 2009 4:52 PM