
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 the same question (0)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