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 "Import and Export Data" chapter in the Time & Expense with ESS Technical Guide for more information.
Use this screen any time you wish to export expense report transactions.
The Export Expense Reports screen is a process application. There are no tabs in this screen.
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."
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.
Use the Include field drop-down to select whether you are exporting regular expense reports, expense reports that have been corrected, or both types of expense reports.
When you export correcting expense reports, Deltek Expense exports the expense reports that contain the new changes, including any expense amounts payable to the employee, as well as a correcting report, which backs out the information contained in the original expense report.
For example, say an expense report is processed for $500.00, and the employee later submits a correcting expense report for $600.00. Upon export, the corrected expense report generates a $600.00 voucher, but the Corrections table generates a voucher for -500.00, backing out the original expense amount. The employee then receives the difference between the two vouchers, or in this case $100.00.
To learn more about the Correct Expense reports feature, see Special Topic: Correcting Expense Reports.
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."
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."
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."
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:
The expense report must meet the export criteria for expense report types "Approved" or "Approved and Receipts."
The expense report must fall within start and end date range.
The expense report's employee must be a member of the selected class.
The expense report's employee must be a member of selected group.
The expense report's type must be one of the selected types.
The expense report must be available, i.e., it cannot be part of an already running export process.
If you use Costpoint Multicompany, the expense report's employee must have been assigned to the appropriate Costpoint company when the expense report was created.
If the export timesheets process completes normally, the system will display the following message: "Process completed successfully."
Select the Preview/Print button to bring up the Print dialog, where you can select the export report(s) that you wish to review.
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.
When you print expense reports that you have selected for export, the cover page displays the types of reports you exported, either regular, correcting, or both. If you have printed any correcting expense reports, the Correction No of the report displays in the header area.
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."