Use this tab to set up and determine export requirements. You can determine those UDT’s that should not be exported by including them in the Export Filter table and determine the file layout for Labor Distribution and Payroll.
This table displays UDT01 through UDT15 as the first column, which is non-editable.
If you have a UDT value that you do NOT wish to export, enter that value in the appropriate UDT column. The system will remove the UDT that is entered here on those timesheets that contain it.
If you have a range of UDTs that should not be exported, you can use a Wildcard to remove values that start with a specific character or characters. By entering a “%” after the character, the system removes any UDT that starts with the character. By entering the "%" before the character or characters, it filters out any UDT that ends with that value.
Select the check box if you want the system to export the UDT. It will export all UDTs except for any that are specified in the Export Filter field(s). The default value is selected.
This section is used to determine general file layout requirements for expense reports.
Use the drop-down 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
This field is available only if you select “Costpoint 6x and Greater” from the ASCII Layout drop-down list. For all other layout options, this field is disabled and defaults to “Comma.”
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.
For example, if your Vendor IDs in Costpoint contain commas and you use a comma-delimited file to export data, you will 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.
Select this check box to export tax information.
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.
Use this section to determine how the system handles money that is due to the company after an expense report is completed.
Select this radio 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.
Select this radio 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.
Select this radio 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:
Cash
Check
Payroll Deduction
Other
You can select as many options as you like. Employees who owe money to the company can select a repayment method on the wizard page that displays upon signing the expense report.