web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    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

  • Community Member Profile Picture
    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!!!

  • Almas Mahfooz Profile Picture
    11,009 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?

  • Suggested answer
    Victoria Yudin Profile Picture
    22,769 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).

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans