to add a record with suspense settings.Use this screen to configure the defaulting of suspense values on the Import TE Expense Commitments application.
Click to add a record with suspense settings.
Use the Replacement Methods block to select the method by which the preprocessor replaces invalid data with the suspense values. In the Replacement Values group box, designate the values to be used for replacement.
Complete this screen and save your selections before running the Import TE Expense Commitments screen.
Use this drop-down list to specify how you want the Import TE Expense Commitments application to handle accounts that fail validation. Valid options are:
Account — Select this option to replace an invalid account with the project or non-project account entered in the Replacement Values group box. Only the account is replaced. The remaining data on the row is subject to normal validation procedures. If you select this method, you must enter a project and a non-project account in the Replacement Values group box.
Account/Org — Select this option to replace an invalid account and organization with the account and organization entered in the Replacement Values group box. When you save your selections, Costpoint verifies that they are linked in the Organization Account table. If you select this setting, you must also select it in all other applicable fields.
Prj/Acct/Org — Select this option to replace an invalid project/account/organization with the project account, non-project account, organization, and project entered in the Replacement Values group box. If it is a non-project account, only the account/organization is replaced. When you save your selections, Costpoint verifies that these items are linked. If you select this setting, you must also select it in all other applicable fields.
No Substitution — If you select this option, Costpoint selects those records that fail validation because of an account and writes them to the error file without uploading them. If you entered a project or non-project account in the Replacement Values group box, Costpoint does not use it.
Use this drop-down list to specify how you want the Import TE Expense Commitments application to handle organizations that fail validation. Valid options are:
Org — Select this setting to replace an invalid organization with the organization entered in the Replacement Values group box. Only the organization is replaced. The remaining data on the row is subject to normal validation procedures.
Account/Org — Select this option to replace an invalid account and the organization with the account and organization entered in the Replacement Values group box. When you save your selections, Costpoint verifies that they are linked in the Org Account table. If you select this setting, you must also select it in all other applicable fields.
Prj/Acct/Org — Select this option to replace an invalid project/account/organization with the project account, non-project account, organization, and project entered in the Replacement Values group box. Only the account/organization is replaced in the case of a non-project account. When you save your selections, Costpoint verifies that these items are linked. If you select this setting, you must also select it in all other applicable fields.
No Substitution — If you select this setting, Costpoint selects those records that fail validation because of an organization and writes them to the error file without uploading them. If you entered an organization in the Replacement Values group box, Costpoint does not use it.
Use this drop-down list to specify how you want the Import TE Expense Commitments application to handle projects that fail validation. Valid options are:
Project — Select this option to replace any invalid project with the project entered in the Replacement Values group box. Only the project is replaced. The remaining data on the row is subject to normal validation procedures.
Prj/Acct/Org — Select this option to replace an invalid project/account/organization with the project account, non-project account, organization, and project entered in the Replacement Values group box. If you select this setting, you must also select it in all other applicable fields.
No Substitution — If you select this option, Costpoint selects those records that fail validation because of a project and writes them to the error file without uploading them. If you entered a project in the Replacement Values group box, Costpoint does not use it.
Use this drop-down list to specify how you want the Import TE Expense Commitments application to handle account/organization combinations that fail validation. Valid options are:
Account — Select this option to replace the invalid account with the project or non-project account entered in the Replacement Values group box. Only the account will be replaced. The remaining data on the row is subject to normal validation procedures.
Org — Select this option to replace the invalid organization with the organization entered in the Replacement Values group box. Only the organization is replaced. The remaining data on the row is subject to normal validation procedures.
Account then Org — Select this option to replace the account with the account entered in the Replacement Values group box. If the new account/organization combination does not pass validation, the application also replaces the organization. Costpoint verifies that the accounts and organizations are properly linked in the Org Account table.
Prj/Acct/Org — Select this option to replace the project/account/organization with the project account, non-project account, organization, and project entered in the Replacement Values group box. If you select this setting, you must also select it in all other applicable fields.
Account/Org — Select this option to replace both the account and organization with the project account, a non-project account, and organization entered in the Replacement Values group box. When you save your selections, Costpoint verifies that they are linked in the Org Account table. If you select this setting, you must also select it in all other applicable fields.
Org then Account — Select this option to replace the organization with the organization in the Replacement Values group box. If this new combination fails validation, the application also replaces the account. The application also verifies that the accounts and organizations are properly linked in the Org Account table.
No Substitution — If you select this option, Costpoint selects those records that fail validation because of an account/organization combination and writes them to the error file without uploading them. If you entered an account/organization combination in the Replacement Values group box, Costpoint does not use it.
Use this drop-down list to specify how you want the Import TE Expense Commitments application to handle project/account/organization combinations that fail validation. Valid options are:
Account — Select this option to replace the invalid project/account/organization combination with the project or non-project account entered in the Replacement Values group box. Only the account is replaced. The remaining data on the row is subject to normal validation procedures.
Org — Select this option to replace the organization of the invalid project/account/ organization combination with the organization entered in the Replacement Values group box. Only the organization is replaced. The remaining data on the row is subject to normal validation procedures.
Project — Select this option to replace the project in the invalid project/account/organization combination with the project entered in the Replacement Values group box. Only the project is replaced. The remaining data on the row is subject to normal validation procedures.
Account/Org — Select this option to replace an invalid account and organization with the project account, a non-project account, and an organization entered in the Replacement Values group box. When you save your selections, Costpoint verifies that they are linked in the Org Account table. If you select this setting, you must also select it in all other applicable fields.
Prj/Acct/Org — Select this option to replace the project/account/organization with the project account, non-project account, organization, and project entered in the Replacement Values group box. If you select this setting, you must also select it in all other applicable fields.
Account/Org then Project — Select this option to replace the account and organization with the project account, non-project account, organization, and project entered in the Replacement Values group box. If the record still fails validation, the project is also replaced.
Acct then Org then Project — Select this option to replace the account first. If the new combination fails validation, Costpoint replaces the organization and project. If you select this setting, you must enter a project account, a non-project account, an organization, and a project in the Replacement Values group box.
Org then Acct then Project — Select this option to replace the organization. If that fails validation, then Costpoint replaces the account and project. You must enter a project account, a non-project account, an organization, and a project in the Replacement Values group box.
No Substitution — If you select this option, Costpoint selects those records that fail validation because of a project/account/organization combination and writes them to the error file without uploading them. Costpoint checks to see whether or not there is a project account, non-project account, organization, and project entered in the Replacement Values group box. If any of these are present and are not being used by some other validation method, Costpoint displays a warning message stating that these values will not be used in suspense processing. However, the values are not deleted.
Use this group box to designate the values that the Import TE Expense Commitments application uses to replace invalid data.
Enter, or click 
to select, a valid project ID that the application can use to replace an invalid project ID. The project ID must exist in the Project table.
Enter, or click to select, a valid project account ID that the application can use to replace an invalid project account ID. The project account ID must exist in the Account table.
Enter, or click to select, a valid non-project account ID that the application can use to replace an invalid non-project account ID. The non-project account ID must exist in the Account table.
Enter, or click to select, a valid organization ID that the application can use to replace an invalid organization ID. The organization ID must exist in the Org table.
Enter, or click to select, valid reference number IDs for reference 1 and/or reference 2. The application uses these IDs to replace any invalid reference number IDs. The reference number IDs must exist in the Reference Structure table.