web
You’re offline. This is a read only version of the page.
close
Skip to main content

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) / General Journal Integr...
Microsoft Dynamics GP (Archived)

General Journal Integration - default offset account

(0) ShareShare
ReportReport
Posted on by DebN 3,954

Is there a way to get Integration Manager to use a default offset account for a GJ integration?  Each journal entry will consist of just two accounts.  If we have one half of the entry in a file, can we use an AfterDocument script (or some other script) to create the second record with the offset account and amount?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Deb I have found that in doing a GL integration I use a two source file approach.

    Same single data file, but filter one on the Offset account - gives you the header and the second unfiltered and called Detail.

    Then when you place the fields into the IM you pick the details from Detail and Header from Header

    If that does not make sense let me know I can spend more time developing a clearer answer, but if this helps let others know.

  • DebN Profile Picture
    DebN 3,954 on at

    Hi Bill,

    I am using the two file approach.  The problem is with the detail.  I have just one side of the entry and I want to default the other side.  For instance, I have a Debit Account and Debit Amount.  Now I need a script or something to default the Credit Account and Credit Amount (same as the debit amount).   Thanks!

  • Community Member Profile Picture
    Community Member on at

    Hi,

    I agree with Bill. It can be done using a single source file or it can be multiple files based on your requirement.

    Assuming from your post, that you will be getting a source file with single entry for the GL ? Assuming "yes"

    If you know the second account which is common account to all the GL entries , you can directly map it in the IM as Constant Value or in the source file. But, assuming  the amount may vary for  all the GL, so you need to map the Amount from the Source file.

  • Community Member Profile Picture
    Community Member on at

    Do you know your credit account? It's there in the source file? You can map the Debit Amount to the Credit Amount directly using the mapping options in IM.

    Note: If it is just a two lines GL entries.

  • DebN Profile Picture
    DebN 3,954 on at

    Hi Shan,

    In our file, we have one row per GJ entry.  And, we actually have both the Debit and Credit accounts in the one row, even though the Offset account is the same for each entry.  However, in IM we can only map to one account.  How do we get the other side of the entry?

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Deb can you clip the first couple of rows of data from the source file.

    I am a better visual person - I do so like to see what is baffling me.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I agree with Bill. If you could share the screenshot of your source file and additionally your  IM setup for the Integration (Header,Details & field mapping) . I believe the problem will be in field mapping and the linking with Header & Detail Source.

    Note: You can check the existing sample integration for GJ in IM (File>> Open). It will give you some idea about the source file and the field mappings.

  • DebN Profile Picture
    DebN 3,954 on at

    Below is a screenshot of the import file.  Column C "Debit_Credit" pertains to the GL_Offset Account.  Each "Patient Code" will get its own journal entry.

    So, looking at the first row of data, the first journal entry should be as follows:

    Debit  0200-100-1005 $440.00

    Credit 0200-100-1100 $440.00

    Thank you!

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at

    When you map

    - Debit Account - A

    - Debit Amount - H

    - Credit Account - D

    - Credit Amount - H

    To do the header, you can use the same file - you dont need a second file as you only have a single line per transaction.

    If you still have issues, post a screen of the IM and we will move from there.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    Correct me if I am wrong, first save your source file as two files and run the integration to two times.

    1. Debit_Credit column should be "Credit" (Map the Debit_Credit as credit line and GLAccount as debit line).

    2. Debit_Credit column should be "Debit"(Map the Debit_Credit as debit line and GLAccount as credit line).

    Run the both file separately.

    Hope this helps!!!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans