Summary

The Export Journal Entries feature allows you to create an export file of the journal entries created during a fiscal year, fiscal period or journal entry date range.

Step by Step

1     Open the Export Journal Entries window (GL> Utilities> Export Journal Entries).

2     Configure the journal entry filters.

• The left section of the window is used to filter the journal entries that will be included in the export file.
• Select a Date Filter Type from the drop-down menu.
  • The selected filter type will determine which fields are enabled below.
• Specify a Fiscal Year to filter the included journal entries by fiscal year.
• Enter a Fiscal Period to filter the included journal entries by fiscal year and fiscal period
  • This field will only be active if Period is selected in the Filter Type field.
• Specify a date range in the Begin Date and End Date fields. This will limit the journal entries included in the export file to those with a journal entry date that falls within the specified dates.
  • These fields will only be active if JE Date is selected in the Filter Type field.
• Select the System and Process where the journal entries will be exported from.
  • These fields will determine which batches are available for selection in the Batch field below.
• The Configuration field is used to specify the configuration for the export file.
  • Export file configurations are created and maintained on the Export Configuration Maintenance window (SS> Maintenance> Export Configuration).
  • Once a configuration is selected, click the Display icon to display the expected file layout. 
• Click the Confirm icon   when complete to generate the export file.
• Once the export has finished processing, the Export Settings window will open. This window is used to specify the export path for the file.
  • Check the Open toggle if you would like to open the exported file after it is saved locally.
  • Enter the export path location and click the Save icon   to export the file to the local path.