to select, a valid project ID that the preprocessor can use to replace an invalid project ID. The project ID entered must exist in the Project table.This screen consists of two major blocks: Replacement Methods and Replacement Values. Use the Replacement Methods block to select the method by which the preprocessor will replace invalid data with the suspense values. In the Replacement block, you can designate the values to be used for replacement.
Complete this screen and save your selections before running the Import Timesheets screen. The preprocessor uses your selections to replace invalid charging data with the selected suspense value data and data replacement method.
Use this block to specify the data replacement method you want the preprocessor to use. You can choose either a "single" method (for example, Account only, Project only) or a "combination" method (for example, Acct/Org or Proj/Acct/Org) for replacing items that fail the preprocessor validations. You cannot select both methods across the different validation items; that is, if a "combination" method is selected in one field, that same "combination" method must be selected in all fields, where applicable. If you select a "single" method, other validations are automatically set to No Substitution.
From the drop-down list, specify how you want the preprocessor to handle accounts that fail validation. Valid options are:
Account — If you select this option, the preprocessor replaces the invalid account with the project or non-project account entered in the Replacement Values block. Only the account is replaced; the remaining information on the row is subjected to normal validation procedures. This method verifies that a project and a non-project account are entered in the Replacement Values block.
Account/Org — Select this option to replace both the account and the organization if the account fails any validations. If you select this option, you must also set the other validation methods (except Project and PLC) to Account/Org. The application verifies that an account and an organization are entered in the Replacement Values block and that they are linked in the Organization Account table.
Proj/Acct/Org — Select this option to replace the project/account/organization when an account fails validation. Only the account/organization are replaced if it is a non-project account. If you select this option, you must also set the other validation methods (except PLC) to Proj/Acct/Org. When you save your selections, the application verifies that a project account, non-project account, organization, and project are entered in the Replacement Values block. It also validates that these items are appropriately linked.
No Substitution — If you select this option, the application selects those records that fail validation because of an account and writes them to the error file without uploading them. The application checks to see whether a project or non-project account is entered in the Replacement Values block, but does not delete the accounts. However, any project or non-project account entered there is not used in suspense processing if this method is selected.
From the drop-down list, specify how you want the preprocessor to handle organizations that fail validation. Valid options are:
Org — If you select this option, the preprocessor replaces the invalid organization with the organization entered in the Replacement Values block. Only the organization is replaced; the remaining information on the row is subjected to normal validation procedures. The application verifies that an organization is entered in the Replacement Values block.
Account/Org — Select this option to replace both the account and the organization if the organization fails any validations. If you select this option, you must also set the other validation methods (except Project and PLC) to Account/Org. The application verifies that an account and organization are entered in the Replacement Values block and that they are linked in the Org Account table.
Proj/Acct/Org — Select this option to replace the project/account/organization when an organization fails validation. Only the account/organization is replaced in the case of a non-project account. If you select this option, you must also set the other validation methods (except PLC) to Proj/Acct/Org. When you save your selections, the application verifies that a project account, non-project account, organization, and project are entered in the Replacement Values block. It also validates that these items are appropriately linked.
No Substitution — If you select this option, the application selects those records that fail validation because of an organization and writes them to the error file without uploading them. The application checks to see whether an organization is entered in the Replacement Values block but does not delete the organization. However, any organization entered there is not used in suspense processing if this method is selected.
From the drop-down list, specify how you want the preprocessor 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 block. Only the project is replaced; the remaining information on the row is subjected to normal validation procedures. The application verifies that a project has been entered in the Replacement Values block.
Proj/Acct/Org — Select this option to replace the project/account/organization when a project fails validation. If you select this option, you must also set the other validation methods (except PLC) to Proj/Acct/Org. When you save your selections, the application verifies that a project account, non-project account, organization, and project is entered in the Replacement Values block.
No Substitution — If you select this option, the application selects those records that fail validation because of a project and writes them to the error file without uploading them. The application checks to see whether a project is entered in the Replacement Values block but does not delete the project. However, any project entered there is not used in suspense processing if this method is selected.
From the drop-down list, specify how you want the preprocessor to handle PLCs that fail validation. Valid options are:
PLC — Select this option to replace the invalid PLC with the PLC entered in the Replacement Values block. Only the PLC is replaced; the remaining information on the row is subjected to normal validation procedures. The application verifies that a PLC is entered in the Replacement Values block.
PLC/Proj — Select this option to replace the PLC and the project when the PLC fails validation. The application checks the Project Labor Category table to see whether the PLC/project is valid. The application also checks the Replacement Values block to see whether a replacement project and PLC are provided.
PLC, then Proj — If you select this option, the preprocessor first replaces the PLC with the suspense PLC. If the new combination still does not pass validation, the preprocessor replaces the project as well. The application also verifies that the project and PLC are in the Project Labor Category table.
No Substitution — If you select this option, the application selects those records that fail validation because of a PLC and writes them to the error file without uploading them. The application checks to see whether a PLC is entered in the Replacement Values block but does not delete the PLC. However, any PLC entered there is not used in suspense processing if this method is selected.
From the drop-down list, specify how you want the preprocessor to handle account/organization combination that fails 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 block. Only the account is replaced; the remaining information on the row is subjected to normal validation procedures. The application verifies that a project and a non-project account are entered in the Replacement Values block.
Acct, then Org — If you select this option, the preprocessor first replaces the account with the suspense account. If the new account/organization combination does not pass validation, the preprocessor also replaces the organization. The application also verifies that the accounts and organizations are properly linked in the Org Account table.
Proj/Acct/Org — Select this option to replace the project/account/organization when an account/organization combination fails validation. If you select this option, you must also set the other validation methods (except PLC) to Proj/Acct/Org. When you save your selections, the application verifies that a project account, non-project account, organization, and project are entered in the Replacement Values block.
Org — If you select this option, the preprocessor will replace the invalid organization with the organization entered in the Replacement Values block. Only the organization is replaced; the remaining information on the row is subjected to normal validation procedures. The application verifies that an organization is entered in the Replacement Values block.
Org, then Acct — If you select this option, the preprocessor first replaces the organization with the suspense organization. If this new combination fails validation, the preprocessor also replaces the account. The application also verifies that the accounts and organizations are properly linked in the Org Account table.
Account/Org — Select this option to replace both the account and the organization if the account/organization combination fails any validations. If you select this option, you must also set the other validation methods (except Project and PLC) to Account/Org. The application verifies that a project account, a non-project account, and an organization are entered in the Replacement Values block, and that they are linked in the Org Account table.
No Substitution — If you select this option, the preprocessor selects those records that fail validation because of an account/organization combination and writes them to the error file without uploading them. The application checks to see whether an account/organization combination is entered in the Replacement Values block but does not delete it. However, any account or organization entered there is not used in suspense processing if you select this method.
From the drop-down list, specify how you want the preprocessor to handle project/account/organization combination that fails validation. Valid options are:
Account — If this method is selected, the preprocessor replaces the invalid project/account/organization combination with the project or non-project account entered in the Replacement Values block. Only the account is replaced; the remaining information on the row is subjected to normal validation procedures. If you select this method, the application verifies that a project and a non-project account are entered in the Replacement Values block.
Account/Org — Select this option to replace both the account and the organization if the account/organization combination fails any validations. If you select this option, you must also set the other validation methods (except Project and PLC) to Account/Org. The application verifies that a project account, a non-project account, and an organization are entered in the Replacement Values block and that they are linked in the Org Account table.
Proj/Acct/Org — Select this option to replace the project/account/organization when a project/account/organization combination fails validation. If you select this option, you must also set the other validation methods (except PLC) to Proj/Acct/Org. When you save your selections, the application verifies that a project account, non-project account, organization, and project are entered in the Replacement Values block.
Account/Org, then Project — If you select this option, the preprocessor first replaces the account and organization. If the record still fails validation, the project is also replaced. The application verifies that a project account, a non-project account, an organization, and a project are provided in the Replacement Values block.
Org — Select this option to replace the organization of the invalid project/account/ organization combination with the organization entered in the Replacement Values block. Only the organization is replaced; the remaining information on the row is subjected to normal validation procedures. The application verifies that an organization is entered in the Replacement Values block.
Acct, then Org, then Project — If you select this option, the preprocessor replaces the account first. If the new combination fails validation, it replaces the organization and project. The application verifies that a project account, a non-project account, an organization, and a project are entered in the Replacement Values block.
Org, then Acct, then Project — Select this option to replace the organization. If that fails validation, the program replaces the account and project. The application verifies that a project account, a non-project account, an organization, and a project are entered in the Replacement Values block.
Project — If you select this option, the preprocessor replaces the project in the invalid project/account/organization combination with the project entered in the Replacement Values block. Only the project is replaced; the remaining information on the row is subjected to normal validation procedures. The application verifies that a project is entered in the Replacement Values block.
No Substitution — If you select this option, the preprocessor selects those records that fail validation because of a project/account/organization combination and writes them to the error file without uploading them. The application checks to see whether a project account, non-project account, organization, and project are entered in the Replacement Values block. If any of these are present and are not being used by some other validation method, the application displays a warning message stating that these values will not be used in suspense processing. However, the values are not deleted.
Use this block to designate values that the preprocessor uses to replace invalid data.
Enter, or click to select, a valid project ID that the preprocessor can use to replace an invalid project ID. The project ID entered must exist in the Project table.
Enter, or click to select, a valid project account ID that the preprocessor 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 preprocessor 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 preprocessor 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 preprocessor uses these IDs to replace any invalid reference number IDs. The reference number IDs must exist in the Reference Structure table.
Enter, or click to select, a valid Project Labor Category (PLC) code that the preprocessor can use to replace an invalid PLC code. The PLC code must exist in the Billable Labor Category table.
Enter, or click to select, a valid General Labor Category (GLC) code that the preprocessor can use to replace an invalid GLC code. The GLC code must exist in the General Labor Category table.
Once you have made your selections, click 
to save them. The application uses these selections to replace invalid charging information when you run the Import Timesheets screen.