Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

SQL Part (PT2) Error Messages

These are the errors associated specifically with processing the PT2 Line Type.

Error Message Additional Info/Remedy
Cannot change Ord Policy (Ord To Qty). The Order Policy Type cannot be changed.  There is an existing Part Project record with a non-zero value in the Order To Quantity column. To change the Order Policy Type to a value other than O, you must remove the dependency by changing the Order To Quantity to zero.
Cannot change Ord Policy (Reord Pt Qty). The Order Policy Type cannot be changed. There is an existing Part Project record with a non-zero value in the Reorder Point Quantity column. The Reorder Point Quantity must be greater than zero if the Order Policy Type (in the Part table) is R(Reorder Point). To change the Order Policy Type to a value other than R(Reorder Point), you must remove the dependency by changing the Reorder Point Quantity to zero.
Min Lot Size not allowed (Order Policy). The Minimum Lot Size Quantity cannot have a value greater than zero unless the Order Policy Type is R(Reorder Point) or M (Min/Mult Lot Size). Change the Minimum Lot Size Quantity to zero, or change the Order Policy Type to R or M.
Min/Mult Lot Size required (Ord Policy). The Minimum Lot Size Quantity or Multiple Lot Size Quantity must be provided with a value greater than zero because the Order Policy Type is M (Min/Mult Lot Size). Change the Minimum Lot Size Quantity or Multiple Lot Size Quantity to a value greater than zero, or change the Order Policy Type to a value other than M.
Mult Lot Size not allowed (Ord Policy). The Multiple Lot Size Quantity cannot have a value greater than zero unless the Order Policy Type is M(Min/Mult Lot Size). Change the Multiple Lot Size Quantity to zero, or change the Order Policy Type to M(Min/Mult Lot Size).
Pd Ord Days is required (Order Policy). Period Order Days is required when the Order Policy Type is P(Period). You must provide a value greater than zero for Period Order Days or change the Order Policy Type to a value other than P.
Pd Ord Days not allowed (Order Policy). Period Order Days can be greater than zero if the Order Policy Type is P (Period). You must change Period Order Days to zero or change the Order Policy Type to P.
PT2 rejected, duplicate key. Each PT2 record in the input file must have a unique key (Part ID/Part Revision ID). The input file contains multiple PT2 records with the same key values indicated on the report. Remove all duplicate PT2 records.
??? cannot be negative.

For Shelf Life in Days, Planning Days Past Expiration Date, No. of Days for Recertification and No. of Extensions Allowed- IF the number being uploaded contains a minus sign which is not allowed for this column. Modify the input file to provide a positive number for the indicated column.

Allow Use Past Exp Date must be Y or N.

The entered value for Allow Use Past Expiration Date is not equal to Y or N.

Invalid Shelf Life Type.

The entered value is not equal to any of the following: None = null, Extendable = E, Non-extendable = N.

XXX not allowed. Planning Days Past Expiration Date , No. of Days for Recertification and/or No. of Extensions Allowed is greater than 0 and Allow Use Past Expiration Date = N.