You’re offline. This is a read only version of the page.
700
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
Thanks for your help! Jim
The source would be the csv file or the file that the integration is mapping to/using. You can use the same source file in the integration and design your integration to pull the header information from the source file which would be the Date for example, then line information which would be Accounts, Amounts, etc. Then build a relationship between the Header and Detail in integration manager. Header being the information at the top of GP window and Detail being the information in the scrolling window of the GP window. The trouble I had with IC integrations was that in the xls file the source file, I had to remove the dashes on the account number before this integation would work. So the source file needs to be prepped in Excel, then saved as a csv file and used by the integraiton.
to MPOLINO-
A year later and a new position with a new company. We just acquired another company and need to use IM to do Intercompany. My notes on this are a little vague, so I came back to your post. What do you mean by Source Detail in the comment above? Name of the file? Thanks, Jim
Good news and thanks for letting me know. Cheers Bruce
Perfect. Worked like a charm after adding the missing ". Thank you so much. This will save our AP team a lot of time.
Sarah,
Sorry forgot to reply to your other question about purchasing integration. I use it in Payables Transaction integration.
Regards,
Bruce
Sarah,
You left off " quotation mark in front of AP Detail.AcctCode. So it should be
sAcctCode = SourceFields("AP Detail.AcctCode")
I hate those :)
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.
Jim,
That's good news and thanks for letting me know.
Cheers Bruce
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (