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
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.
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.
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?
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.
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.
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.
[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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (