Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager an...
Microsoft Dynamics GP (Archived)

Integration Manager and Analytical Accounting

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

I have setup a JE Integration using eConnect and am trying to import AA data.  The integration is processing without error but the Trx Dimension Codes are not importing.  I'm on GP vs 10.00.1378.  I have setup the mapping on the Analytics to default for all and the mapping on the Dimensions for Trx Dimension, Trx Dimension AlphaNumberic Code, Trx Dimension ID and Trx Dimension Code ID.  Can anyone help with what I'm missing?

Thanks,

Debi

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Integration Manager and Analytical Accounting

    Guys how to set up the relation between the 4 sources?

    and what is the Keys?

    and which field should be the sort?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Integration Manager and Analytical Accounting

    I was pulled of this task but was not able resolve when working on it at the time of this thread.  I will attempt again tomorrow.  If anyone has made it work would appreciate the details.  thanks.

  • Aaron Burgard Profile Picture
    Aaron Burgard 20 on at
    Integration Manager and Analytical Accounting
    Hello,

    I'm wondering if there ever a resolution for this error? I'm having the exact same trouble when trying to import GL transactions with AA codes using eConnect.

    I am using 4 sources as described above:

    1. Jrn_Header: Trx, Trx Date, Reference
    2. Jrn_Detail: Trx, Account Number, Amount, AA Code
    3. Jrn_AA_Header: Trx, Account Number, Amount, AA Code, Assign ID
    4. Jrn_AA_Detail: Trx, Account Number, AA Code, Assign ID

    I am using the actual Jrn Number in the import file and linking these everywhere I can. The import does finish successfully but still fails to enter AA Codes.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Integration Manager and Analytical Accounting

    Hi
    on the header options tab you need select the source as the group source adaptor.  In my example I had 1 file and four source adaptors to help break out the information.

    Journal_Header
    Journal_Detail
    Journal_AA_Group
    Journal_AA_Detail

    The Journal_AA_Group is mapped to the Journal_Detail by account and journal number in the mapping window.

    kind regards
    Michael
     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Integration Manager and Analytical Accounting

    Hi Michael,  Thanks for the response! 

    I'm using one source file and have two source adapters.  the first source is used for my 'group' and the second is the detail.  I am integrating multiple journal entries in one file.  The first source I am using to group.   I have mapped all fields on the Options tab to the second source which is my 'detail'.  Should something be mapped to the Header source?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Integration Manager and Analytical Accounting

    I would say there is an issue in the Destination mapping section of the integration. Ensure for Analytics and dimension you have click the OPTIONS tab and specified your source.  The source should be mapped to your 2 source adaptors relating to the AA information (i have 4 source adaptors in my integration)

     Hope this helps

    Michael Nunes
    M4 Systems
    www.m4systems.com

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans