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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Commission error
Microsoft Dynamics GP (Archived)

Commission error

(0) ShareShare
ReportReport
Posted on by Community Member

I am new to GP and am having a problem understanding the commission process.  The problem arises when there is a down payment on the job and when the final amount is invoiced, the commission is being based off of the sub-total and not the sale so when we enter the correct commission amount on the invoice, this creates the error that the commission sale amount cannot be greater than the sale amount and will not post.  If you let it default to the sub-total, then the amounts for the commission are obviously not correct. 

I have searched everything that I can find to fix this problem, but haven't been able to find the answer.

Thank you for any assistance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Can you explain how you are entering the prepayment?  Normally entering a prepayment would have no effect on the subtotal of a sales document.  If you have an order/invoice for 1000.00 and a prepayment of 200.00, the subtotal should still be 1000.00.  

    Also, there is an option on the Salesperson Maintenance window that specifies whether the commission should be calculated off just the total sales amount or the total invoice (taxes, misc, etc included).

  • Community Member Profile Picture
    Community Member on at

    They are entering the prepayment as an item.  The commissions are set to be based on the total sales amount, which is correct.  In my research, I just started reading something about using the amount received on the Sales Transaction Entry.  Would that be a solution?  If so, how could I tie it to the deposit account in in GL?

  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Yes, the Amount Received is where you'll want to record this.  Once you enter an amount on the Amount Received field and hit tab, it will open up a new window called the Sales Payment Entry.  This is where you can enter a deposit if you entered it at the Order level.  You can choose the GL accounts right on that window.

  • Community Member Profile Picture
    Community Member on at

    Thank you for your help.

    I tried that, but those options are not available to me.  Would this have to be entered on an Order as opposed to an Invoice?  We don't create sales orders when we receive a down payment, just enter in the GL as a deposit.  Would it work better if it was done that way?  

    Another question, is the Territory ID linked to the Item Number on the Invoice?    

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    The deposit options are only available on the Order Type.  It would be an additional step but you could enter it as an order with the deposit, then transfer it to an invoice and post.  I don't believe the options for a payment on the invoice give you the ability to select a GL account.

    The territory is linked to the salesperson so it will default based on the territory assigned to the Salesperson ID.

  • Community Member Profile Picture
    Community Member on at

    I think this will work to solve my problem and will try it, but one last question for now. Entering the order with the deposit, I am assuming that the order will sit there until we convert it to an invoice, but both the cash and deposit accounts will be affected as of the order date??

    Thank you for your help.

  • Verified answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    Yes, if you add a deposit to the order when you then save the order and close out of the window you'll get posting reports for the deposit and it will get sent to the GL.  On the Sales Payment entry screen you have the option to change the dates as well if necessary.

  • Community Member Profile Picture
    Community Member on at

    Thank you so very much - You have been a great help!

    In working through this program, I am sure that I will have more questions!!!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans