Use the Export Options tab to set up and determine export requirements.
Note: From T&E 7.1.2 and higher, the Export Options tab supersedes the ExportExpense.properties file. If you are running 7.1.2 or higher, you must use this tab to configure all of your export options.
General
Use these options to determine general file layout requirements for expense reports.
| Field | Description |
|---|
| ASCII Layout
|
Use the drop-down list to select the ASCII Layout that should be used on your export file. The valid values are:
- Costpoint 7x or greater
- Costpoint 6x
- GCS
- None
|
| File Delimiter
|
Use the
File Delimiter drop-down list to select an alternative delimiter when exporting Expense data. This is necessary in cases where the expense report data you are exporting contains the same character that is being used as a delimiter.
Note: For example, if your Vendor IDs in Costpoint contain commas and you use a comma-delimited file to export data, you have to correct the data after you import it to Costpoint. If you change the delimiter to a semicolon, tab, or tilde, the integrity of your data is maintained during the import process.
You should ensure that the Expense Report data you are exporting does not contain the character (options include comma, semicolon, tab, and tilde) that you select as a delimiter.
|
| Export Taxes
|
Select this check box to export tax information.
|
| Export Base Currency Only
|
Select this check box to export only the system's base currency. If you select this check box, transactions or pay currencies used in the expense system are ignored.
|
Company Due
Use these options to determine how the system handles money that is due to the company after an expense report is completed.
| Field | Description |
|---|
| Do Nothing (Negative Voucher)
|
Select this button if you want the expense system to do nothing in regard to amounts that are due to the company. The expense report flows through to your financial system as a negative voucher.
|
| Charge Receivable (No Payment Information)
|
Select this button if you want the expense system to charge a Receivable account when the employee owes the company money. The system creates the "in" entry and the "out" entry in the export file.
|
| Charge Receivable (Require Payment Information)
|
Select this button if you want the expense system to charge a Receivable account when the employee owes the company money. The system creates the "in" entry and the "out" entry in the export file. The employee must identify the source used to repay the company.
Once you select this option, you may then specify which options are available to the employee to use to repay the company. The valid selections are:
|
