Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Integration Manager - ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Integration Manager - Journal Entry Adapter

(0) ShareShare
ReportReport
Posted on by mike_peck 45

I am trying to integrate a 40 + line entry. The integration fails because the source file lists a single Journal Entry Number, but each line of the source is being treated as a stand-alone entry, so an error message is generated that the distributions are out of balance for every line. I have also tried making the Journal Number a Constant, which did not work either.

There must be something I need to do to indicate 

I have tried adding the Journal Number to the sorting screen, but I believe there is another setup element I need to make this integration work properly.

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Integration Manager - Journal Entry Adapter

    I agree with Beat on this one,

    This is the solution that works for us all the time. Using one file as the source, you create two different Integrations.

    Create a one liner - as the header - filter the data file for one specific account number.

    Create the balance (including the first line) as the detail - use the Journal Number as the link between the two.  The date would work if you only ever were going to have a single Journal Entry at a time.  Even if you had to add this value to each line, for me it works all the time.

    Hope this helps.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Integration Manager - Journal Entry Adapter

    Hi Mike,

    Have you tried to split the source into a header & detail parts (using the same input file)  and create a relationship based on the date field for example ?

  • mike_peck Profile Picture
    mike_peck 45 on at
    Integration Manager - Journal Entry Adapter

    I am trying to integrate a 40 + line entry. The integration fails because the source file lists a single Journal Entry Number, but each line of the source is being treated as a stand-alone entry, so an error message is generated that the distributions are out of balance for every line. I have also tried making the Journal Number a Constant, which did not work either.

    There must be something I need to do to indicate 

    I have tried adding the Journal Number to the sorting screen, but I believe there is another setup element I need to make this integration work properly.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans