Costpoint Help

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 State

Not found in 1099 States table

The state in the 1099 State field does not exist in the System AP 1099 States table.

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.

Parent Topic:

Related Topics for the Import Vendors Screen