Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Integration Manager-Importing a General Journal

Posted on by 20

Created a new import for General Journals using Integration Manager.  Why would every transaction (row) come into the Transaction Entry in it's own General Journal Entry?

*This post is locked for comments

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Integration Manager-Importing a General Journal

    It's all about how you are grouping them in the integration.  What are the columns in your file?  Even if you have it in one sheet, you still need to think of them as Header and Line.  Header would be your BatchID, Reference, JE Date, etc...  The line would be debit or credit amount, account and distribution ref if you are using it.

    You have to give it a "key" field to connect the header and line in the relationships.  I always like to just use a field that isn't mapped, like associate them with a 1, 2, 3 or a, b,c. 

    Here's an example (hope it displays correctly) where I have 3 journal entries going into 1 batch.  In my header file, I would "group" by the JE Key

     

    JE KEY Batch Date Account Debit Credit
    1 Batch1 4/1/2012 11-22-33-44  $           -    $  100.00
    1 Batch1 4/1/2012 22-11-33-44  $    50.00  $           -  
    1 Batch1 4/1/2012 33-44-11-22  $    50.00  $           -  
    2 Batch1 4/1/2012 11-22-33-44  $  300.00  $           -  
    2 Batch1 4/1/2012 22-11-33-44  $           -    $  300.00
    3 Batch1 4/1/2012 44-11-22-33  $    25.00  $           -  
    3 Batch1 4/1/2012 11-22-33-44  $           -    $    50.00
    3 Batch1 4/1/2012 22-11-33-44  $    75.00  $           -  
    3 Batch1 4/1/2012 33-44-11-22  $           -    $    50.00

     

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!

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,228 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