Use this group box to determine the starting and ending position in the credit card file that identifies the employee ID or provider ID. The credit card file is typically a flat file where each row represents an expense. Each field in the row has a purpose, and one of those purposes is providing the employee ID or the provider ID.
In Position, enter the position number in the credit card file that contains the first character of the employee ID.
In Starting Position, enter the position number in the credit card file that contains the first character of the employee ID.
In Ending Position, enter the position number in the credit card file that is used for the last character of the employee ID. The actual employee ID may not take up all of the positions from the Starting position to the Ending position or may even be blank from row to row, but this number represents the allotted number of positions available for the employee ID.
In Compare To, use the drop-down box to select which field in Deltek Expense that the employee ID in the file should be compared to. The valid values are "Employee ID," "Government ID," "Pay Method Reference," "User Defined Field 1," "User Defined Field 2," or "User Defined Field 3."
In Starting Position, enter the position number in the credit card file that contains the first character of the Provider ID.
In Ending Position, enter the position number in the credit card file that is used for the last character of the provider ID. The actual Provider ID may not take up all of the positions from the Starting position to the Ending position or may even be blank from row to row, but this number represents the allotted number of positions available for the provider ID.
In Compare To, use the drop-down box to select which field in Deltek Expense that the employee ID in the file should be compared to. The valid values are "Provider Code," "User Defined Field 1," "User Defined Field 2," or "User Defined Field 3."
Select this checkbox if you are running Costpoint using the Multi-Currency option turned on, and you want the expenses in the file to be imported in their various currencies. Left unselected, the expenses are imported in each employee's base currency.
From the Amex File Size drop-down list, select the desired import size for American Express credit card files. While the default of 5 MG is sufficient for most companies, other available choices are:
10 MG
20 MG
40 MG
80 MG
Larger files take longer to import and require greater system resources, so if your company does not require large file sizes, you may want to use the default value (5 MG) for importing American Express charges.
From the Car Rental Wizard drop-down list, select Car Rental to map imported car rental expenses to the Car Rental expense type code. Or, if desired, select Other to map them to the Other expense type code.
By default, imported car rental expenses map to the Car Rental expense type code, but if your firm does not use this expense type, employees won't be able to view their car rental expenses unless the mapping is changed to Other.
From the Lodging Wizard drop-down list, select Lodging to map imported lodging expenses to the lodging expense type code. Or, if desired, select Other to map them to the Other expense type code.
By default, imported lodging expenses map to the lodging expense type code, but if your firm does not use this expense type, employees won't be able to view their lodging expenses unless the mapping is changed to Other.
From the Transportation Wizard drop-down list, select Transportation to map imported transportation expenses to the transportation expense type code. Or, if desired, select Other to map them to the Other expense type code.
By default, imported transportation expenses map to the Transportation expense type code, but if your firm does not use this expense type, employees won't be able to view their transportation expenses unless the mapping is changed to Other.
From the Meals Wizard drop-down list, select Meals to map imported meal expenses to the Meals expense type code. Or, if desired, select Other to map them to the Other expense type code.
By default, imported meal expenses map to the Meals expense type code, but if your firm does not use this expense type, employees won't be able to view their meal expenses unless the mapping is changed to Other.
Use this group box to determine whether expenses should be included or excluded as determined by the value contained in certain fields and the filters that you set up.
Select this option to include expenses that meet the filter that you set up.
Select this option to exclude expenses that meet the filter that you set up.
Use this group box to determine whether the rule applies to all filters or any filters.
Select this option if the filter must meet ALL of the criteria filters that you have set up.
Select this option if the filter can meet ANY of the criteria filters that you have set up.
Use this table to add or delete batch type filters.
Enter the position number in the credit card file that contains the first character of the section that you want to filter. This must be a numeric value and is a required field.
Enter the position number in the credit card file that contains the last character of the section that you want to filter. This must be a numeric value and is a required field.
Enter the value that is listed between the starting and ending position that should be filtered. If you selected Include Expenses that Meet Filter as the Filter Type, any rows that contain this value will be included in the Batch Expenses. If you selected Exclude Expenses that Meet Filter as the Filter Type, any rows that contain this value will NOT be included in the Batch Expenses. This can be an alpha or a numeric value and is a required field.
Enter any notes regarding this filter. This field is optional.
Click Add Filter to add a filter to this batch type.
To delete a filter, select the checkbox to the left of the row or rows that you wish to delete. Then click Delete Filter to delete the row or rows.
