GL Journal Import process update

posted Jun 3, 2020, 1:44 PM by Barbara Thiss
We had sent out an announcement on Tuesday, June 2, 2020 referencing the new GL Import Template and Macro. We have found a few addition changes to the Import process.

These 3 files need to be in the same folder for the GL Import Process to work. Files are available on the PeopleSoft Support website under Resources > General Ledger-GL1 Use Excel to Create Journal Entries. 
  • JRNL1_WS_SDF92.xlsm - this is the template
  • JRNLMCRO_WS.xlam – this is the macro
  • GLLOG.xlt – this is a file that is needed in the process. Users only need to make sure it is in the folder.
Process Scheduler Request change:
  • Select the Journal Import with Edit Process Name GL_EXCL_BATC
GL Import Process Scheduler

If you have any questions please submit a Service Portal ticket.