Export Expense Reports

If the Costpoint Multicompany checkbox is selected in the General Configuration screen, this field will be displayed. Because Costpoint can receive expense reports only for one company at a time, use this drop-down box to select the Costpoint company for which you wish to export.

Enter up to 10 characters for a unique export batch identifier. If the batch ID has already been used, the system will display the following error message: "Batch ID has already been used. Please enter a different one."

Batch ID is a required field. If you do not supply an ID, the system will display the following error message: "Batch ID is required."

Note: If the export is transformed to an ASCII file, the Batch ID will be part of the name of the file. See "Export Transformer" section for further information.

Enter the start date for which you want to select expense reports. The application compares this date to the expense report date. An expense report dated on or after this date will be selected for export if it matches the other criteria. This field is optional. If you leave this field blank, the export process will select expense reports using other criteria.

Enter the end date for which you want to select expense reports. The application compares this date to the expense report date. An expense report dated on or before this date will be selected for export if it matches the other criteria. This field is optional and defaults to current date.

Hint: If you want to clear the End Date, select the Calendar Lookup icon and then select the Clear pushbutton.

Select the group type description from the drop-down box. The available employee group types are those that you supervise. If employees in an Employee Group do not have any expense reports ready to export, that group will not be listed. If one employee has even one expense report that is ready for export, that Employee Group will be available. The list is displayed in alphabetical order.

Once you have selected the Type, the non-editable text box will display the groups that contain expense reports that can be exported for the selected group type. The groups are listed in alphabetical order.

Select the group(s) that you wish to include in the export or use the Select All pushbutton to select all groups. You can select multiple groups. If you do not select a group, the system will display the following error message: "No employee groups are selected."

Use the drop-down box to select the report that you wish to print. The available options are as follows:

Expense Report - Select this option to print all expense reports selected for export. If you select this option, you can use the Type drop-down box to select the type of export.

Charge Allocation - Select this option to print a report that is sorted by vendor ID with breaks by expense report. This report displays the charge allocation information in the system's base currency. If you select this option, the Type drop-down box will not be available.

Use the drop-down box to select which parts of the expense report you want to print. The available options are "Summary," "Detail," or "Both." These same options are available in the expense report screen less the Receipt Traveler.

Select the Submit pushbutton to preview the report in Adobe Acrobat format. Select the printer icon in Acrobat to print the report.

Select the Cancel pushbutton to return to the Export Expense Report screen without previewing the report.

Select the Export pushbutton to update the appropriate staging tables with the information collected when you selected the Process pushbutton. The Export pushbutton will be disabled until that process has run.

You can run 10 exports at the same time. If more than 10 users attempt to export expense reports, the system will display the following error message: "Maximum concurrency for export has been met. Please try again later."

In addition to writing records to the staging tables, the system performs the following updates:

Expense Report status is changed to "Processed."
Expense Report is marked as being available.

If the export process, including the transformation step, finishes normally, the system will display the following message: "Export completed successfully."

Select the Close pushbutton to close the screen. If you have run the Process step but not the Export step, the information collected during the Process step will be cleared. If the clearing completes normally, the system will display the following message: "Rollback completed successfully."

Export Expense Reports

Use this screen to export expense reports to an expense report staging table. Whether an expense report is exported when approved, or when approved and receipts received, depends on the expense report type.

The expense report transactions remain in these staging tables for pickup, or the export application may call a Transformer that will transform the table entries into a specific ASCII layout. Click here for more information.

Also review the "Export Expense Report Data" section in the Technical Guide for more information.

When do I use the Export Expense Reports screen?

The Export Expense Reports screen

The Export Expense Reports screen is a process application. There are no tabs in this screen.

Options

Groups

Classes

This non-editable text box displays the expense classes that have employees with expense reports that can be exported. They are listed in alphabetical order.

Select the class(es) that you wish to include in the export or use the Select All pushbutton to select all classes. You can select multiple classes. If you do not select a class, the system will display the following error message: "No classes are selected."

Expense Report Types

This non-editable text box displays the classes that contain expense reports of the type that can be exported. They are listed in alphabetical order.

Select the expense report type(s) that you wish to include in the export or use the Select All pushbutton to select all expense report types. You can select multiple expense report types. If you do not select an expense report type, the system will display the following error message: "No expense report types are selected."

Process

Select the Process pushbutton to start collecting the expense report data that will be exported when you select the Export pushbutton. You can print and preview this data using the Preview/Print pushbutton.

You can process 10 expense report exports at the same time. If more than 10 users attempt to run the export expense report process, the system will display the following error message: "Maximum concurrency for export has been met. Please try again later."

Before beginning, the system marks expense reports meeting the selection criteria as unavailable so that they cannot be changed while the process is executing. If no expense reports are found meeting the criteria, the system displays the following error message: "No expense reports found to process."

In order for expense report records to meet the selection criteria for processing, the following conditions must be met:

If the export timesheets process completes normally, the system will display the following message: "Process completed successfully."

Preview/Print

Select the Preview/Print pushbutton to bring up the Print dialog, where you can select the export report(s) that you wish to review.