Skip to main content

Notifications

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 writebacks ...
Microsoft Dynamics GP (Archived)

Commission writebacks with Web service

(0) ShareShare
ReportReport
Posted on by DevAlex 65

I would appreciate if somebody could point me in the right direction.  I am working on an integration, which will calculate sales person commissions for AR invoices. I am looking for a way to implement write-backs to our GP 2010. I would prefer to use Web services as my integration method but I don't see any methods that would allow me to do it. I also looked into eConnect but from what I can see there's nothing there either. Will I have to integrate using database tables directly? I would like to avoid it at all costs for obvious reasons. If database integration is my only method - what is the best place to get started on table schemas / fields?

Thank you!

*This post is locked for comments

  • DevAlex Profile Picture
    DevAlex 65 on at
    RE: Commission writebacks with Web service

    I guess I should have clarified.  The invoices will already be in GP, I would need to match the invoice by invoice number and populate the commissions there. I was just told that occasionally there will be "manual deductions" for which I still need to transfer amounts but there will be no invoices to match them against.  Not sure how to handle those properly.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    RE: Commission writebacks with Web service

    No problem Dev.  That's why the forum exists :)

    So, are you not integrating the AR Invoice as well?  Typically, commissions are integrated along with the invoice details.  Or are you trying to integrate just commissions and match them to existing invoices in GP?

  • DevAlex Profile Picture
    DevAlex 65 on at
    RE: Commission writebacks with Web service

    Frank,

    Thank you for responding. Let me try to clarify. I am trying to import commission settlement amounts, which are calculated in our in-house ERP system and make them show up on this screen:

     

    Which is accessible by clicking on the "Commissions" button available on the bottom of the "Invoice Inquiry" screen.

    I apologize if I am not using correct terminology, I am a software developer with some limited exposure to accounting systems.

    Thanks again.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    RE: Commission writebacks with Web service

    Can you define what you mean by 'write-backs'?  An example would help.  Thanks.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans