Contents of The Manage Journal Entry Preprocessor Settings Screen
Use the fields and options to configure the Manage Journal Entry Preprocessor Settings screen.
Replacement Methods
Use this group box to specify the data replacement method you want the preprocessor to use. You can choose either a "single" method (such as account only or project only) or a "combination" method (such as account/organization or Project Acct/Org) for replacing items that fail the preprocessor validations. You cannot select both methods across the different validation items.
- If you select a "combination" method in one box, you must select that same "combination" method in all group boxes, where applicable.
- If you select a "single" method, Costpoint automatically sets other validations to No Substitution.
If Account fails replace
Use this group box to specify how you want the preprocessor to handle accounts that fail validation.
Field | Description |
---|---|
Account |
If you select this option, the preprocessor replaces the invalid account with the project or non-project account entered in the Replacement Values group box. Only the account is replaced; the remaining information on the row is subjected to normal validation procedures. Costpoint verifies that a project and a non-project account were entered in the Replacement Values group box. |
Account/Org |
If you select this option, the preprocessor replaces 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. Costpoint verifies that an account and an organization were entered in the Replacement Values group box 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. If you select this option, you must also set the other validation methods (except PLC) to Proj/Acct/Org. Only the account/organization is replaced if it is a non-project account. When you save your selections, Costpoint verifies that a project account, non-project account, organization, and project were entered in the Replacement Values group box. It also validates that these items have been appropriately linked. |
No Substitution |
If you select this option, the preprocessor selects those records that fail validation because of an account and writes them to the error file without uploading them. Costpoint checks to see whether a project or non-project account was entered in the Replacement Values group box but does not delete the account(s). However, any project or non-project account entered there is not used in suspense processing. |
If Org fails replace
Field | Description |
---|---|
Org |
If you select this option, the preprocessor replaces the invalid organization with the organization entered in the Replacement Values group box. Only the organization is replaced; the remaining information on the row is subjected to normal validation procedures. Costpoint verifies that an organization was entered in the Replacement Values group box. |
Account/Organization |
Select this option to replace both the account and the organization when 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. Costpoint verifies that an account and organization were entered in the Replacement Values group box and that they are linked in the Org Account table. |
Project/Account/Organiation |
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 set the other validation methods (except PLC) to Proj/Acct/Org. When you save your selections, Costpoint verifies that a project account, non-project account, organization, and project were entered in the Replacement Values group box. It also validates that these items have been appropriately linked. |
No Substitution |
If you select this option, the preprocessor selects those records that fail validation because of an organization and writes them to the error file without uploading them. Costpoint also checks to see whether an organization was entered in the Replacement Values group box but does not delete the organization. However, any organization entered there is not used in suspense processing. |
If Project fails replace
Field | Description |
---|---|
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 information on the row is subjected to normal validation procedures. Costpoint verifies that a project was entered in the Replacement Values group box. |
Project/Account/Organization |
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, Costpoint verifies that a project account, non-project account, organization, and project were entered in the Replacement Values group box. |
No Substitution |
If you select this option, the preprocessor selects those records that fail validation because of a project and writes them to the error file without uploading them. Costpoint checks to see whether a project was entered in the Replacement Values group box but does not delete the project. However, any project entered there is not used in suspense processing. |
If PLC fails replace
Field | Description |
---|---|
PLC |
Select this option to replace the invalid PLC with the PLC entered in the Replacement Values group box. Only the PLC is replaced; the remaining information on the row will be subjected to normal validation procedures. Costpoint verifies that a PLC was entered in the Replacement Values group box. |
PLC/Project |
Select this option to replace the PLC and the project if the PLC fails validation. Costpoint checks the Project Labor Category table to see whether the PLC/Project is valid. Costpoint also checks the Replacement Values group box to see whether a replacement project and PLC have been provided. |
PLC then Project |
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. Costpoint also verifies that the project and PLC are in the Project Labor Category table. |
No Substitution |
If you select this option, the preprocessor selects those records that fail validation because of a PLC and writes them to the error file without uploading them. Costpoint checks to see whether a PLC was entered in the Replacement Values group box but does not delete the PLC. However, if you select this method, any PLC entered there will not be used in suspense processing. |
If Acct/Org Combination fails replace
Field | Description |
---|---|
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 is replaced; the remaining information on the row will be subjected to normal validation procedures. Costpoint verifies that a project and a non-project account were entered in the Replacement Values group box. |
Organization |
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 information on the row will be subjected to normal validation procedures. Costpoint verifies that an organization was entered in the Replacement Values group box. |
Account then Organization |
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. Costpoint also verifies that the accounts and organizations have been properly linked in the Org Account table. |
Project/Account/Organization |
If you select this option, the preprocessor replaces the project/account/organization when the 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, Costpoint verifies that a project account, non-project account, organization, and project were entered in the Replacement Values group box. |
Organization then Account |
Select this option to replace the organization with the suspense organization. If this new combination fails validation, the preprocessor also replaces the account. Costpoint verifies that the accounts and organizations are properly 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. Costpoint checks to see whether an account/organization combination was entered in the Replacement Values group box but does not delete the information. However, if you select this method, any account or organization entered there will not be used in suspense processing. |
If Proj/Acct/Org Combination fails replace
Field | Description |
---|---|
Account |
If you select this option, the preprocessor replaces 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 information on the row will be subjected to normal validation procedures. Costpoint verifies that a project and a non-project account were entered in the Replacement Values group box. |
Organization |
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 information on the row will be subjected to normal validation procedures. Costpoint verifies that an organization was entered in the Replacement Values group box. |
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 group box. Only the project is replaced; the remaining information on the row will be subjected to normal validation procedures. Costpoint verifies that a project was entered in the Replacement Values group box. |
Account/Organization |
If you select this option, the preprocessor replaces both the account and organization if the account/organization combination fails any validations. If you select this option, you most also set the other validation methods (except Project and PLC) to Account/Org. Costpoint verifies that a project account, a non-project account, and an organization were entered in the Replacement Values group box, and that they are linked in the Org Account table. |
Project/Account/Organization |
Select this option to replace the project/account/organization if the 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, Costpoint verifies that a project account, non-project account, organization, and project were entered in the Replacement Values group box. |
Account/Organization 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. Costpoint verifies that a project account, a non-project account, an organization, and a project were provided in the Replacement Values group box. |
Account then Organization 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. Costpoint verifies that a project account, a non-project account, an organization, and a project were entered in the Replacement Values group box. |
Organization then Account then Project |
Select this option to replace the organization. If that fails validation, the preprocessor replaces the account and project. Costpoint verifies that a project account, a non-project account, an org, and a project were entered in the Replacement Values group box. |
Account then Project |
If you select this option, the preprocessor replaces the account first. If the new combination fails validation, it replaces the project. The application verifies that a project account, a non-project account, and a project were entered in the Replacement Values group box. |
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. Costpoint checks to see whether a project account, non-project account, organization, and project were 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 will not be deleted. |
Replacement Values
Use this group box to designate values that the preprocessor will use to replace invalid data.
Field | Description |
---|---|
Project |
Enter, or click to select, a valid project ID that will be used by the preprocessor to replace an invalid project ID. The project ID entered must exist in the Project table. |
Project Required Account |
Enter, or click to select, a valid project account ID that will be used by the preprocessor to replace an invalid project account ID. The project account ID must exist in the Account table. |
Non-project Required Account |
Enter, or click to select, a valid non-project account ID that will be used by the preprocessor to replace an invalid non-project account ID. The non-project account ID must exist in the Account table. |
Organization |
Enter, or click to select, a valid organization ID that will be used by the preprocessor to replace an invalid organization ID. The organization ID must exist in the Org table. |
Ref 1, Ref 2 |
Enter, or click to select, valid reference number IDs for reference 1 and/or reference 2. The preprocessor will use these IDs to replace any invalid reference number IDs. The reference number IDs must exist in the Reference Structure table. |
PLC |
Enter, or click to select, a valid PLC code (Project Labor Category) that will be used by the preprocessor to replace an invalid PLC code. The PLC code must exist in the Billable Labor Category table. |
GLC |
Enter, or click to select, a valid GLC code (General Labor Category) that will be used by the preprocessor to replace an invalid GLC code. The GLC code must exist in the General Labor Category table. |
Save |
After you make your selections, save the settings. Costpoint will use your selections to replace invalid charging information when you run the preprocessor. |