215
Hi,
I am using an excel spreadsheet to import large journals in GP2015 R2 using Integration Manager but I need to write back the Journal Entry Number created to the Excel spreadsheet for reference. Does anyone have the code required for IM to do this?
I am able to write back to a table but I need it in the Excel spreadsheet instead.
Many thanks!
*This post is locked for comments
I have never seen anyone write back to a source data file.
A thought...
Use the Distribution Reference field to record a unique Excel reference number. Import the Excel. Use Smartlist to export JE number and Distribution Reference. Add that information back to existing sheet.
Tim
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (