ERROR MESSAGES AND VALIDATION DETAIL

Error Messages

 

Table Name

Costpoint   Screen Name

Column Name

Costpoint  Field Name

Error Message(s)

Error Message Help

PROJ

Basic Info screen (Projects » Project Setup » Project Master)

USER_ID

 

User ID is required

Make sure that a user ID exists in the input file.

PROJ

Basic Info

USER_ID

 

User ID is invalid

Make sure that the user ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ

Basic Info

DFLT_PROJ_ID

 

Project ID is invalid

Make sure that the project ID exists in the Basic Info screen (Projects » Project Setup » Project Master).

PROJ

Basic Info

PROJ_ID

Project

Invalid Project ID, no further validation

Make sure that the project ID is in acceptable format.  The project ID should consist of whole numbers and/or letters separated by a period. Symbols and spaces are not allowed.

PROJ

Basic Info

PROJ_ID

Project

Top Level Project Length is Invalid

Make sure that the length of the top-level project is equal to the segment length defined for level one in the Project Settings screen (Projects » Project Setup » Controls).

PROJ

Basic Info

PROJ_ID

Project

Project Structure is Invalid

Make sure that the project levels have consistent segment lengths.  For example, a project has a top level identified as "1000," the first second level is identified as "1000.001," and the next second level project is identified as "1000.02."  This is invalid because the second level of the project must be equal in length.

PROJ

Basic Info

PROJ_ID

Project

Parent project does not exist

Make sure that all parent projects exist.

PROJ

Basic Info

PROJ_ID

Project

Project ID is required

Make sure that the project ID exists in the input file.

PROJ

Basic Info

PROJ_ID

Project

Project already exists

Make sure that the project ID does not already exist in the Basic Info screen (Projects » Project Setup » Project Master), or in the PROJ.CSV file.

PROJ

Basic Info

PROJ_TYPE_DC

Project Type

Project Type is required

If there is no default project assigned, the Project Type must exist in the input file.

PROJ

Basic Info

PROJ_TYPE_DC

Project Type

Proj Type is invalid

Make sure that the Project Type has been set up in the Maintain Project Types screen (Projects » Project Setup » Controls).

PROJ

Basic Info

PROJ_NAME

Name

Project Name is required

Make sure that the Project Name is in the input file.

PROJ

Basic Info

BILL_PROJ_FL

Billable Project

Billable Flag is invalid.

Make sure that the Billable Flag is Y or N.

PROJ

Basic Info

ORG_ID

Owning Organization

Owning Organization is required

The Owning Organization must exist in the input file if a default project is not assigned to the project.

PROJ

Basic Info

ORG_ID

Owning Organization

Owning Organization is invalid

Make sure that the Owning Organization has been set up in Define Org Structures screen (Accounting » General Ledger » Organizations) and Maintain Org Elements screen (Accounting » General Ledger » Organizations).

PROJ

Basic Info

CEIL_F_CST_ RBA_CD

Funding Info, Cost Ceiling Code

Ceiling Code is invalid.

Make sure that the Funded Cost Ceiling Code is valid.  Valid Ceiling Codes are R (Revenue), B (Billing), A (Both Revenue and Billing), and N (None).

PROJ

 

Basic Info

CEIL_F_FEE_ RBA_CD

Funding Info, Fee Ceiling Code

Ceiling Code is invalid.

Make sure that the Funded Fee Ceiling Code is valid.  Valid Ceiling Codes are R (Revenue), B (Billing), A (Both Revenue and Billing), and N (None).

PROJ

Basic Info

CEIL_F_TOT_ RBA_CD

Funding Info, Total Ceiling Code

Ceiling Code is invalid.

Make sure that the Funded Total Ceiling Code is valid.  Valid Ceiling Codes are R (Revenue), B (Billing), A (Both Revenue and Billing), and N (None).

PROJ

Basic Info

CEIL_V_CST_ RBA_CD

Value Info, Cost Ceiling Code

Ceiling Code is invalid.

Make sure that the Contract Value Cost Ceiling Code is valid.  Valid Ceiling Codes are R (Revenue), B (Billing), A (Both Revenue and Billing), and N (None).

 

 

 

PROJ

Basic Info

CEIL_V_FEE_ RBA_CD

Value Info, Fee Ceiling Code

Ceiling Code is invalid.

Make sure that the Contract Value Fee Ceiling Code is valid.  Valid Ceiling Codes are R (Revenue), B (Billing), A (Both Revenue and Billing), and N (None).

PROJ

Basic Info

CEIL_V_TOT_ RBA_CD

Value Info, Total Ceiling Code

Ceiling Code is invalid.

Make sure that the Contract Value Total Ceiling Code is valid.  Valid Ceiling Codes are R (Revenue), B (Billing), A (Both Revenue and Billing), and N (None).

PROJ

Basic Info

EMPL_ID

Project Manager (ID)

Project Manager is invalid

Make sure that the Employee ID has been set up in the Basic Employee Info screen (People » Employee » Basic » Employee Setup).

PROJ

Basic Info

CUST_ID

Customer

Customer is invalid.

Make sure that the Customer has been set up in the Maintain Customer screen (Accounting » Accounts Receivable » Customer Info).

PROJ

Basic Info

S_PROJ_RPT_ DC

Project Classification

Project Classification is required.

If there is no default project assigned, the Project Classification must exist in the PROJ.CSV file.

PROJ

Basic Info

S_PROJ_RPT_ DC

Project Classification

Project Classification is invalid.

Make sure that the Project Classification is valid.  Valid classifications are BID & PROPOSAL, COMMON INV, DIRECT PROJECT, INDIRECT, INTER-CO MULTI, INTER-COMPANY, IR&D, and WORK IN PROCESS.  These are predefined in Costpoint.

PROJ

Basic Info

PROJ_WORK_ FRC_FL

Project Work Force Required

Project Work Force Required Flag is invalid.

Make sure that the Project Work Force Required Flag is Y or N.

PROJ

Basic Info

ACCT_GRP_CD

Account Group

Project Account Group is required

If there is no default project assigned, the Project Account Group must exist in the PROJ.CSV file.

PROJ

Basic Info

ACCT_GRP_CD

Account Group

Project Account Group is invalid.

Make sure that the Project Account Group has been set up in the Project Account Groups screen (Projects » Project Setup » Controls).

PROJ

Basic Info

PROJ_ABBRV_ CD

Project Abbreviation

Project Abbreviation is already used for another project

Verify that the Project Abbreviation is unique.  Also, it cannot be assigned to another project in the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ

Basic Info

ACTIVE_FL

Active

Active Flag is invalid

Make sure that the Active Flag is Y or N.

PROJ

Basic Info

ACCT_GRP_FL

Account Group - Allow Edit

Account Group - Allow Edit is invalid

Make sure that the Account Group - Allow Edit flag is Y or N.

PROJ

Basic Info

PROJ_RPT_DC_FL

Project Classification - Allow Edit

Project Classification - Allow Edit is invalid

Make sure that the Project Classification - Allow Edit flag is Y or N.

PROJ

Basic Info

PROJ_TYPE_FL

Project Type - Allow Edit

Project Type - Allow Edit is invalid

Make sure that the Project Type - Allow Edit flag is Y or N.

PROJ

Basic Info

ORG_ID_FL

Owning Organization - Allow Edit

Owning Organization - Allow Edit is invalid

Make sure that the Owning Organization - Allow Edit flag is Y or N.

PROJ

Basic Info

EMPL_ID_FL

Project Manager - Allow Edit

Project Manager - Allow Edit is invalid

Make sure that the Project Manager - Allow Edit flag is Y or N.

PROJ

Basic Info

CUST_ID_FL

Customer - Allow Edit

Customer - Allow Edit is invalid

Make sure that the Customer - Allow Edit flag is Y or N.

PROJ

Basic Info

FUND_SRCE_FL

Funding Source - Allow Edit

Funding Source - Allow Edit is invalid

Make sure that the Funding Source - Allow Edit flag is Y or N.

PROJ

Basic Info

PRIME_CONTR_FL

Prime Contract No - Allow Edit

Prime Contract No - Allow Edit is invalid

Make sure that the Prime Contract No - Allow Edit flag is Y or N.

PROJ

Basic Info

SUB_CONTR_FL

Subcontractor No - Allow Edit

Subcontractor No - Allow Edit is invalid

Make sure that the Subcontractor No - Allow Edit flag is Y or N.

PROJ

Basic Info

PO_NO_FL

Purchase Order No - Allow Edit

Purchase Order No - Allow Edit is invalid

Make sure that the Purchase Order No - Allow Edit flag is Y or N.

PROJ

Basic Info

DMS_DPS_FL

DPAS Purchasing Rating - Allow Edit

DPAS Purchasing Rating - Allow Edit is invalid

Make sure that the DPAS Purchasing Rating - Allow Edit is Y or N.

PROJ

Basic Info

ICS_FL

Incurred Cost Submission Code - Allow Edit

Incurred Cost Submission Code - Allow Edit is invalid

Make sure that the Incurred Cost Submission Code - Allow Edit is Y or N.

PROJ

Basic Info

CONTR_ST_ MMDD_FL

Contract Year - Allow Edit

Contract Year - Allow Edit is invalid

Make sure that the Contract Year - Allow Edit is Y or N.

PROJ

Basic Info

COM_FL

Apply Cost of Money Rates - Allow Edit

Apply Cost of Money Rates - Allow Edit is invalid

Make sure that the Apply Cost of Money Rates - Allow Edit is Y or N.

PROJ

Basic Info

CAS_FL

CAS Covered

CAS Covered is invalid

Make sure that the CAS Covered is Y or N.

PROJ

Basic Info

EDIT_WORK_ FRC_FL

Project Work Force Required - Allow Edit

Project Work Force Required - Allow Edit is invalid

Make sure that the Project Work Force Required - Allow Edit is Y or N.

PROJ

Basic Info

DFLT_ORG_ ENTRY_FL

Default to Owning Org

Default to Owning Org Flag is invalid

Make sure that the Default to Owning Org flag is Y or N.

PROJ

Basic Info

DFLT_ORG_ ENTRY_FL

Default to Owning Org

Must be N when Allow Charging is set to N.

The default to Owning Org flag must be set to N if the Allow Charging Flag is set to N.

PROJ

Basic Info

TOP_LVL_WRK_FRC_FL

Use Top Level Work Force

Use Top Level Work Force Flag is invalid

Make sure that the Use Top Level Work Force flag is Y or N.

PROJ

Basic Info

ALLOW_ CHARGES_FL

Allow Charging

Allow Charging Flag is invalid

Make sure that the Allow Charging flag is Y or N.

PROJ

Basic Info

LIMIT_ORGS_ FL

Limit Orgs

Limit Orgs Flag is invalid

Make sure that the Limit Orgs flag is Y or N.

PROJ

Basic Info

LIMIT_ORGS_ FL

Limit Orgs

Limit Orgs Flag must be N when Validating by Orgs is turned off

You cannot set this field to Y in the input file if the Validate Project Charging by Organizations check box is cleared in the Project Settings screen (Projects » Project Setup » Controls).

PROJ

Basic Info

LIMIT_ORGS_ FL

Limit Orgs

Must be N when Allow Charging is set to N.

Limit Orgs must be set to N if the Allow Charging Flag is set to N.

PROJ

Basic Info

LIMIT_ACCTS_FL

Limit Accounts

Limit Accounts Flag is invalid

Make sure that the Limit Accounts flag is Y or N.

PROJ

Basic Info

LIMIT_ACCTS_FL

Limit Accounts

'Must be 'N' when Allow Charging is set to 'N'

Limit Accounts must be set to N if the Allow Charging Flag is set to N.

PROJ

Basic Info

LIMIT_AO_FL

Limit which orgs can charge specific Accts

Limit which orgs can charge specific Accts Flag is invalid

Make sure that the Limit which orgs can charge specific Accts flag is Y or N.

PROJ

Basic Info

LIMIT_AO_FL

Limit which orgs can charge specific Accts

Limit which orgs can charge specific Accts Flag is invalid

Limit Which Orgs can Charge Specific Acct's Flag can be set to Y only if both the Limit Accounts Flag and the Limit Orgs Flag are set to N.

PROJ

Basic Info

LIMIT_AO_FL

Limit which orgs can charge specific Accts

Must be N when Allow Charging is set to N.

Limit which orgs can charge specific Accts must be set to N if the Allow Charging Flag is set to N.

PROJ

Basic Info

COM_APPLIC_ FL

Apply Cost of Money Rates

Apply Cost of Money Rates flag is invalid

Make sure that the Apply Cost of Money Rates Flag is Y or N.

PROJ

Basic Info

PURGED_FL

 

Purged Flag is invalid

Make sure that the Purged Flag is Y or N.

PROJ

Basic Info

MAIL_STATE_ DC

State/Province

State/Province is invalid.

Make sure that the State/PrMaintain States and Provinces screen (Others » System Administration » System Codes).

PROJ

Basic Info

POSTAL_CD

Zip Code

Postal Code is invalid.

Make sure that the Postal Code has been set up in the Maintain Postal Codes screen (Others » System Administration » System Codes).

PROJ

Basic Info

COUNTRY_CD

Country

The Country Code is invalid

Make sure that the Country Code has been set up in the Maintain States and Provinces screen (Others » System Administration » System Codes).

PROJ

Basic Info

COUNTRY_CD

Country

Country Code is Required

Verify that a valid Country Code exists.  A Country Code is required if a State Code is assigned.

PROJ

Basic Info

COUNTRY_CD

Country

Country Code/State Code combination is invalid

Verify that a valid Country Code/State Code combination exists in the Maintain States and Provinces screen (Others » System Administration » System Codes).

PROJ

Basic Info

LW_DOC_CD

Lien Waiver Doc Code

The Lien Waiver Document Code is invalid

Make sure that the Waiver Doc Code is set up in the Maintain Lien Waiver Document Names screen (Accounting » Accounts Payable » Lien Waiver Processing & Information).

PROJ

Basic Info

TC_PROJ_FL

Export Project

Export Project Classification is required

Export Project Classification must be T, E, B, or N.

PROJ

Basic Info

TC_PROJ_FL

Export Project

Export Project Flag must be ‘T’, ‘E’, ‘B’, or ‘N’

Make sure that the Export Project Flag is set to T, E, B, or N.

 

PROJ

Basic Info

COBRA_WBS

Cobra Mapping Value

The Cobra Mapping Value exceeds the maximum number of characters allowed

Make sure that the Cobra Mapping Value in the input file does not have more than 59 characters.

PROJ

Basic Info

COBRA_FL

Cobra Project Flag

The Cobra Project Flag must be 'Y' or 'N'

Make sure that the Cobra Project Flag is set to Y or N in the input file.

PROJ

Basic Info

COBRA_FL

Cobra Project Flag

The Cobra Project Flag is required

Verify that there is a value for the Cobra Project Flag in the input file. The value must be Y or N.

PROJ_MOD

Modifications screen (Projects » Project Setup » Controls)

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_MOD

Modifications

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen or the PROJ.CSV file.

PROJ_MOD

Modifications

PROJ_END_DT

Period of Performance End Date

The End Date must be greater than the Start Date

Verify that the End Date is after the Start Date.

PROJ_MOD

Modifications

PROJ_V_CST_ AMT

Value Modifications - Cost

Contract Value Cost is required

Verify that an amount exists for the Contract Value Cost.

PROJ_MOD

Modifications

PROJ_V_FEE_ AMT

Value Modifications - Fee %

Contract Value Fee is required

Verify that an amount exists for the Contract Value Fee.

PROJ_MOD

Modifications

PROJ_F_CST_ AMT

Funding Modifications - Cost

Funded Value Cost is required

Verify that an amount exists for the Funded Value Cost.

PROJ_MOD

Modifications

PROJ_F_FEE_ AMT

Funding Modifications - Fee %

Funded Value Fee is required

Verify that an amount exists for the Funded Value Fee.

PROJ_MOD

Modifications

PROJ_MOD_ID

ID

Modification ID already exists for this project.

Verify that a Modification ID does not already exist for this project in the Modifications screen (Projects » Project Setup » Controls) or elsewhere in the PROJ_MOD.CSV file.

PROJ_MOD

Modifications

DELIV_UNITS_QTY

Number of Units to Deliver

Number of Units to Deliver is required

Number of Units to Deliver is required.  Enter zero if there are no units to deliver for this modification.

PROJ_MOD

Modifications

EST_UNIT_CST_AMT

Estimated Cost Per Unit

Estimated Cost per Unit is required

Estimated Cost per Unit is required.  Enter zero if there is no estimated cost per unit for this modification.

PROJ_MOD

Modifications

UNIT_PRICE_ AMT

Price Per Unit

Price per Unit is required

Price per Unit is required.  Enter zero if there is no price per unit for this modification.

PROJ_MOD

Modifications

UNIT_PRICE_ AMT

Price Per Unit

The Price per Unit cannot be negative

Verify that the Price per Unit is a positive number.

PROJ_MOD

Modifications

CLIN_ID

CLIN

CLIN ID is invalid.

Verify that the CLIN ID has been set up for this project in the CLIN Information screen (Projects » Project Setup » Unit Pricing).

PROJ_MOD

Modifications

EFFECT_DT

Effective Date

Effective Date is Required

The Effective Date must exist in the input file or the Default Project.

PROJ_REV_ SETUP

Basic Revenue Info screen (Projects » Project Setup » Revenue Setup)

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_REV_ SETUP

Basic Revenue Info

DFLT_PROJ_ID

 

Project ID is invalid

Make sure that the Default Project ID exists in the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup).

PROJ_REV_ SETUP

Basic Revenue Info

PROJ_ID

Project

Project ID is invalid

Make sure that the Project ID exists in either the Basic Info screen or the PROJ.CSV file.

PROJ_REV_ SETUP

Basic Revenue Info

PROJ_ID

Project

Revenue is already set up for this project at this or another level.

Verify that the Project ID does not already exist at any level in the Basic Info screen (Projects » Project Setup » Project Master).

PROJ_REV_ SETUP

Basic Revenue Info

PROJ_ID

Project

Only Billable Projects may have Revenue Setup

Verify that the Billable Project flag for this project is selected in the Basic Info screen (Projects » Project Setup » Project Master), or is set to Y in the PROJ.CSV file.

PROJ_REV_ SETUP

Basic Revenue Info

S_REV_ FORMULA_CD

Revenue Formula

Revenue Formula is not valid

Verify that the Revenue Formula Code is Valid.  (See the "Revenue Formula Validation Detail" section.)

PROJ_REV_ SETUP

Basic Revenue Info

AT_RISK_FL

Allow Revenue to Exceed Contract Value

At Risk Flag is invalid

Verify that the At Risk Flag is Y or N.

PROJ_REV_ SETUP

Basic Revenue Info

AT_RISK_AMT

By How Much?

At Risk amount must be zero if At Risk Flag is set to N.

At Risk amount must be zero if At Risk Flag is set to N.

PROJ_REV_ SETUP

Basic Revenue Info

REV_CALC_ AMT

(The name changes depending on the revenue formula.  See the "Revenue Formula Validation Detail" section.)

Calc Amt must be zero for this Revenue Formula

Verify that the Calc Amount is appropriate for the Revenue Formula assigned to this project (See the "Revenue Formula Validation Detail" section.)

PROJ_REV_ SETUP

Basic Revenue Info

REV_TO_OWN_ORG_FL

Post Revenue to the Owning or Performing Organization

Owning or Performing Org Flag is invalid

Make sure that the Post Revenue to Owning or Performing Organization Flag is valid.  Valid entries are O (Owing) and P (Performing).

PROJ_REV_ SETUP

Basic Revenue Info

UNITS_FL

Calculate Revenue on Units

Units Flag must be N for this Revenue Formula

Verify that the Calculate Revenue on Units Flag is valid for the Revenue Formula assigned.  (See the "Revenue Formula Validation Detail" section.)

PROJ_REV_ SETUP

Basic Revenue Info

REV_CALC1_ AMT

(The name changes based on the revenue formula.  See the "Revenue Formula Validation Detail" section.)

Calc1 Amt must be zero for this Revenue Formula

Verify that the Calc1 Amount is appropriate for the Revenue Formula assigned to this project. (See the "Revenue Formula Validation Detail" section.)

PROJ_REV_ SETUP

Basic Revenue Info

REV_CALC2_ AMT

(The name changes based on the revenue formula.  See the "Revenue Formula Validation Detail" section.)

Calc2 Amt must be zero for this Revenue Formula

Verify that the Calc2 Amount is appropriate for the Revenue Formula assigned to this project. (See the "Revenue Formula Validation Detail" section.)

PROJ_REV_ SETUP

Basic Revenue Info

DISC_TYPE_CD

Discount Method

Billing Discount code is invalid. 

Make sure that the Billing Discount Method is NONE, PLC, ACCT, CUST, or PROJ.

PROJ_BILL_ INFO

Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup)

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_BILL_ INFO

Project Billing Info

DFLT_PROJ_ID

 

Project ID does not exist

Make sure that the Default Project ID exists in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

PROJ_BILL_ INFO

Project Billing Info

INVC_PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_BILL_ INFO

Project Billing Info

INVC_PROJ_ID

Project

Project does not exist in the PROJ_CUST_SETUP.CSV file.

At least one customer must be identified for every new project added to the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). Verify that this project exists at least once in the PROJ_CUST_SETUP.CSV file.

PROJ_BILL_ INFO

Project Billing Info

INVC_PROJ_ID

Project

Invoice Project already exists

Make sure that the Invoice Project does not already exist in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) or in the PROJ_BILL_INFO.CSV file.

PROJ_BILL_ INFO

Project Billing Info

INVC_PROJ_ID

Project

This Project is not Billable

Verify that the Billable Project check box is selected for this project in the Basic Info screen (Projects » Project Setup » Project Master), or is set to Y in the PROJ.CSV file.

PROJ_BILL_ INFO

Project Billing Info

INVC_PROJ_ID

Project

Billing is already setup at another level of the project

Verify that the Invoice Project has not already been set up at another level of the project.

PROJ_BILL_ INFO

Project Billing Info

S_BILL_ FORMULA_CD

Formula

Billing Formula is not Valid

Verify that the Billing Formula Code is valid. (See the "Billing Formula Validation Detail" section.)

PROJ_BILL_ INFO

Project Billing Info

S_BILL_ FORMULA_CD

Formula

Billing formula must be "1443"

Verify that the Billing Formula is consistent with the format. If the format is for "1443," the formula must be 1443.

PROJ_BILL_ INFO

Project Billing Info

BILL_CALC_ AMT

(The name changes depending on the billing formula.  See the "Billing Formula Validation Detail" section.)

Calc Amt must be zero for this Billing Formula

Verify that the Calc Amount is appropriate for the Billing Formula assigned to this project. (See the "Billing Formula Validation Detail" section.)

PROJ_BILL_ INFO

Project Billing Info

CASH_BASIS_ FL

Bill Cost Incurred on Cash Basis

Cash Basis Flag is invalid

Make sure that the Cash Basis Flag is Y or N.

PROJ_BILL_ INFO

Project Billing Info

S_RTNGE_ BASIS_CD

Retainage - Basis for Calculation

Retainage Basis is invalid

Verify that the Basis for Retainage is TOT, FEE, or HRS.

PROJ_BILL_ INFO

Project Billing Info

RTNGE_PCT_RT

Retainage - Percentage

Retainage Percent is required

Verify that a Retainage Percent exists in the input file.

PROJ_BILL_ INFO

Project Billing Info

CUST_TERMS_KEY

 

Customer Terms Key is invalid

Verify that the Customer Terms Key exists in the CUST_TERMS table. To view valid Customer Terms Keys and their descriptions, execute the following script in SQLTALK:

SELECT CUST_TERMS_KEY, CUST_TERMS_DC FROM CUST_TERMS;

PROJ_BILL_ INFO

Project Billing Info

INCM_STATE_ CD

Income State

Income State is invalid

Verify that the Income State Code exists in the STATE table.  The State Codes are predefined and cannot be changed. To view valid Income State Codes and their descriptions, execute the following script in SQLTALK:

SELECT STATE_CD, STATE_NAME FROM STATE;

PROJ_BILL_ INFO

Project Billing Info

BILL_CYCLE_ CD

Billing Cycle

The Billing Cycle is Required

This field is required if the Use Billing Cycles check box is selected in the Billing Settings screen (Projects » Billing » Controls). Verify that a valid Billing Cycle exists in the input file or the default project.

PROJ_BILL_ INFO

Project Billing Info

BILL_CYCLE_ CD

Billing Cycle

Billing Cycle is invalid

Make sure that the Billing Cycle has been set up in the Billing Cycle screen (Projects » Billing » Controls).

PROJ_BILL_ INFO

Project Billing Info

BILL_GRP_CD

Billing User Group

The User Group is Required

This field is required if the Assign Bills to User Groups check box is selected in the Billing Settings screen (Projects » Billing » Controls). Verify that a valid Billing User Group exists in the input file or the default project.

PROJ_BILL_ INFO

Project Billing Info

BILL_GRP_CD

Billing User Group

Billing User Group is invalid

Make sure that the Billing User Group has been set up in the Billing User Groups screen (Projects » Billing » Controls).

PROJ_BILL_ INFO

Project Billing Info

BILL_FRMT_CD

Generic Billing Format

Generic Format Code is required

A Generic Format Code is required when the Generic Billing Format Type is Generic.

PROJ_BILL_ INFO

Project Billing Info

BILL_FRMT_CD

Generic Billing Format

Billing Format Code is invalid

Verify that the Billing Format has been set up in the Generic Billing Formats screen (Projects » Billing » Formats).

PROJ_BILL_ INFO

Project Billing Info

BILL_FRMT_CD

Generic Billing Format

Generic Format Code is not allowed.

A Generic Format Code is allowed only when the Generic Billing Format Type is "Generic."

PROJ_BILL_ INFO

Project Billing Info

SPPRT_SCH_ FRMT_CD

Supporting Schedule Format

Supporting Schedule does not exist

Verify that the Billing Supporting Schedule has been set up in the Supporting Schedule Formats screen (Projects » Billing » Formats).

PROJ_BILL_ INFO

Project Billing Info

PARTL_BILL_ TRN_FL

Allow Transactions To Be Partially Billed

Allow Transactions to be Partially Billed Flag is invalid

Verify that the Allow Transactions to be Partially Billed flag is Y or N.

PROJ_BILL_ INFO

Project Billing Info

S_WHEN_ RETAIN_CD

Retainage - Withhold On

Retainage - Withhold On basis is required

If the Retainage - Basis for Calculation exists, then the Withhold On basis must exist.  Valid values are EACH, FINAL (Final Based on Contract Value), and FINALF (Final Based on Funded Value).

PROJ_BILL_ INFO

Project Billing Info

ALLOW_USER_EDIT_FL

Allow User to Edit Bills

Allow User to Edit Bills Flag is invalid

Verify that the Allow User to Edit Bills Flag is Y or N.

PROJ_BILL_ INFO

Project Billing Info

S_1035_TYPE

Government 1035 Format Information - Print Cost Plus/Fixed Price Format or Print Using T&M Format

Format Type is Required

If the Billing Format is 1035, the Format Type is required.  Valid entries are CP (Print Cost Plus or Fixed Price Format) and TM (Print Using T&M Format).

PROJ_BILL_ INFO

Project Billing Info

ACCT_LVL_ 1035_NO

Roll Up Accounts to Level

Rollup Account Level Number is Required

If the Billing Format is 1035, you must identify to which level number you want to roll up the accounts.  Valid level numbers are 1 to 8.

PROJ_BILL_ INFO

Project Billing Info

S_BILL_FRMT_TYPE

Format

Format Type does not exist

Make sure that the Billing Format Type is valid.  Valid entries are 1035 (Govt 1035), GENRIC (Generic) and 1443 (Govt 1443).

PROJ_BILL_ INFO

Project Billing Info

BILL_RMT_ ADDR_CD

Remittance Address

Remittance Address Code does not exist

Verify that the Remittance Address has been set up in the Remittance Addresses screen (Projects » Billing » Controls).

PROJ_BILL_ INFO

Project Billing Info

BILL_PMT_ ADDR_CD

Payment Office

Payment Office Code does not exist

Verify that the Remittance Address has been set up in the Govt. Payment Offices screen (Projects » Billing » Controls).

PROJ_BILL_ INFO

Project Billing Info

S_INVT_BILL_ CD

Bill Inventory Issues As (Cost, Units, Accounts)

Bill Inventory Code is not valid

Verify that the Bill Inventory Code is valid.  Valid entries are C (Cost), U (Units), and A (Account).

PROJ_BILL_ INFO

Project Billing Info

PRICE_CATLG_CD

Catalog

Price Catalog does not exist

Verify that the Price Catalog has been set up in the Set Up Price Catalogs screen (Materials » Product Definition » Product Billing).

PROJ_BILL_ INFO

Project Billing Info

PRICE_CATLG_CD

Catalog

Catalog is not allowed

Catalog is allowed only if Billing Inventory Issues is set to Units or Account in the Other Info subtask.

PROJ_BILL_ INFO

Project Billing Info

CLIN_ID

CLIN

CLIN or Catalog Code is Required

When Billing Inventory Issues is A (Account) or U (Unit), a Price Catalog or CLIN is required.

PROJ_BILL_ INFO

Project Billing Info

CLIN_ID

CLIN

CLIN ID is not allowed

CLIN ID is allowed only if Billing Inventory Issues is set to U (Units) or A (Account).

PROJ_BILL_ INFO

Project Billing Info

CLIN_ID

CLIN

You may not enter both CLIN and Catalog

When Billing Inventory Issues is A (Account) or U (Unit), a Price Catalog or CLIN is required. You cannot enter a CLIN and a Catalog for the same project.

PROJ_BILL_ INFO

Project Billing Info

CLIN_ID

CLIN

CLIN ID does not exist

Verify that the CLIN ID has been set up in the CLIN Information screen (Projects » Project Setup » Unit Pricing).

PROJ_BILL_ INFO

Project Billing Info

PROGRESS_ PMT_RT

Rates - Progress Payment

Rate must be between 0 and 100%

Verify that the Progress Payment rate is between 0 and 100% in the 1443 Info subtask.

PROJ_BILL_ INFO

Project Billing Info

LIQUID_RT

Rates - Liquidation

Rate must be between 0 and 100%

Verify that the Liquidation rate is between 0 and 100% in the 1443 Info subtask.

PROJ_BILL_ INFO

Project Billing Info

S_CONTR_ PRICE_CD

Contract Info - Price Basis

Price Basis Code is not valid

Verify that the Price Basis Code is valid.  Valid entries are CC (Contract Cost), CV (Contract Value), FC (Funded Cost), FV (Funded Value), and O (Other).

PROJ_BILL_ INFO

Project Billing Info

CONTR_ OVRIDE_AMT

Other Amount

Not allowed for this Price Basis Code

Non-zero amounts are allowed only if the Price Basis Code is O (Other).

PROJ_BILL_ INFO

Project Billing Info

POP_FL

Limit Transactions to Period of Performance

Limit to Period of Performance Flag is invalid

Verify that the Limit Transactions to Period of Performance flag is Y or N.

PROJ_BILL_ INFO

Project Billing Info

CONTR_ADDR_CD

Contract Info - Address

Address does not exist

Make sure that the Address Code has been set up in the Contractor Addresses screen in Costpoint Billing.

PROJ_BILL_ INFO

Project Billing Info

PAY_WHEN_ PAID_FL

Pay When Paid

Pay when Paid Flag is invalid

Verify that the Pay When Paid flag is Y or N.

PROJ_BILL_ INFO

Project Billing Info

ALLOW_USER_ADJ_FL

Allow User to Adjust Transactions in Open Billing Detail

Allow User to Adj Open Bill Det'l Flag is invalid

Verify that the Allow Users to Adjust Transactions in Open Billing Detail flag is Y or N.

PROJ_BILL_ INFO

Project Billing Info

BILL_CALC1_ AMT

(The name changes depending on the billing formula. See the "Billing Formula Validation Detail" section.)

Calc Amt must be zero for this Billing Formula

Verify that the Calc Amount is appropriate for the Billing Formula assigned to this project (see the "Billing Formula Validation Detail" section.)

PROJ_BILL_ INFO

Project Billing Info

INCL_LAB_ MLTPLR_FL

Include Labor Multiplier in Billing Rate

Include Labor Multiplier in Bill Rate Flag is invalid

Verify that the Include Labor Multiplier in Billing Rate flag is Y or N.

PROJ_BILL_ INFO

Project Billing Info

INCL_LAB_ MLTPLR_FL

Include Labor Multiplier in Billing Rate

Include Labor Multiplier in Bill Rate Flag is invalid

Include Labor Multiplier flag is available only for Billing Formulas that use a multiplier.  Valid values are CIMR (Labor Cost times Multiplier Plus Non Labor times Multiplier - Hours) and RSMNLM (Rate Schedule times Multiplier plus Non Labor Cost times Multiplier).

PROJ_BILL_ INFO

Project Billing Info

S_CRNCY_CD

Billing Currency

Billing Currency Code does not exist

Verify that the Billing Currency Code has been set up in the Maintain Currencies screen (Accounting » Multicurrency » Currencies).

PROJ_BILL_ INFO

Project Billing Info

RT_GRP_ID

Rate Group

Required for this Billing Currency

This field is required if the Billing Currency does not match the Functional Currency.  Enter a valid Rate Group.  The Rate Group is valid if the Functional and Billing currencies have been set up in the Maintain Exchange Rate Groups screen (Accounting » Multicurrency » Exchange Rates).  The Functional Currency should be set up as the "Currency From" and the Billing Currency should be set up as the Currency To.

PROJ_BILL_ INFO

Project Billing Info

RT_GRP_ID

Rate Group

Must be NULL for this Billing Currency

This field must be NULL if the Billing Currency matches the Functional Currency

PROJ_BILL_ INFO

Project Billing Info

RT_GRP_ID

Rate Group

Rate Group is not valid

Verify that the Rate Group exists in the Maintain Exchange Rate Groups subtask with the Functional Currency as the "Currency From" and the Billing Currency as the Currency To.

PROJ_BILL_ INFO

Project Billing Info

FREEZE_RT_FL

Freeze Multicurrency Rate

Freeze Multicurrency Rate Flag is not valid

Verify that the Multicurrency Rate flag is set to Y or N and is valid. The Billing Currency can be set to Y only if the Billing Currency does not match the Functional Currency.

PROJ_BILL_ INFO

Project Billing Info

TRN_CRNCY_ FL

Use Transactional Currency Billing

Use Transactional Currency Billing Flag is invalid

Verify that the Use Transactional Currency Billing flag is set to Y or N and is valid.  Use Transactional Currency Billing can be selected or set to Y only if the Billing Currency does not match the Functional Currency and the Billing Formula is LLR (Loaded Labor Rate) or LLRCINL (Loaded Labor Rate Plus Cost Incurred on Non Labor - T&M).

PROJ_BILL_ INFO

Project Billing Info

DISC_TYPE_CD

Discount Method

Billing Discount code is invalid

Make sure that the Billing Discount Method is NONE, PLC, ACCT, CUST, or PROJ.

PROJ_BILL_ INFO

Project Billing Info

BILL_DISC_RT

Discount Percentage

Billing Discount Percentage Rate cannot be negative

Verify that the discount percentage is a positive number.

PROJ_BILL_ INFO

Project Billing Info

BILL_DISC_RT

Discount Percentage

The billing discount percentage is required if there is a default T&M project entered

 

PROJ_BILL_ INFO

Project Billing Info

BILL_DISC_RT

Discount Percentage

A billing discount can only be entered if the discount method is PLC Discount

Make sure that DISC_TYPE_CD = PLC.

PROJ_BILL_ INFO

Project Billing Info

DFLT_TM_PROJ_ID

T&M Project

The default T&M project can only be entered if the discount method is PLC Discounts

Make sure  the DISC_TYPE_CD = PLC.

PROJ_BILL_ INFO

Project Billing Info

DFLT_TM_PROJ_ID

T&M Project

The default T&M Project does not exist in the PROJ_LAB_CAT_RT_SC table

Make sure the project exists in the PROJ_LAB_CAT_RT_SC table.

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

PROJ_ID

Project

Project must exist in PROJ_BILL_ INFO.CSV

Verify that this project has been included in the PROJ_BILL_INFO.CSV file.

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

CUST_ID

Customer

Customer is required

Verify that a Customer exists in the PROJ_CUST_ SETUP.CSV file.

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

CUST_ID

Customer

Customer is invalid

Make sure that the Customer has been set up in the Maintain Customer screen (Accounting » Accounts Receivable » Customer Info).

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

CUST_ID

Customer

This Project/Customer already exists

Verify that this Customer exists only once for this project in the PROJ_CUST_ SETUP.CSV file.

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

ADDR_DC

Address Code

Address Code is required

Verify that an Address Code exists in the PROJ_CUST_ SETUP.CSV file.

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

ADDR_DC

Address Code

Address Code is invalid

Verify that the Address Code has been assigned to this Customer in the Maintain Customer screen (Accounting » Accounts Receivable » Customer Info) with the Bill Code set to Y (Yes) or D (Default).

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

PCT_CNTRB_RT

% of Project Responsibility

% of Project Responsibility is required

Verify that a value exists for the % of Project Responsibility.

PROJ_CUST _SETUP

Project Billing Info - Customers Subtask

PCT_CNTRB_RT

% of Project Responsibility

% of Project Responsibility must be greater than zero.

Make sure that the % of Project Responsibility equals 100% for this project.

PROJ_CUST_ SETUP

Project Billing Info - Customers Subtask

PCT_CNTRB_RT

% of Project Responsibility

% of Project Responsibility must total 100% for this project

Make sure that the % of Project Responsibility is greater than zero.

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs screen (Projects » Project Setup » Project Master)

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs

ORG_ID

Organization

The Account/Org Combination does not exist

Verify that the Account and Org are linked and Active in the Maintain Account/Org Links screen (Accounting » General Ledger » Accounts).

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs

ACCT_ID

Account

The Account/Org Combination does not exist

Verify that the Account and Org are linked and active in the Maintain Account/Org Links screen (Accounting » General Ledger » Accounts).

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs

ACCT_ID

Account

This Project/Account/Org already exists.

Make sure that the Project/Account/Org combination does not already exist in the Maintain Valid Project/Account/Orgs screen (Projects » Project Setup » Project Master), or in the PROJ_ORG_ ACCT.CSV file.

PROJ_ORG_ ACCT

 

ACCT_ID

Account

This Account is not part of the project's account group

Make sure that the account has been set up in the Project Account Group that has been assigned to the project.

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs

ACTIVE_FL

Active

Active Flag is invalid

Verify that the Active Flag is Y or N.

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs

REF_STRUC_1_ ID

REF 1

REF 1 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

PROJ_ORG_ ACCT

Maintain Valid Project/Account/Orgs

REF_STRUC_2_ ID

REF 2

REF 2 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

PROJ_GOVT_ CONTR

Government Contract Info

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_GOVT_ CONTR

Government Contract Info

DFLT_PROJ_ID

 

Project ID does not exist

Make sure that the Project ID exists in the Basic Info screen (Projects » Project Setup » Project Master).

PROJ_GOVT_ CONTR

Government Contract Info

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_GOVT_ CONTR

Government Contract Info

PROJ_ID

Project

Project already exists

Verify that the Project does not already exist in the Government Contract Info screen (Projects » Project Setup » Project Master), or in the PROJ_GOVT_CONTR.CSV file.

PROJ_GOVT_ CONTR

Government Contract Info

CST_ACCT_STD_FL

CAS Covered

CAS Covered Flag is invalid

Verify that the CAS Covered Flag is Y or N.

PROJ_GOVT_ CONTR

Government Contract Info

S_ICS_CD

Incurred Cost Submission Code

Incurred Cost Submission Code is required

Incurred Cost Submission Code is required if the Require Incurred Cost Submission Code for all Projects check box is selected in the Project Settings screen (Projects » Project Setup » Controls).

PROJ_GOVT_ CONTR

Government Contract Info

S_ICS_CD

Incurred Cost Submission Code

Incurred Cost Submission Code is invalid

Verify that the Incurred Cost Submission Code is in the S_ICS table.

PROJ_GOVT_ CONTR

Government Contract Info

WD_PLC_FL

Use PLC for Wage Determination

Use PLC for Wage Det. Flag is invalid

Verify that the Use PLC for Wage Determination Flag is Y or N.

PROJ_GOVT_ CONTR

Government Contract Info

WD_PLC_FL

Use PLC for Wage Determination

Use PLC for Wage Determination Flag may not be 'Y' if project level is not equal to 1

Use PLC for Wage Determination Flag cannot be Y if project level is not equal to 1.

PROJ_LAB_ CAT

Assign PLC to Projects

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_LAB_ CAT

Assign PLC to Projects

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_LAB_ CAT

Assign PLC to Projects

BILL_LAB_CAT_CD

PLC

PLC does not exist

Make sure that the PLC has been set up in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor).

PROJ_LAB_ CAT

Assign PLC to Projects

BILL_LAB_CAT_CD

PLC

Project/PLC already exists

Verify that this PLC is not already assigned to the Project in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor), or the PROJ_LAB_CAT.CSV file

PROJ_LAB_ CAT

Assign PLC to Projects

COBRA_RSRC

Cobra Mapping Value

The Cobra Mapping Value exceeds the maximum number of characters allowed

Make sure that the Cobra Mapping Value does not have more than 59 characters in the input file.

PROJ_EMPL

Project Employee Work Force

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_EMPL

Project Employee Work Force

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.  Note: Costpoint will use this information only if the Project Work Force Required check box is selected in the Basic Info screen, or is Y in the PROJ.CSV file. Also, the information will not be used if the Use Top Level Work Force check box is selected in the Basic Info screen or is Y in the PROJ.CSV file, and the Project ID is not a top-level project.

PROJ_EMPL

Project Employee Work Force

EMPL_ID

Employees

Employee does not exist

Make sure that the Employee ID has been set up in the Basic Employee Info screen (People » Employee » Basic » Employee Setup) and the Salary Info and History screen (People » Employee » Basic Employee Setup).

PROJ_EMPL

Project Employee Work Force

EMPL_ID

 

Employee is already assigned to the Project

Make sure that the Employee has not already been assigned to the Project in the Project Employee Work Force screen (Projects » Project Setup » Project Labor) or in the PROJ_EMPL.CSV file.

PROJ_EMPL

Project Employee Work Force

OT_AUTH_FL

Overtime Authorized for Employees

Overtime Authorized for Empl's Flag is invalid

Verify that the Overtime Authorized for Employees Flag is Y or N.

PROJ_EMPL

Project Employee Work Force

OT_AUTH_FL

Overtime Authorized for Employees

All Flags must be the same for this Project

All Employees Assigned to a Project Work Force must be either authorized for Overtime or Not Authorized for Overtime. You cannot have some Employees authorized for Overtime and others Not Authorized for Overtime on the same Project.

PROJ_VEND

Project Vendor Work Force

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the Database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_VEND

Project Vendor Work Force

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_VEND

Project Vendor Work Force

VEND_ID

Vendor

Vendor does not exist

Make sure that the Vendor has been set up in the Maintain Vendors screen (Accounting » Accounts Payable » Vendor Info).  Note: Costpoint will use this information only if the Project Work Force Required check box is selected in the Basic Info screen (Projects » Project Setup » Project Master), or is Y in the PROJ.CSV file.  Also, the information will not be used if the Use Top Level Work Force check box is selected in the Basic Info screen or is Y in the PROJ.CSV file, and the Project ID is not a top level.

PROJ_VEND

Project Vendor Work Force

VEND_ID

Vendor

Vendor is already assigned to the Project

Make sure that the Vendor has not already been assigned to the Project in the Project Vendor Work Force screen (Projects » Project Setup » Project Labor) or in the PROJ_VEND.CSV file.

PROJ_VEND_EMPL

Project Vendor Employee Work Force

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the Database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_VEND_EMPL

Project Vendor Employee Work Force

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_VEND_EMPL

Project Vendor Employee Work Force

VEND_ID

Vendor

Vendor does not exist

Make sure that the Vendor has been set up in the Maintain Vendors screen (Accounting » Accounts Payable » Vendor Info).  Note: Costpoint will use this information only if the Project Work Force Required check box is selected in the Basic Info screen (Projects » Project Setup » Project Master), or is Y in the PROJ.CSV file.  Also, the information will not be used if the Use Top Level Work Force check box is selected in the Basic Info screen or is Y in the PROJ.CSV file, and the Project ID is not a top level.

PROJ_VEND_EMPL

Project Vendor Employee Work Force

VEND_ID

Vendor

Vendor is already assigned to the Project

Make sure that the Vendor has not already been assigned to the Project in the Project Vendor Work Force screen (Projects » Project Setup » Project Labor) or in the PROJ_VEND.CSV file.

PROJ_VEND_EMPL

Project Vendor Employee Work Force

VEND_EMPL_ID

Vendor Employee

Vendor Employee does not exist

The Vendor Employee must exist in the Maintain Vendor Employees screen (Accounting » Accounts Payable » Vendor Info).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

PROJ_ID

Project

Project ID is not billable

Make sure that the Project ID exists in either the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) or the PROJ_BILL_INFO.CSV file.

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_SEND_ CAGE_CD

CAGE Code

CAGE Code does not exist

Make sure that the CAGE Code has been set up in the Maintain WAWF Billing Settings screen (Projects » Billing » Controls).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_INVC_ TYPE_CD

Invoice Type

Invoice Type code is not valid

Verify that the Invoice Type code is valid.  Valid entries are CV (Cost Voucher), SCV (Summary Cost Voucher), CI (Commercial Invoice), 2N1 (2N1), Combo (Combo), and PPR (Progress Payment).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_SRCE_ FILE_CD

File Source

File Source code is not valid

Verify that the File Source code is valid.  Valid entries are S (Standard Bills), P (Progress Payment Bills), and R (Project Product Bills).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_LAST_ INVC_FL

Final Invoice

Final Invoice flag is not valid

Verify that the Final Invoice flag is Y or N.

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_LAST_ SHIP_FL

Final Shipment

Final Shipment flag is  not valid

Verify that the Final Shipment flag is Y or N.

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_CERT_ FL

Construction Certificate, Certification, Certificate of Conformance

Construction Certificate, Certification, or Certificate of Conformance flag is  not valid

Verify that the Construction Certificate, Certification, or Certificate of Conformance flag is Y or N.

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_SUPPLY_SVC_CD

Type

Type code is not valid

Verify that the Type code is valid.  Valid entries are SPL (Supplies) and SVC (Services).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_ INSPECT_PT_ CD

Inspection Point

Inspection Point code is not valid

Verify that the Inspection Point code is valid.  Valid entries are S (Source), D (Destination), and T (Other).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_ACCEPT_PT_CD

Acceptance Point

Acceptance Point code is not valid

Verify that the Acceptance Point code is valid.  Valid entries are S (Source), D (Destination), and T (Other).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_FOB_CD

FOB

FOB code is not valid

Verify that the FOB code is valid.  Valid entries are S (Source), D (Destination), and T (Other).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_ARP_FL

Alternate Release Procedure

Alternate Release Procedure flag is not valid

Verify that the Alternate Release Procedure flag is Y or N.

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_DELIV_FL

Delivery On Invoice

Delivery On Invoice flag is not valid

Verify that the Delivery On Invoice flag is Y or N.

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_FMS_FL

FMS

FMS flag is not valid

Verify that the FMS flag is Y or N.

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_CLIN_ MAP_CD

CLIN Mapping Method

CLIN Mapping Code is not valid.

Verify that the CLIN Mapping Code is valid.  Valid entries are G (Generic Billing Format) or C (Default CLIN).

PROJ_WAWF_ INFO

Maintain Project WAWF Information

WAWF_DFLT_ CLIN_ID

Default CLIN

The Default CLIN is required.

If the WAWF_CLIN_MAP_CD = C, a CLIN must be entered.

PROJ_EMPL_ LAB_CAT

Assign PLC to Employee Work Force

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_EMPL_ LAB_CAT

Assign PLC to Employee Work Force

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_EMPL_ LAB_CAT

Assign PLC to Employee Work Force

EMPL_ID

Employee

Employee is not valid

Verify that the Employee is assigned to the Employee Work Force in the Project Employee Work Force screen (Projects » Project Setup » Project Labor), or the PROJ_EMPL.CSV file.

PROJ_EMPL_ LAB_CAT

Assign PLC to Employee Work Force

BILL_LAB_CAT_CD

PLC

PLC is not valid

Make sure that the PLC has been assigned to the Project in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor), or the PROJ_LAB_CAT.CSV file

PROJ_EMPL_ LAB_CAT

Assign PLC to Employee Work Force

BILL_LAB_CAT_CD

PLC

This Employee/PLC has already been assigned to this Project

Verify that the Project does not already have this Employee/PLC combination assigned in the Assign PLC to Employee Work Force screen in Costpoint Project Setup, or the PROJ_EMPL_LAB_ CAT.CSV file.

PROJ_EMPL_ LAB_CAT

Assign PLC to Employee Work Force

DFLT_FL

Defaults

A Default must be setup for each Employee

One PLC must have a Y for any given employee/project combination. PLCs with an N will not default, but will be available for when you are entering employee timesheets.

PROJ_VEND_ LAB_CAT

Assign PLC to Vendor Work Force (Projects » Project Setup » Project Labor)

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_VEND_ LAB_CAT

Assign PLC to Vendor Work Force

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_VEND_ LAB_CAT

Assign PLC to Vendor Work Force

VEND_ID

Vendor

Vendor is not valid

Verify that the Vendor is assigned to the Vendor Work Force in the Project Vendor Work Force screen (Projects » Project Setup » Project Labor), or the PROJ_VEND.CSV file.

PROJ_VEND_ LAB_CAT

Assign PLC to Vendor Work Force

BILL_LAB_CAT_CD

PLC

PLC is not valid

Make sure that the PLC has been assigned to the Project in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor), or the PROJ_LAB_CAT.CSV file.

PROJ_VEND_ LAB_CAT

Assign PLC to Vendor Work Force

BILL_LAB_CAT_CD

PLC

This Vendor/PLC has already been assigned to this Project

Verify that the Project does not already have this Vendor/PLC combination assigned in the Assign PLC to Vendor Work Force (Projects » Project Setup » Project Labor), or the PROJ_VEND_LAB_ CAT.CSV file.

PROJ_VEND_ LAB_CAT

Assign PLC to Vendor Work Force

DFLT_FL

Defaults

A Default must be setup for each Vendor

One PLC must have a Y for any given Vendor/Project combination.

BILL_LAB_ CAT

Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor)

BILL_LAB_CAT_CD

Lab Cat

PLC is required

Verify that a PLC exists in the BILL_LAB_CAT.CSV file.

BILL_LAB_ CAT

Set Up Project Labor Categories (PLC)

BILL_LAB_CAT_DESC

Description

Description is required

Verify that a PLC description exists in the BILL_LAB_CAT.CSV file.

PROJ_LAB_ CAT_MAP

Link GLC to PLC

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_LAB_ CAT_MAP

Link GLC to Project PLC

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_LAB_ CAT_MAP

Link GLC to Project PLC

GENL_LAB_ CAT_CD

GLC

GLC does not exist

Verify that the General Labor Category has been set up in the General Labor Categories screen (People » Labor » Labor Controls).

PROJ_LAB_ CAT_MAP

Link GLC to Project PLC

GENL_LAB_ CAT_CD

GLC

This Project/GLC already exists

Verify that the General Labor Category has been assigned only once for this project.

PROJ_LAB_ CAT_MAP

Link GLC to Project PLC

DF_BILL_LAB_CAT_CD

PLC

PLC is not valid

Make sure that the PLC has been assigned to the Project in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor), or the PROJ_LAB_CAT.CSV file.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

BILL_LAB_CAT_CD

PLC

PLC is not assigned to the Project

Make sure that the PLC has been assigned to the Project in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor), or the PROJ_LAB_CAT.CSV file.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

BILL_LAB_CAT_CD

PLC

PLC is not valid

Make sure that the PLC has been set up in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor) or the BILL_LAB_CAT.CSV file.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

BILL_RT_AMT

Rate

Must be zero when Rate Type is A (Actual) or "S" (Standard).

Verify that the Billing Rate is valid.  If the Rate Type is Actual or Standard, the Billing Rate must be zero.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

BILL_RT_AMT

Rate

Rate is required

Verify that a Bill Rate exists in the input file.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

S_BILL_RT_ TYPE_CD

Rate Type

Rate Type is Required

Make sure that the Rate Type exists.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

S_BILL_RT_ TYPE_CD

Rate Type

Rate Type is not Valid

Verify that the Rate Type is valid.  Valid Rate Types are A (Actual), B (Billing), C (Ceiling), S (Standard), and T (Transactional).

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

START_DT

Starting Date

Two rates have been specified for the same time frame

Verify that the PLC/Starting Date/Ending Date combination is valid.  You cannot have the same PLC/Project combination with overlapping Starting and Ending dates.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

START_DT

Starting Date

Invalid Start Date

Make sure that a Starting Date exists in the input file and that it is a valid date.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

END_DT

Ending Date

Two rates have been specified for the same time frame

Verify that the PLC/Starting Date/Ending Date combination is valid.  You cannot have the same PLC/Project combination with overlapping Starting and Ending dates.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

END_DT

Ending Date

Invalid End Date

Make sure that an Ending Date exists in the input file and that it is a valid date.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

BILL_DISC_RT

Discount Percentage

Billing Discount Percentage Rate cannot be negative.

 

Verify that the discount percentage is a positive number.

PROJ_LAB_ CAT_RT_SC

Project PLC Rates

BILL_DISC_RT

Discount Percentage

Billing Discount Percentage is required.

Verify that a percentage exists.  If the field is blank in the input file, the system will insert 0.00%.

PROJ_EMPL_ RT_SCH

Project PLC Rates by Employee/Vendor

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_EMPL_ RT_SCH

Project PLC Rates by Employee/Vendor

USER_ID

 

User ID is required

Make sure that a User ID exists in the input file.

PROJ_EMPL_ RT_SCH

Project PLC Rates by Employee/Vendor

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_EMPL_ RT_SCH

Project PLC Rates by Employee/Vendor

EMPL_ID

Employee

Employee does not exist in the Project Work Force

If the Project Work Force Required check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file, the Employee must be part of the work force for this Project in the Project Employee Work Force screen (Projects » Project Setup » Project Labor) or the PROJ_EMPL.CSV file.

PROJ_EMPL_ RT_SCH

Project PLC Rates by Employee/Vendor

S_BILL_RT_ TYPE_CD

Rate Type

Rate Type is Required

Make sure that the Rate Type exists.

PROJ_EMPL_ RT_SCH

Project PLC Rates by Employee/Vendor

BILL_DISC_RT

Discount Percentage

Billing Discount Percentage Rate cannot be negative.

 

Verify that the discount percentage is a positive number.

PROJ_EMPL_ RT_SCH

Project PLC Rates by Employee/Vendor

BILL_DISC_RT

Discount Percentage

Billing Discount Percentage is required.

Verify that a percentage exists.  If the field is blank in the input file, the system will insert 0.00%.

LAB_CAT_RT_SCH

Set Up Project Labor Categories (PLC) - Billing Rates Subtask

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

LAB_CAT_RT_SCH

Set Up Project Labor Categories (PLC) - Billing Rates Subtask

BILL_LAB_CAT_CD

Lab Cat

PLC already exists

Make sure that the Labor Category is set up only once in either the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor), or in the LAB_CAT_RT_SCH.CSV file.

LAB_CAT_RT_SCH

Set Up Project Labor Categories (PLC) - Billing Rates Subtask

END_DT

Ending Date

The End Date must be greater than the Start Date

Verify that the End Date is later than the Start Date.

LAB_CAT_RT_SCH

Set Up Project Labor Categories (PLC) - Billing Rates Subtask

BILL_DISC_RT

Discount Percentage

Billing Discount Percentage Rate cannot be negative.

Verify that the discount percentage is a positive number.

LAB_CAT_RT_SCH

Set Up Project Labor Categories (PLC) - Billing Rates Subtask

BILL_DISC_RT

Discount Percentage

Billing Discount Percentage is required. 

 

Verify that a percentage exists.  If the field is blank in the input file, the system will insert 0.00%.

TM_RT_ ORDER

Define Rate Sequence

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

TM_RT_ ORDER

Define Rate Sequence

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

TM_RT_ ORDER

Define Rate Sequence

S_BILL_RT_TBL_CD

Rate Table

Rate Table is not valid

Verify that the Rate Table is C (Setup Project Labor Categories), PC (Project PLC Rates), PEC (Project PLC Rates By Employee), or PVC (Project PLC Rates By Vendor).

TM_RT_ ORDER

Define Rate Sequence

SEQ_NO

Seq No

Sequence Number already exists

Make sure that the Sequence Number does not already exist for this Project.

TM_RT_ ORDER

Define Rate Sequence

SRCE_PROJ_ID

Source Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

TM_RT_ ORDER

Define Rate Sequence

SRCE_PROJ_ID

Source Project

Source Project is required for this Rate Table

You must enter a Source Project if the Rate table is PC (Project PLC Rates), PEC (Project PLC Rates By Employee), or PVC (Project PLC Rates By Vendor).

TM_RT_ ORDER

Define Rate Sequence

SRCE_PROJ_ID

Source Project

Source Project must be NULL for this Rate Table

You cannot enter a Source Project if the Rate table is C (Setup Project Labor Categories).

CEIL_DIR_CST

Project Direct Cost Ceilings screen (Projects » Project Setup » Project Ceilings)

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

CEIL_DIR_CST

Project Direct Cost Ceilings

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

CEIL_DIR_CST

Project Direct Cost Ceilings

PROJ_ID

Project

This is a soft warning:  Delete this validation.  Revenue Formula must exist

You must set up Project Information in the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup) or in the BASIC_REVENUE_ INFO.CSV file.

CEIL_DIR_CST

Project Direct Cost Ceilings

ACCT_ID

Account

Account is not valid

Make sure that the account exists in the Project Account Group that is assigned to this Project.

CEIL_DIR_CST

Project Direct Cost Ceilings

ACCT_ID

Account

Ceiling for this Account already exists for this Project

Verify that a ceiling has not already been set up for this Account/Project combination in the Project Direct Cost Ceilings screen (Projects » Project Setup » Project Ceilings), or the CEIL_DIR_CST.CSV file.

CEIL_DIR_CST

Project Direct Cost Ceilings

S_RBA_CD

Apply to (RBA)

Apply To (RBA) code is not valid

Verify that the Apply To (RBA) code is valid.  Valid entries are R (Revenue), B (Billing), A (Both), and N (Neither).

CEIL_DIR_CST

Project Direct Cost Ceilings

CEIL_AMT

Ceiling Amount

The Ceiling Amount may not be negative

Enter a positive number.

CEIL_DIR_HRS

Project Hours Ceilings

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

CEIL_DIR_HRS

Project Hours Ceilings

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

CEIL_DIR_HRS

Project Hours Ceilings

BILL_LAB_CAT_CD

Labor Cat

PLC is not valid

If this Project exists in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor) or in the PROJ_LAB_CAT.CSV, the PLC is valid only if it is assigned to the Project in the Assign PLC to Projects screen or the PROJ_LAB_CAT.CSV file.  If the Project does not exist in the Assign PLC to Projects screen or the PROJ_LAB_CAT.CSV file, it must exist in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor) or the BILL_LAB_CAT.CSV file.

CEIL_DIR_HRS

Project Hours Ceilings

BILL_LAB_CAT_CD

Labor Cat

PLC already exists for this Project

Verify that a ceiling has not already been set up for this PLC/Project combination in the Project Hours Ceilings screen (Projects » Project Setup » Project Ceilings), or the CEIL_DIR_HRS.CSV file.

CEIL_DIR_HRS

Project Hours Ceilings

CEIL_HRS

Hours Ceiling

The Hours Ceiling may not be negative

Verify that the Hours Ceiling is a positive number.

CEIL_BURDEN_CST

Project Burden Cost Ceilings

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

CEIL_BURDEN_CST

Project Burden Cost Ceilings

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

CEIL_BURDEN_CST

Project Burden Cost Ceilings

FY_CD

Fiscal Year

Fiscal Year is not valid

Verify that the Fiscal Year exists and has a status of "Open" in the Fiscal Years screen in Costpoint General Ledger.

CEIL_BURDEN_CST

Project Burden Cost Ceilings

POOL_NO

Pool

Pool Number does not exist for this Fiscal Year

Verify that the Pool Number exists for this Fiscal Year in the Cost Pools screen in Costpoint Cost and Revenue Processing with a Group number equal to 1.

CEIL_BURDEN_CST

Project Burden Cost Ceilings

S_RBA_CD

Apply to (RBA)

Apply To (RBA) code is not valid

Verify that the Apply To (RBA) code is valid.  Valid entries are R (Revenue), B (Billing), A (Both), and N (Neither).

CEIL_BURDEN_CST

Project Burden Cost Ceilings

S_CEIL_TYPE_ CD

C/O/F

C/O/F Code is not valid

Verify that the C/O/F Code is valid.  Valid entries are C (Ceiling), O (Override), and F (Fixed).

CEIL_BURDEN_CST

Project Burden Cost Ceilings

S_CEIL_TYPE_ CD

C/O/F

Duplicate Project/Fiscal Year/Pool Number/Account

Make sure that you do not have a duplicate Project/Fiscal Year/Pool Number/Account combination already set up in the Project Burden Cost Ceilings screen in Costpoint Project Setup, or the CEIL_BURDEN_CST.CSV file. A duplicate Project/Fiscal Year/Pool Number/Account is allowed only when one record has a Ceiling Type of O (Override) and another record has a Ceiling Type of C (Ceiling).

CEIL_BURDEN_CST

Project Burden Cost Ceilings

CEIL_RT

Rate Ceiling

Rate Ceiling cannot be negative

Verify that the Rate Ceiling is a positive number.

CEIL_BURDEN_CST

Project Burden Cost Ceilings

CEIL_COM_RT

COM Ceiling

COM Ceiling cannot be negative

Verify that the COM Ceiling is a positive number.

CEIL_BURDEN_CST

Project Burden Cost Ceilings

ACCT_ID

Account

Account does not exist

Verify that the account has been set up in the Maintain Accounts screen in Costpoint General Ledger.  Note:  Ceilings will be applied only if the account is set up in the base of the pool in the Cost Pool screen in Costpoint Cost and Revenue Processing.

EMPL_CEIL

Project Employee Hours Ceilings

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the Database and in the Maintain Users screen (Others » System Administration » System Security).

EMPL_CEIL

Project Employee Hours Ceilings

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

EMPL_CEIL

Project Employee Hours Ceilings

BILL_LAB_CAT_CD

Labor Cat

PLC does not exist

If the Project Work Force Required check box is selected in the Basic Info screen (Projects » Project Setup » Project Master), or if it is set to Y in the PROJ.CSV file, the PLC must be assigned in the Project Employee Work Force screen (Projects » Project Setup » Project Labor) or the PROJ_EMPL_LAB_ CAT.CSV file. If the Project Work Force Required check box is empty and the Project exists in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor) or the PROJ_LAB_CAT.CSV file, the PLC must exist in the Assign PLC to Projects screen or the PROJ_LAB_CAT.CSV file. If the Project does not exist, the PLC must exist in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor) or the BILL_LAB_CAT.CSV file.  Also, if the Use Top Level Work Force check box is selected in the Basic Info screen or is Y in the PROJ.CSV file, substitute the top Level Project for the Project for the preceding validations.

EMPL_CEIL

Project Employee Hours Ceilings

EMPL_ID

Employee

Employee does not exist

If the Project Work Force Required check box is cleared or set to N in the PROJ.CSV file, the Employee must be set up in the Basic Employee Info screen (People » Employee » Basic » Employee Setup). If the Project Work Force Required check box is selected or set to Y in the PROJ.CSV file, the Employee must be set up in the Project Employee Work Force screen (Projects » Project Setup » Project Labor), or the PROJ.EMPL.CSV file for the Project.  Also, if the Use Top Level Work Force check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or is Y in the PROJ.CSV file, then for the preceding validations, substitute the top Level Project for the Project.

EMPL_CEIL

Project Employee Hours Ceilings

EMPL_ID

 

Project/Employee/PLC already exists

Make sure that the PLC has not already been set up for this Employee/Project combination.

EMPL_CEIL

Project Employee Hours Ceilings

CEIL_HRS

Hours Ceiling

Hours Ceiling cannot be negative

Verify that the Hours Ceiling is a positive number.

VEND_CEIL

Project Vendor Hours Ceilings

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

VEND_CEIL

Project Vendor Hours Ceilings

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

VEND_CEIL

Project Vendor Hours Ceilings

BILL_LAB_CAT_CD

Labor Cat

PLC does not exist

If the Project Work Force Required check box is selected in the Basic Info screen (Projects » Project Setup » Project Master), or if it is set to Y in the PROJ.CSV file, the PLC must be assigned in the Project Vendor Work Force screen (Projects » Project Setup » Project Labor) or the PROJ_VEND_LAB_ CAT.CSV file.  If the Project Work Force Required check box is empty and the Project exists in the Assign PLC to Projects screen (Projects » Project Setup » Project Labor) or the PROJ_LAB_CAT.CSV file, the PLC must exist in the Assign PLC to Projects screen or the PROJ_LAB_CAT.CSV file. If the Project does not exist, the PLC must exist in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor) or the BILL_LAB_CAT.CSV file. Also, if the Use Top Level Work Force check box is selected in the Basic Info screen or the PROJ.CSV file, substitute the top Level Project for the Project for the preceding validations.

VEND_CEIL

Project Vendor Hours Ceilings

VEND_ID

Vendor

Vendor does not exist

Verify that the Vendor has been set up in the Maintain Vendors screen (Accounting » Accounts Payable » Vendor Info).

VEND_CEIL

Project Vendor Hours Ceilings

VEND_ID

Vendor

Project/Vendor/PLC already exists

Make sure that the PLC has not already been set up for this Vendor/Project combination.

VEND_CEIL

Project Vendor Hours Ceilings

CEIL_HRS

Hours Ceiling

Hours Ceiling cannot be negative

Verify that the Hours Ceiling is a positive number.

PROJ_BILL_ INFO_SCH

Project Billing Info - Supporting Schedule Headers (Detail Bills)

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_BILL_ INFO_SCH

Project Billing Info - Supporting Schedule Headers (Detail Bills)

PROJ_ID

Project

Project ID must be a child of the Invoice Proj ID

Verify that the Project ID is a child of the Invoice Project.

PROJ_BILL_ INFO_SCH

Project Billing Info - Supporting Schedule Headers (Detail Bills)

INVC_PROJ_ID

Project (Invoice)

Invoice Project does not exist in Proj Bill Info

Verify that the Invoice Project has been set up in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup), or the PROJ_BILL_INFO.CSV file.

PROJ_BILL_ INFO_SCH

Project Billing Info - Supporting Schedule Headers (Detail Bills)

INVC_PROJ_ID

Project (Invoice)

Project already exists

Make sure that the Project ID has not already been set up for this Invoice Project in the Supporting Schedule Headers (Detail Bills) subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup), or the PROJ_BILL_INFO_ SCH.CSV file.

PROJ_BILL_ INFO_SCH

Project Billing Info - Supporting Schedule Headers (Detail Bills)

SPPRT_SCH_ FRMT_CD

 

Supporting Schedule Code is not valid

Make sure that the Supporting Schedule Code is the same code that was assigned to the Invoice Project in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup), or the PROJ_BILL_INFO.CSV file.

OVRIDE_ MLT_ON_DIR

Maintain Multiplier Overrides

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

OVRIDE_MLT_ON_DIR

Maintain Multiplier Overrides

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

OVRIDE_MLT_ON_DIR

Maintain Multiplier Overrides

S_ACCT_ID

Starting Account

Starting Account does not exist

Make sure that the Account has been set up in the Maintain Accounts screen in Costpoint General Ledger.

OVRIDE_MLT_ON_DIR

Maintain Multiplier Overrides

END_ACCT_ID

Ending Account

Ending Account does not exist

Make sure that the Account has been set up in the Maintain Accounts screen in Costpoint General Ledger.

OVRIDE_MLT_ON_DIR

Maintain Multiplier Overrides

OVRIDE_MLT_RT

Multiplier

Starting and Ending Accounts Overlap

Check for overlapping values.

OVRIDE_MLT_ON_DIR

Maintain Multiplier Overrides

S_RBA_CD

Apply to (RGBA)

Apply to Code is not Valid

Verify that the Apply to Code is valid.  Valid entries are R (Revenue), B (Billing), G (Goal), and A (All).

OVRIDE_FEE_ON_DIR

Maintain Cost Fee Overrides

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

OVRIDE_FEE_ON_DIR

Maintain Cost Fee Overrides

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

OVRIDE_FEE_ON_DIR

Maintain Cost Fee Overrides

ACCT_ID

Account

The Acct must have a valid function in the Account Group

Verify that the Account has been set up in the Project Account Groups screen (Projects » Project Setup » Controls) for the Account Group that was assigned to the Project in the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file. 

OVRIDE_FEE_ON_DIR

Maintain Cost Fee Overrides

ACCT_ID

Account

Account already exists for this Project

Make sure that this Account does not already exist for this Project in the Maintain Cost Fee Overrides screen in Costpoint Project Setup, or the OVRIDE_FEE_ON_ DIR. CSV file.

OVRIDE_FEE_ON_DIR

Maintain Cost Fee Overrides

S_RBA_CD

Apply to (RBA)

Apply To (RBA) code is not valid

Verify that the Apply To (RBA) code is valid.  Valid entries are R (Revenue), B (Billing), A (Both), and N (Neither).

OVRIDE_FEE_ON_BURD

Maintain Burden Fee Overrides

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

OVRIDE_FEE_ON_BURD

Maintain Burden Fee Overrides

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

OVRIDE_FEE_ON_BURD

Maintain Burden Fee Overrides

FY_CD

Fiscal Year

Fiscal Year is not valid

Verify that the Fiscal Year has been set up in the Fiscal Years screen in Costpoint General Ledger.

OVRIDE_FEE_ON_BURD

Maintain Burden Fee Overrides

POOL_NO

Pool

Pool Number does not exist for this Fiscal Year

Verify that the Pool Number exists for this Fiscal Year in the Cost Pools screen in Costpoint Cost and Revenue Processing with a Group number equal to 1.

OVRIDE_FEE_ON_BURD

Maintain Burden Fee Overrides

POOL_NO

Pool

Duplicate Project/Fiscal Year/Pool Number

Verify that the Fiscal Year/Pool Number combination has not already been set up for this Project in the Maintain Burden Fee Overrides screen in Costpoint Project Setup, or the OVRIDE_FEE_ON_ BURD.CSV file.

OVRIDE_FEE_ON_BURD

Maintain Burden Fee Overrides

S_RBA_CD

Apply to (RBA)

Apply To (RBA) code is not valid

Verify that the Apply to (RBA) code is valid.  Valid entries are R (Revenue), B (Billing), and A (Both).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

EMPL_ID

Employee

Not valid when using Union Functionality

You cannot add records to this table if the Enable Union Functionality check box is selected in the Labor Settings screen in Costpoint Labor.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

EMPL_ID

Employee

Employee does not exist

Make sure that the Employee has been set up in the Basic Employee Info screen (People » Employee » Basic » Employee Setup).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.  Note:  If you wish to apply the defaults for this employee to all projects, enter an asterisk (*) in the PROJ_ID column.

EMPL_PROJ _TS_DFLT

Employee Project TS Defaults

PROJ_ID

Project

Default already exists for this Employee/Project

Make sure that a default has not already been set up for this Employee/Project combination in the Employee Project TS Defaults screen in Costpoint Labor or the EMPL_PROJ_TS_ DFLT.CSV file.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

APPLY_LOWER_LVL_FL

Apply to Lower Levels

Apply to lower levels flag is not valid

Verify that the Apply to Lower Levels flag is Y or N.  Also, if the Project is = * (asterisk) in the input file, the Apply to lower levels flag must be N.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

ACCT_ID

Account

Account must be Active and Project Required.

Make sure that the Account ID has been set up in the Maintain Accounts screen in Costpoint General Ledger with the Project Required and the Active check boxes both selected.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

ACCT_ID

Account

Project/Account combination does not exist or is not a member of the PAG

If the Limit Accounts check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or is set to Y in the PROJ.CSV file, you must set up the Project/Account wildcard in the Maintain Project Account Validation screen in Costpoint Project Setup.  If the Limit Accounts check box is not selected in the Basic Info screen (Projects » Project Setup » Project Master) or is set to N in the PROJ.CSV file, the Account must exist in the Project Account Group that is assigned to the Project.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

ORG_ID

Organization

Organization is not valid

Make sure that the Organization has been set up in the Define Org Structures screen (Accounting » General Ledger » Organizations) and the Maintain Org Elements screen (Accounting » General Ledger » Organizations) with the Active check box selected.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

ORG_ID

Organization

Account/Org combination does not exist

Make sure that the Account is linked to the Organization in the Maintain Account/Org Links screen (Accounting » General Ledger » Accounts) and that the Active column is Y.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

ORG_ID

Organization

Project/Org combination does not exist

When the Limit Orgs check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or is set to Y in the PROJ.CSV file, the Project/Organization wildcard must be set up in the Maintain Project/ Organization Validation screen in Costpoint Project Setup.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

ORG_ID

Organization

Project/Account/Org combination does not exist

When the Limit which orgs can charge specific Accts check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or is set to Y in the PROJ.CSV file, the Project/Account/Org/Ref 1/Ref 2 combination must be Y in the Active column in the Maintain Valid Project/Account/Orgs screen (Projects » Project Setup » Project Master) or the PROJ_ORG_ ACCT.CSV file.

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

REF1_ID

Reference 1

REF 1 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

REF2_ID

Reference 2

REF 2 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

REG_PAY_TYPE

Regular Pay Type

Pay Type is not valid

Verify that the Regular Pay Type has been set up as a valid Pay Type in the Pay Types screen (People » Labor » Labor Controls).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

GENL_LAB_ CAT_CD

GLC

GLC does not exist

Make sure that the GLC has been set up in the General Labor Categories screen (People » Labor » Labor Controls).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

LAB_LOC_CD

Labor Location

Labor Location does not exist

Make sure that the Labor Location has been set up in the Labor Locations/Locals screen (People » Labor » Labor Rate).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

WORK_COMP_CD

Worker's Comp

Worker's Comp Code does not exist

Make sure that the WC Code has been set up in the Worker's Comp Codes screen (People » Labor » Labor Controls).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

BILL_LAB_CAT_CD

PLC

PLC does not exist

Make sure that the PLC has been set up in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor).

EMPL_PROJ_ TS_DFLT

Employee Project TS Defaults

WH_STATE_CD

W/H State

The withholding state is not valid.

The Withholding State must exist in the STATE table. 

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

ACCT_GRP_CD

Project Account Group

Project Account Group does not exist

Make sure that the Project Account Group has been set up in the Project Account Groups screen (Projects » Project Setup » Controls).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

LAB_GRP_TYPE

Labor Group

Labor Group does not exist

Verify that the Labor Group Code has been set up in the Labor Locations/Locals screen (People » Labor » Labor Rate).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

LAB_GRP_TYPE

Labor Group

Labor Group/ Project Account Group already exists

Verify that the Project Account Group/Labor Group combination does not already exist in the Labor-Grp Project-Acct-Grp TS Defaults screen (People » Labor » Timesheet Default) or the LAB_ACCT_ GRP_DFLT.CSV file.

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

ACCT_ID

Account

Account must be a member of the Project Account Group

Make sure that the Account ID has been set up for the appropriate Account Group in the Project Account Groups screen (Projects » Project Setup » Controls) with a function of LABOR, NON-LABOR, UNALLOW-LABOR, or UNALLOW NON-LABR.

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

ORG_ID

Organization

The Account/Org Combination does not exist

Make sure that the Account is linked to the Organization in the Maintain Account/Org Links screen (Accounting » General Ledger » Accounts) and that the Active column is Y.

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

REF1_ID

Reference 1

REF 1 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

REF2_ID

Reference 2

REF 2 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

REG_PAY_TYPE

Regular Pay Type

Pay Type is not valid

Verify that the Regular Pay Type has been set up as a valid Pay Type in the Pay Types screen (People » Labor » Labor Controls).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

GENL_LAB_ CAT_CD

GLC

GLC does not exist

Make sure that the GLC has been set up in the General Labor Categories screen (People » Labor » Labor Controls).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

LAB_LOC_CD

Labor Location

Labor Location does not exist

Make sure that the Labor Location has been set up in the Labor Locations/Locals screen (People » Labor » Labor Rate).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

WORK_COMP_CD

Worker's Comp

Worker's Comp Code does not exist

Make sure that the WC Code has been set up in the Worker's Comp Codes screen (People » Labor » Labor Controls).

LAB_ACCT_ GRP_DFLT

Labor-Grp-Project-Acct-Grp TS Defaults

BILL_LAB_CAT_CD

PLC

PLC does not exist

Make sure that the PLC has been set up in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the and in the Maintain Users screen (Others » System Administration » System Security).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

EMPL_ID

Employee

Not valid when using Union Functionality

You cannot add records to this table if the Enable Union Functionality check box is selected in the Labor Settings screen (People » Labor » Labor Controls).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

EMPL_ID

Employee

Employee does not exist

Make sure that the Employee has been set up in the Basic Employee Info screen (People » Employee » Basic » Employee Setup).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

ACCT_GRP_CD

Project Account Group

Project Account Group does not exist

Make sure that the Project Account Group has been set up in the Project Account Groups screen (Projects » Project Setup » Controls).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

ACCT_GRP_CD

Project Account Group

Employee/Project Account Group already exists

Verify that the Employee/ Project Account Group combination does not already exist in the Employee Project-Acct-Grp TS Defaults screen (People » Labor » Timesheet Default), or the EMPL_ACCT_ GRP_DFLT.CSV file.

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

ACCT_ID

Account

Account must be a member of the Project Account Group

Make sure that the Account ID has been set up for the appropriate Account Group in the Project Account Groups screen (Projects » Project Setup » Controls) with a function of LABOR, NON-LABOR, UNALLOW-LABOR, or UNALLOW NON-LABR.

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

ORG_ID

Organization

The Account/Org Combination does not exist

Make sure that the Account is linked to the Organization in the Maintain Account/Org Links screen (Accounting » General Ledger » Accounts) and that the Active column is Y.

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

REF1_ID

Reference 1

REF 1 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

REF2_ID

Reference 2

REF 2 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

REG_PAY_TYPE

Regular Pay Type

Pay Type is not valid

Verify that the Regular Pay Type has been set up as a valid Pay Type in the Pay Types screen (People » Labor » Labor Controls).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

GENL_LAB_ CAT_CD

GLC

GLC does not exist

Make sure that the GLC has been set up in the General Labor Categories screen (People » Labor » Labor Controls).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

LAB_LOC_CD

Labor Location

Labor Location does not exist

Make sure that the Labor Location has been set up in the Labor Locations/Locals screen (People » Labor » Labor Rate).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

WORK_COMP_CD

Worker's Comp

Worker's Comp Code does not exist

Make sure that the WC Code has been set up in the Worker's Comp Codes screen (People » Labor » Labor Controls).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

BILL_LAB_CAT_CD

PLC

PLC does not exist

Make sure that the PLC has been set up in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor).

EMPL_ACCT_GRP_DFLT

Employee Project-Acct-Grp TS Defaults

WH_STATE_CD

W/H State

The Withholding State is not valid

The Withholding State must exist in the STATE table.

PROJ_TS_ DFLT

Project TS Defaults

USER_ID

 

User ID is not valid

Make sure that the User ID has been set up in the database and in the Maintain Users screen (Others » System Administration » System Security).

PROJ_TS_ DFLT

Project TS Defaults

DFLT_PROJ_ID

 

Project ID does not exist

Make sure that the Project ID exists in the Basic Info screen (Projects » Project Setup » Project Master).

PROJ_TS_ DFLT

Project TS Defaults

PROJ_ID

Project

Project ID does not exist

Make sure that the Project ID exists in either the Basic Info screen (Projects » Project Setup » Project Master) or the PROJ.CSV file.

PROJ_TS_ DFLT

Project TS Defaults

PROJ_ID

Project

Project already exists

Make sure that the Project does not already exist in the Project TS Defaults screen (People » Labor » Timesheet Default) or the PROJ_TS_DFLT.CSV file.

PROJ_TS_ DFLT

Project TS Defaults

APPLY_LOWER_LVL_FL

Apply to Lower Levels

Apply to lower levels flag is not valid

Verify that the Apply to Lower Levels flag is Y or N.

PROJ_TS_ DFLT

Project TS Defaults

ORG_ID

Organization

Organization is not valid

Make sure that the Organization has been set up in the Maintain Org Elements screen in Costpoint General Ledger. Also, if the Limit Orgs check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or is set to Y in the PROJ.CSV file for this Project, then the Project/ Organization wildcard must be set up in the Maintain Project/Organization Validation screen (Projects » Project Setup » Controls).

