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) / SOP Invoice Default Di...
Microsoft Dynamics GP (Archived)

SOP Invoice Default Distributions using Integration Manager eConnect adapter

(0) ShareShare
ReportReport
Posted on by mattvs 2

Hi Does anyone know how I can use the Integration Manager eConnect adapter to import both supplied distributions as well as use the default distributions calculated by Dynamics GP.

The standard Integration Manager adapter has a function on the Distributions tab called "Default Non-Imported", which enables me to use both GP defaults (such as the Accounts Receivables Account) and the distributions supplied in the integration.

I wish to use the e-connect adapter because it performs much better then the standard and is easier to automate.

At the moment I can only see the option to use defaults or supply all distributions, which will be difficult when calculating Tax etc.

Thanks

*This post is locked for comments

  • abhishek1611 Profile Picture
    abhishek1611 2,110 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    can anybody tell

    which adapter of  integration manager is used to integrate invoices  in GP 2013.

    I have already integrated sales file under Sales adapter of  integration manager.

  • abhishek1611 Profile Picture
    abhishek1611 2,110 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    can anybody tell

    which adapter of  integration manager is used to integrate invoices  in GP 2013.

    I have already integrated sales file under Sales adapter of  integration manager.

  • soma Profile Picture
    soma 24,410 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    Have your problem solved?

  • Suggested answer
    mattvs Profile Picture
    mattvs 2 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    After lots of tweaking and testing, my solution ended up using the original integration manager adapters and setting up Auto Dim with GP login macro’s to run the integrations. It wasn’t my preferred solution, but it is stable and runs like clockwork. The downside is that the integration is currently running on a windows XP box due to the enhanced security in later versions of windows. Unfortunately the distributions were very complicated so utilising the Default Non-Imported was a must.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    Please have a look on the below link.

    msdn.microsoft.com/.../aa973846.aspx

    Hope this helps!!!

  • mattvs Profile Picture
    mattvs 2 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    Thanks for the advice, I'm thinking now that I could import my transactions and default distributions via integration manager econnect. Then run an xml update for the extra debit and credits supplied.

    Unfortunately I'm not great with XML, any idea where I might find an example for updating SOP transaction distributions using econnect?

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    No option available in Integration Manager eConnect adapter to use both GP default accounts and custom user supplied distribution accounts. You can only use either default or user supplied distribution accounts from IM with eConnect adapter.

    Hope this helps!!!

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: SOP Invoice Default Distributions using Integration Manager eConnect adapter

    For me, there is no way of comparison between eConnect and Integration Manager. Of course eConnect is a better and yet more efficient solution for integration.

    You need to consider the eConnect schema provided for most of Dynamics GP modules. For Sales Order Processing module, check the SOPTransactionType schema . You can create new transaction, update, add line items ... etc. The schema is quite expressive and all the associated details are provided. Under this schema, you will find <taSopDistribution> for SOP distribution.

    Please never hesitate to share any further inquiries,

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,038 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans