Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to add multiple sa...
Microsoft Dynamics GP (Archived)

How to add multiple sales people to an invoice for commissions?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi guys, we have this case where multiple sales people get commissions off of one deal. So for example, if the invoice amount is for 10k and two people get 3% and 1% of the deal. So the commission payable is 4% of the total. In this case, our GP doesn't let me enter 10000 in the Commission Sale Amount for the two line items. I guess i can somehow manually work it so each sales people get the right commission amount, but then the report won't be accurate. How do i manipulate the commission sale amount so it shows 20K: 10K at 3%, another 10k at 1%. Thank you!

*This post is locked for comments

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    RE: How to add multiple sales people to an invoice for commissions?

    Unfortunately, GP is really not set up to do multiple commissions per invoice, it's really meant to be one salesperson per invoice. The example Redbeard shared is a way to 'trick' the system into letting you enter multiple salespeople/commissions per invoice, but it's definitely not ideal and you don't have many options here. If you want something more robust you can:

    (a) Use an ISV product with more robust commissions capabilities.

    (b) Use Extender to track commissions or additional information about commissions you need to report on. Note that Extender will not automatically create GL distributions for you like the GP commissions functionality will.

    (c) Create custom report(s) to show the information you need based on what is entered on the GP commissions window (and/or an Extender window).

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: How to add multiple sales people to an invoice for commissions?

    For one invoice there is only one salesperson in GP, how you are maintaining multiple salesperson for single Invoice in GP?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to add multiple sales people to an invoice for commissions?

    Hi Harry,

    I see your point, but that's not exactly what i was asking about. Is there a way where i enter two sales people where they both get the 100% of the sales amount? for example one gets 3% of the sales amount and the other 1% of the sales amount?  

    This way, when i print out the report, the rate shown is consistent.

    If i do it your way, then instead of 3% the first guy will get 6% since it's calculated from 50% of the sales amount. I guess it works if you are to only track commission amount, but im hoping to use the reports as well. thank you!!!

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: How to add multiple sales people to an invoice for commissions?

    Here's a prior post, which addresses this issue.

    community.dynamics.com/.../149881.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans