Error and Warning Messages
The following sections contain information on errors or warnings you encounter when you import vendors.
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. |
Warning Messages
The following table lists warning messages that may display on the screen. The import process continues even if these warning messages display.
Warning | Description |
---|---|
Non-US Bank ID (NON_US_BANK_ID) is missing for this Non-US EFT record. Non-US Bank ID is required when creating outgoing IAT Files for EFT payments. | The Non-US EFT Active flag is set to Y, but the Non-US Bank ID is blank |
ACH Code (S_ACH_TRN_CD) is missing for this Non-US EFT record. ACH is required when creating outgoing IAT Files for EFT payments. | The Non-US EFT Active flag is set to Y, but the ACH Code is blank. |
Warning: Bank ABA Number and Bank Account 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 flag is set to Y, but the Bank ID (ABA No.) and Bank Account fields are not blank. |