PROJ_TS_ DFLT

Project TS Defaults

ORG_ID

Organization

Account/Org combination is not valid

Make sure that the Account is linked to the Organization in the Maintain Account/Org Links screen (Accounting » General Ledger » Accounts) and that the Active column is Y.  Also, if the Limit which Orgs can charge specific Accts check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or is set to Y in the PROJ.CSV file, the Project/Account/ Org/Ref 1/Ref 2 combination must exist with the Active column set to Y in the Maintain Valid Project/Account/Orgs screen (Projects » Project Setup » Project Master), or the PROJ_ORG_ ACCT.CSV file.

PROJ_TS_ DFLT

Project TS Defaults

ACCT_ID

Account

Account is not valid

Make sure that the Account ID has been set up in the Maintain Accounts screen in Costpoint General Ledger with the Project Required and the Active check boxes both selected.

PROJ_TS_ DFLT

Project TS Defaults

ACCT_ID

Account

Project/Account combination does not exist or is not a member of the PAG

If the Limit Accounts check box is selected in the Basic Info screen (Projects » Project Setup » Project Master) or is set to "" in the PROJ.CSV file, the Project/Account wildcard must be set up in the Maintain Project/Account Validation screen (Projects » Project Setup » Controls).  If it is set to N, the Account must exist in the Project Account Group that is assigned to the Project.

PROJ_TS_ DFLT

Project TS Defaults

REF1_ID

Reference 1

REF 1 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

PROJ_TS_ DFLT

Project TS Defaults

REF2_ID

Reference 2

REF 2 does not exist

Verify that the Reference Number has been set up in the Define Ref Structures screen (Accounting » General Ledger » Reference Numbers) and the Maintain Ref Elements screen (Accounting » General Ledger » Reference Numbers).

PROJ_TS_ DFLT

Project TS Defaults

REG_PAY_TYPE

Regular Pay Type

Pay Type is not valid

Verify that the Regular Pay Type has been set up as a valid Pay Type in the Pay Types screen (People » Labor » Labor Controls).

PROJ_TS_ DFLT

Project TS Defaults

GENL_LAB_ CAT_CD

GLC

GLC does not exist

Make sure that the GLC has been set up in the General Labor Categories screen (People » Labor » Labor Controls).

PROJ_TS_ DFLT

Project TS Defaults

LAB_LOC_CD

Labor Location

Labor Location does not exist

Make sure that the Labor Location has been set up in the Labor Locations/Locals screen (People » Labor » Labor Rate).

PROJ_TS_ DFLT

Project TS Defaults

WORK_COMP_CD

Worker's Comp

Worker's Comp Code does not exist

Make sure that the WC Code has been set up in the Worker's Comp Codes screen (People » Labor » Labor Controls).

PROJ_TS_ DFLT

Project TS Defaults

BILL_LAB_CAT_CD

PLC

PLC does not exist

Make sure that the PLC has been set up in the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor).

PROJ_TS_ DFLT

Project TS Defaults

WH_STATE_CD

W/H State

The Withholding State is not valid

The Withholding State must exist in the State table. 

PROJ_RPT_ID

Alternate Reporting

PROJ_RPT_ID

Project Report

The Project Report ID already exists.

Make sure that the Project Report ID does not already exist in the PROJ_RPT_ID table or the PROJ_RPT_ID.csv file.

PROJ_RPT_ID

Alternate Reporting

PROJ_RPT_ID

Project Report

The Project Report ID exceeds the maximum number of characters.

Make sure that the Project Report ID does not exceed the top level length set in the Project Settings screen (Projects » Project Setup » Controls).

PROJ_RPT_ID

Alternate Reporting

LVL_NO

Level Number

Level Number must be a number.

Make sure that the Level Number is a numeric field and does not already exist for the same PROJ_RPT_ID.  Must be in increments of 1.

PROJ_RPT_ID

Alternate Reporting

PROJ_RPT_DESC

Project Report Description

The Project Report Description is missing.

Make sure that there is a project report description for the PROJ_RPT_ID.

PROJ_RPT_ID

Alternate Reporting

Lxx_PROJ_RPT_NAME

Level xxx Project Report Name

The Project Report Name exceeds the maximum number of characters allowed.

Make sure that the project report description does not exceed the maximum number of characters allowed for each Level 1 – Level 15.

PROJ_RPT_ID

Alternate Reporting

Lxx_PROJ_RPT_SG_ID

Level xxx Project Report Segment

The Project report segment exceeds the maximum number of characters allowed.

Make sure that the project report segments do not exceed the maximum number of characters allowed for each Level 1 – 15.

TOP_LVL_RPT

Alternate Reporting

PROJ_RPT_ID

Project Report

The project report ID does not exist.

Make sure that the project report ID exists in the PROJ_RPT_ID table or the PROJ_RPT_ID.csv file.

TOP_LVL_RPT

Alternate Reporting

LVL_DESC

Level Description

The project level description is missing.

Make sure that the project level description exists in the TOP_LVL_RPT.csv file.

TOP_LVL_RPT

Alternate Reporting

LVL_LEN_NO

Level Length

The level length is missing.

Make sure the level length exist in the TOP_LVL_RPT.csv file.

TOP_LVL_RPT

Alternate Reporting

LVL_LEN_NO

Level Length

The level length must be a numeric value.

Make sure that the level length is a numeric field.

TOP_LVL_RPT

Alternate Reporting

LVL_NO

Level Number

The level number is missing.

Make sure the level number exists in the TOP_LVL_RPT.csv file.

TOP_LVL_RPT

Alternate Reporting

LVL_NO

Level Number

Level Number must be a number.

Make sure that the Level Number is a numeric field and does not already exist for the same PROJ_RPT_ID.

PROJ_RPT_PROJ

Alternate Reporting - Link Projects

PROJ_ID

Project

The project does not exist.

Make sure that the project exists in the PROJ table or PROJ.csv file.

PROJ_RPT_PROJ

Alternate Reporting - Link Projects

PROJ_RPT_ID

Project Report

The project report ID does not exist.

Make sure that the project report id exists in the PROJ_RPT_ID table or the PROJ_RPT_ID.csv file.

PROJ_RPT_PROJ

Alternate Reporting - Link Projects

INCL_SUBPROJ_FL

Include Sub Project (Y/N)

The include lower level projects flag must be Y or N.

Make sure that the INCL_SUBPROJ_FL = Y or N.

 

Revenue Formula Validation Detail

 

Revenue Formula

Revenue Formula Description

Allow Calc Rev On Units

Allow Calc Amt

Description

Allow Calc1 Amt

Description

Allow Calc2 Amt

Description

ETC

Cost Incurred Using Estimate To Complete

N

Y

Est To Complete

N

 

N

 

CPFH

Fee on Hours Plus Cost Incurred

Y

Y

Fee on Hours

N

 

N

 

CPFC

Cost Plus Fee On Cost

Y

Y

Labor Fee Pct.

Y

Non-Labor Fee

N

 

BACKLOG

Contract Value Less Backlog

N

Y

Backlog

N

 

N

 

NONE

Do Not Compute

N

N

 

N

 

N

 

CVPC

Contract Value Times Percent Complete

N

Y

Pct. Complete

N

 

N

 

ETBBR

Equal To Billings Before Retainage

N

N

 

N

 

N

 

ETBAR

Equal To Billings After Retainage

N

N

 

N

 

N

 

ETPL

Equal To Project Ledger Sales

N

N

 

N

 

N

 

ETD

Equal To Deliveries

N

N

 

N

 

N

 

ITDCPFC

ITD Fee on Cost

Y

Y

Labor Fee Pct.

Y

Non-Labor Fee

 

 

LLR

Loaded Labor Rate

Y

N

 

N

 

N

 

LLRCINL

Loaded Labor Rate Plus Cost Incurred On Non-labor (T&M)

Y

N

 

N

 

N

 

LLRCINLB

Loaded Labor Plus Non-labor Plus Burden on Non-labor

Y

N

 

N

 

N

 

LLRCINBF

Loaded Labor Plus Non-Labor W/Burden W/Fee

Y

Y

Fee Percent

N

 

N

 

FAYTD

Fixed Amount Year To Date

N

Y

YTD Revenue

N

 

N

 

FAMTD

Fixed Amount Month To Date

N

Y

MTD Revenue

N

 

N

 

FACTD

Fixed Amount Contract To Date

N

Y

CTD Revenue

N

 

N

 

UNIT

Unit Revenue Only

Y

N

 

N

 

N

 

LLRFNLBF

Loaded Labor Rate W/Fee Plus Non-Labor W/Burden W/Fee

Y

Y

Labor Fee Pct.

Y

Non-Labor Fee

N

 

CIMR

Labor Cost times Multiplier plus Non-labor times Multiplier (Hours)

Y

Y

Labor Multiplier

Y

Non-Labor

N

 

CVPCVSE

Contract Value Times % Complete Vs. Rate Schedule

Y

Y

Pct Complete

Y

Labor Multiplier

Y

Non-Labor

RSMNLM

Rate Schedule times Multiplier Plus Non-labor times Multiplier

Y

Y

Labor Multiplier

Y

Non-Labor

N

 

LLRBFNBF

Loaded Labor Rate W/Burden W/Fee Plus Non-Labor W/Burden W/Fee

Y

Y

Labor Fee Pct.

Y

Non-Labor Fee

N

 

CPFCCMF

Cost Plus Fee on Cost Current Month Fee

Y

Y

Labor Fee Pct.

Y

Non-Labor Fee

N

 

COSTIMR

Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost)

Y

Y

Labor Multiplier

Y

Non-Labor

N

 

EAC

Cost Incurred using Estimate At Completion

N

Y

Est At Comp

N

 

N

 

 

Billing Formula Validation Detail

 

Billing Formula

Billing Formula Description

Allow Calc Amt

Calc Description

Allow Calc1 Amt

Description

CPFH

Cost Incurred Plus Fee On Hours

Y

Fee On Hours

N

 

CPFC

Cost Incurred Plus Fee On Cost

Y

Fee Percent

N

 

CPFCAF

Cost Incurred Plus Fee On Cost Plus Award Fee

Y

Fee Percent

N

 

CPFHAF

Cost Incurred Plus Fee On Hours Plus Award Fee

Y

Fee On Hours

N

 

LLR

Loaded Labor Rate

N

 

N

 

LLRCINL

Loaded Labor Rate Plus Cost Incurred On Non-labor (T&M)

N

 

N

 

LLRCINLB

Loaded Labor Plus Non-labor Plus Burden On Non-labor

N

 

N

 

LLRCINBF

Loaded Labor Plus Non-labor W/Burden W/Fee

Y

Fee Percent

N

 

UNIT

Unit Price Transactions Only

N

 

N

 

CIMR

Labor Cost times Multiplier plus Non-labor times Multiplier (Hours)

Y

Labor Multiplier

Y

Non-Labor Multiplier

1443

Progress Payment

N

 

N

 

RSMNLM

Rate Schedule Times Multiplier Plus Non-Labor Cost Times Multiplier

Y

Labor Multiplier

Y

Non-Labor Multiplier

RSBFNLBF

Loaded Labor Rate w/Burden w/Fee plus Non-labor w/Burden w/Fee

Y

Labor Fee Percent

Y

Non-Labor Fee Percent

LLRFNLBF

LLR W/Fee Plus Non-Labor W/Burden W/Fee

Y

Labor Fee Percent

Y

Non-Labor Fee Percent

MANUAL

Manual Bills with Unbilled Detail

N

 

N

 

COSTIMR

Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost)

Y

Labor Multiplier

Y

Non-Labor Multiplier

NONE

Enter Bill Manually

N

 

N