Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

General Journal Integration - default offset account

Posted on by 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

  • Clayton Ayers Profile Picture
    Clayton Ayers 115 on at
    RE: General Journal Integration - default offset account

    Since IM cannot create its own records, and in the two source GL Integration there is only one account number field; I decided to just create a macro that will create the offset account/amount for each debit record in the data file. But thank you for your help. 

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: General Journal Integration - default offset account

    If you look a the GL Transaction sample integration it shows how to use two data sources. They both may be the same file but you will see the technique.

  • Clayton Ayers Profile Picture
    Clayton Ayers 115 on at
    RE: General Journal Integration - default offset account

    For my integration there is only one Account number for the mapping, is there a different integration that has two Account Numbers that I can map for General Journal?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: General Journal Integration - default offset account

    I would have to play around with the integration but you need to not use a 'Separate Record Source' for the distributions. You could possibly set the offset account to default or Constant and the other account to what is in your file. IM does not have the ability to create records. If you could send a dummy file I could work on it tonight.

  • Clayton Ayers Profile Picture
    Clayton Ayers 115 on at
    RE: General Journal Integration - default offset account

    We only have the one GL account since it is being exported from an online bill payment system and we will need to keep a record of it in GP. So for all accounts no matter what they are, they are all going to have the same offset account. I am trying to do this with scripts  so that the end users do not have to worry about entering the offset account for each record on the export.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: General Journal Integration - default offset account

    Since you are supplying the GL accounts why don't you simply supply the default GL account as well in your import source? I am assuming the GL accounts you are supplying must vary from transaction to transaction. If not, do not even bother with you any accounts and let IM default both accounts.

  • Clayton Ayers Profile Picture
    Clayton Ayers 115 on at
    RE: General Journal Integration - default offset account

    [quote user="DebN"]

    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?

    [/quote]

    Does anyone know how to create the offset account via a script or what will IF NULL Use Default do. I have the posting accounts setup in Dynamics GP but when I run the integration all I get is the Debit amount without the offset account. 

    Any help is much appreciated as I know this post is old. 

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: General Journal Integration - default offset account

    Hi Deborah,

    I think you can accomplish what you want by setting the option IF Null to 'Use Default'. Take a look at the screenshot below and let us know if this is works for you.

    Kind regards,

    Leslie

  • DebN Profile Picture
    DebN 3,954 on at
    RE: General Journal Integration - default offset account

    Hi Bill, that'd be great!  Thank you!

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: General Journal Integration - default offset account

    Deb I dont have IM in front of me right now - when I do I will look at this closer.  I have a feeling that somewhere in my head I have done this exact same challenge - but I can not see it without touching the application.

    Sorry for the delay.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans