Costpoint Online Help

Using the Help Search

Error Messages

The following sections contain information on errors encountered by the Import Vendors preprocessor.

Report Error Messages

The following table lists errors that may appear on the Error Report. If an error is encountered in the input record, it causes the rejection of the record containing the error.

Item	Error	Description
1099 Type	Not found in 1099 Box Type table	The 1099 type in the input file does not exist in the 1099 Box Type table.
Employee	Not found in Employee table	The Employee ID in the input file does not exist in the Employee table.
Order Country	Not found in Mail State table	The country in the order address section of the input file does not exist in the Mail State table.
Order State	Not found in Mail State table	The state in the order address section of the input file does not exist in the Mail State table.
Payment Country	Not found in the Mail State table	The country in the payment address section of the input file does not exist in the Mail State table.
Payment State	Not found in the Mail State table	The state in the payment address section of the input file does not exist in the Mail State table.
Terms	Must be in Input File	The terms must be included in the input file.
Terms	Not found in Vendor Terms table	The terms in the input file does not exist in the Vendor Terms table.
Vendor	Duplicates found in Input File	A particular vendor ID was found more than once in the input file. An individual vendor must occur only once in the input file.
Vendor	Must be in Input File	The vendor ID must be included in the input file.
Vendor Name	Must be in Input File	The vendor name must be included in the input file.
Intermediary Bank ID	Not found in Manage Intermediary Banks	The Intermediary Bank is not found in the Intermediary Bank Account table.
EFT Active or NON-US EFT Active	Only one of the “EFT Active” flags (either US or Non-US) can be set to “Y”.	Both EFT Active (ACTIVE_FL) and Non-US EFT Active (NON_US_ACTIVE_FL) are set to Y in the input file.
Non-US EFT Active and Non-US Bank ID	Warning: Non-US Bank ID is missing for this Non-US EFT record. Data will still be imported.	The Non-US EFT Active (NON_US_ACTIVE_FL) field is set to Y, but the Non-US Bank ID (NON_US_BANK_ID) is blank (null).
Non-US EFT Active, Bank ABA Number, Bank Account, and ACH Code	Warning: Bank ABA Number, Bank Account and ACH Code must be null for a Non-US EFT record. The record will be imported with those values set to NULL.	The Non-US EFT Active (NON_US_ACTIVE_FL) is set Y, but the Bank ABA Number (BANK_ABA_NO), Bank Account (BANK_ACCT_ID_S), or ACH Code (S_ACH_TRN_CD) are NOT set to null.
SM Subcontractor Flag	Must be Y or N.	This occurs when the Subcontractor Management (SM) license is ON and the SM Subcontractor Flag is not null and is neither Y or N.
SM Subcontractor Flag	Cannot be Y if Employee ID exists.	This occurs when: - SM license is ON and - SM Subcontractor Flag = Y and - Employee ID is not null (in VEND table or in input file/table)
Vendor Employee Approval Group Code	Must exist in input file.	This occurs when: - SM license is ON and - SM Subcontractor Flag = Y and - Vendor Employee Requires Approval = Y in AP_SETTINGS table and - Use Vendor Employee Approval Groups = Y in AP_SETTINGS table and - Vendor Employee Approval Group Code is null.
Vendor Employee Approval Group Code	Not found in VE_APVL_GRP table.	This happens when: - SM license is ON and - SM Subcontractor Flag = Y and - Vendor Employee Requires Approval = Y in AP_SETTINGS table and - Use Vendor Employee Approval Groups = Y in AP_SETTINGS table and - Vendor Employee Approval Group Code is not null and - Vendor EMployee Approval Group Code does not exist in VE_APVL_GRP table

Screen Error Messages

The following table lists error messages that may display on the screen.

Error	Description
An error has occurred while trying to access a table. Processing has stopped.	This error should not normally occur. Record the status of the processing meter and contact technical support for assistance.
Invalid A/P account description.	The Accounts Payable account description in the input file does not exist in the Default Accounts Payable Accounts table.
Invalid cash account description.	The cash account description in the input file does not exist in the Default Cash Accounts table.
The input file that you have entered does not exist. Press the Select button to search for available files.	Costpoint was unable to find the file specified in the File Name field. If the file is not in the current Windows directory, pre-pend the file name with the full directory path or use [Lookup] to search for available files.

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Error Messages

The following sections contain information on errors encountered by the Import Vendors preprocessor.

Report Error Messages

The following table lists errors that may appear on the Error Report. If an error is encountered in the input record, it causes the rejection of the record containing the error.

Item	Error	Description
1099 Type	Not found in 1099 Box Type table	The 1099 type in the input file does not exist in the 1099 Box Type table.
Employee	Not found in Employee table	The Employee ID in the input file does not exist in the Employee table.
Order Country	Not found in Mail State table	The country in the order address section of the input file does not exist in the Mail State table.
Order State	Not found in Mail State table	The state in the order address section of the input file does not exist in the Mail State table.
Payment Country	Not found in the Mail State table	The country in the payment address section of the input file does not exist in the Mail State table.
Payment State	Not found in the Mail State table	The state in the payment address section of the input file does not exist in the Mail State table.
Terms	Must be in Input File	The terms must be included in the input file.
Terms	Not found in Vendor Terms table	The terms in the input file does not exist in the Vendor Terms table.
Vendor	Duplicates found in Input File	A particular vendor ID was found more than once in the input file. An individual vendor must occur only once in the input file.
Vendor	Must be in Input File	The vendor ID must be included in the input file.
Vendor Name	Must be in Input File	The vendor name must be included in the input file.
Intermediary Bank ID	Not found in Manage Intermediary Banks	The Intermediary Bank is not found in the Intermediary Bank Account table.
EFT Active or NON-US EFT Active	Only one of the “EFT Active” flags (either US or Non-US) can be set to “Y”.	Both EFT Active (ACTIVE_FL) and Non-US EFT Active (NON_US_ACTIVE_FL) are set to Y in the input file.
Non-US EFT Active and Non-US Bank ID	Warning: Non-US Bank ID is missing for this Non-US EFT record. Data will still be imported.	The Non-US EFT Active (NON_US_ACTIVE_FL) field is set to Y, but the Non-US Bank ID (NON_US_BANK_ID) is blank (null).
Non-US EFT Active, Bank ABA Number, Bank Account, and ACH Code	Warning: Bank ABA Number, Bank Account and ACH Code must be null for a Non-US EFT record. The record will be imported with those values set to NULL.	The Non-US EFT Active (NON_US_ACTIVE_FL) is set Y, but the Bank ABA Number (BANK_ABA_NO), Bank Account (BANK_ACCT_ID_S), or ACH Code (S_ACH_TRN_CD) are NOT set to null.
SM Subcontractor Flag	Must be Y or N.	This occurs when the Subcontractor Management (SM) license is ON and the SM Subcontractor Flag is not null and is neither Y or N.
SM Subcontractor Flag	Cannot be Y if Employee ID exists.	This occurs when: - SM license is ON and - SM Subcontractor Flag = Y and - Employee ID is not null (in VEND table or in input file/table)
Vendor Employee Approval Group Code	Must exist in input file.	This occurs when: - SM license is ON and - SM Subcontractor Flag = Y and - Vendor Employee Requires Approval = Y in AP_SETTINGS table and - Use Vendor Employee Approval Groups = Y in AP_SETTINGS table and - Vendor Employee Approval Group Code is null.
Vendor Employee Approval Group Code	Not found in VE_APVL_GRP table.	This happens when: - SM license is ON and - SM Subcontractor Flag = Y and - Vendor Employee Requires Approval = Y in AP_SETTINGS table and - Use Vendor Employee Approval Groups = Y in AP_SETTINGS table and - Vendor Employee Approval Group Code is not null and - Vendor EMployee Approval Group Code does not exist in VE_APVL_GRP table

Screen Error Messages

The following table lists error messages that may display on the screen.

Error	Description
An error has occurred while trying to access a table. Processing has stopped.	This error should not normally occur. Record the status of the processing meter and contact technical support for assistance.
Invalid A/P account description.	The Accounts Payable account description in the input file does not exist in the Default Accounts Payable Accounts table.
Invalid cash account description.	The cash account description in the input file does not exist in the Default Cash Accounts table.
The input file that you have entered does not exist. Press the Select button to search for available files.	Costpoint was unable to find the file specified in the File Name field. If the file is not in the current Windows directory, pre-pend the file name with the full directory path or use [Lookup] to search for available files.