Configuring Invoice File Exports

Objective

After completing this lesson, you will be able to configure and schedule Invoice File Exports.

Configure Invoice File Exports

Steps

  1. Select Schedule

    In this section, administrators can determine how frequently the file export job will run by choosing from several scheduling options. You may set the export to run only when you need it by selecting On-Demand, or have it run automatically every day by choosing the Daily option. If you prefer the export to occur once every week, you can select Weekly.

    For situations where you want to run the export job twice each month, such as on the first and third weeks, selecting the Semi-Monthly – Days of Month option allows you to specify two particular days within each 30-day cycle. Alternatively, if a monthly export on a specific day works best for your process, you can select the Monthly option, so the extract runs just once each month.

    After selecting your preferred schedule, specific options, like semi-monthly or monthly, will allow you to customize your schedule further by choosing particular days the file export should occur. Once you decide, save your settings, and your export will run according to your defined schedule.

  2. Select Format

    In this section, you can choose between the default general ledger (GL) file format or customize the file format using the wizard's steps.

  3. Select Account String

    This option configures the export file's overall formatting. You can choose whether the file contains quotes, column headers, or offsetting entries. You can also determine the delimiter, date format, and file extension.

  4. General Settings

    This option configures the export file's overall formatting. You can choose whether the file contains quotes, column headers, or offsetting entries. You can also determine the delimiter, date format, and file extension.

  5. Define Header

    Choose a field to group the results. Grouping the results allows you to choose the fields in the header row.

  6. Define Details

    You can select the fields that appear for each journal entry and change their order.

  7. Summary

    View the complete configuration for the file export format.

    The image shows the File Export page with several subpages numbered: 1. Select Schedule, 2. Select Format, 3. Select Account String, 4. General Settings, 5. Define Header, 6. Define Details, and 7. Summary.

Resources

SAP Help PortalLink
Concur Invoice Standard Edition Administration GuidesFile Export Configuration

Summary

  • Configure file export schedules to run automatically (daily, weekly, semi-monthly, or monthly) or manually on demand.
  • Choose the default GL format or create a custom export file using the configuration wizard.
  • Customize account strings and fields for accurate financial integration, including segment length, padding, and justification.
  • Set general file settings, such as delimiters, column headers, date formats, and file extensions.
  • Define header groups and journal entry details, customizing fields and order to match organizational requirements.