Notifications
Announcements
No record found.
Is it possible to use the intercompany feature when importing a journal entry using Integration Manager? How would that set up work? We are on GP 10
*This post is locked for comments
When you import via Integration Manager, there is an intercompany checkbox that can be selected via the integration to mark the transaction as intercompany. You'll need to add to/from companies as part of the integration since GP needs to know which chart to look at when entering an account number.
You can do it and it works quite well.
Mark
I am running into the same problem, but in GP 2010, I am getting an alphanumeric or lowercase error in the account number column. Removing the dashes makes the account number unreadable and it loses the leading zero.
In IM under destination mapping>general ledger, select Use Constant beside Intercompany and select True under Souce. Then in upload file have column for Company. Make sure each row has either the originating company or destination company in Company column. Then under Entries field map to that column. Also you don't need to remove the dashes from the account number.
Bruce
I am getting the same error about the account number being non-alphanumeric or lowecase. I have a column in my source file is for the Company ID. But there is only one fiel to map it to. How do you tell IM that it is either the To or the From company. I see a Translatioin field with NO value for the Intercompany ID. I have not been able to get that to work. Can you clarify a little more mpolino? Intercompany is set to true under General Journal which sets the flag on the header are of the JE. Intercompany ID is mapped to my source field that has the company ID in it. It still fails.
Sheila
When you normally do an intercompany entry using General Ledger Transaction window you will notice that the Account Number field in distribution window doesn't accept dashes when entering the Account Number. So you have to tell the integration to convert the Account Number in your upload file to remove the dashes. You do this by selecting Use Script under Rule beside Account Number. Then click on Yes under Value column and the ellipses will appear. Click on it and the Script Editor window will open. Then type the following:
sAccount = SourceFields(GL Detail.Account")
sAccount = Replace(sAccount, "-", "")
CurrentField = sAccount
Just to clarify GL Detail is the name of my Source Detail and so change it to what you have called your source detail. Then Account is the column in source file where you have account number.
The above script is removing the dashes from the account number. Close Script Editor and save.
That worked, thank you so much! What was confusing to me is that if I removed the mapping of the intercompany id, the integration would work just fine using the account numbers with dashes in them. So it must have something to do with intercompany and another distribution window. I have JE integrations all the time and don't remove the dashes but the intercompany must requrie it. Thanks so much, I appreciate the quick response!
Glad that worked for you.
Cheers,
Bruce, it worked for me as well. Thanks for your help! Jim
Jim,
That's good news and thanks for letting me know.
Cheers Bruce
Bruce,
Does the same approach work for purchasing integrations? I was receiving the same error as Jim above so I tried typing the script you have provided. I replaced "GL Detail" with "AP Detail" as that is what I named the table. I also replaced "Account" with "AcctCode" for the same reason. However I get the following error:
Primary Message: Error Compiling Script 'For Field Distributions.Distribution Account' Line 1: - Expected ')'
Exception Message: Error Compiling Script 'For Field Distributions.Distribution Account' Line 1:
Inner Exception Message: Expected ')'
Here is what typed:
sAcctCode = SourceFields(AP Detail.AcctCode")
sAcctCode = Replace(sAcctCode, "-", "")
CurrentField = sAcctCode
Thanks in advance for any help you can provide.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
