|
Error Message |
Error Condition |
Column(s) |
|
The XXXXXXXXXXXX field must be entered. |
Not supplied in input file. |
All Required Fields |
|
Input File Line Type must be H or L |
Not "H" or "L." |
Record Type |
|
Error Message |
Error Condition |
Column(s) |
|
At least one Update Line Input record must be entered for each Header Input record. |
No row exists in input file with Record Type = "L" for matching PO_ID/Status Update ID combination. |
Update Header |
|
Status Update ID is required. It is not supplied in the input file and the system is unable to auto-assign it. |
If no value is in the input file and the system is not set up for Auto-Assign for PO Receipt transaction for the corresponding warehouse. This is the WHSE/WHSE_LAST_TRANS for your company if you are using Inventory. If you are not using Inventory, this is the RECV_SETTINGS.LAST_RECPT_ID for your company. |
Status Update ID |
|
This is not a valid warehouse ID. |
Not null, and Warehouse does not exist (WHSE for your company). |
Warehouse |
|
This is not a valid Employee ID. |
Invalid Employee (EMPL for your company). |
Employee |
|
This employee is not active. |
Inactive Employee (EMPL for your company). |
Employee |
|
This is not a valid subcontract PO. |
PO ID does not exist in PO_HDR, or it exists but PO Type is not "S" (PO_HDR for your company). |
PO ID |
|
This PO header row occurs multiple times for the same PO in the input file. |
Input file has multiple rows with same PO_ID. |
PO ID |
|
Status updates cannot be made to subcontract POs with a header status of "V" (Void) or "P" (Pending). |
PO Header Status is "V" (Void) or "P" (Pending) (PO_HDR for your company). |
PO ID |
|
This subcontract PO has a status of Closed. |
Subcontract PO Header Status is "C" (Closed) (PO_HDR for your company). |
PO ID |
|
Warning: This subcontract PO has a status of System Closed. |
Subcontract PO Header Status is "S" (System closed) (PO_HDR for your company). |
PO ID |
|
The maximum Progress Payment Request number of 999 has already been used for this subcontract PO. The system is unable to automatically default in the next Progress Payment. |
Not in input file, and a row already exists in RECPT_HDR (for your company) with the maximum DRAW_RQST_NO = 999 for matching PO_ID (for your company). |
Progress Payment Request |
|
Subcontract PO voucher has been created against this Status Update ID and/or Progress Payment Request Number for this Subcontract PO. No modifications are allowed. |
Subcontract PO voucher has already been created for a status update matching the input file combination of PO ID, Status Update ID, and/or Progress Payment Request Number [RECPT_HDR.VCHR_KEY is not null for RECPT_HDR row with matching {(PO_ID) + (RECPT_ID and/or DRAW_RQST_ID)}, for your company]. |
|
|
Warning: A Subcontract PO Status Update already exists with this Status Update ID and/or Progress Payment Request Number for this Subcontract PO, but a voucher has not yet been created against it. Existing status update values will be replaced upon processing. |
Subcontract PO voucher has NOT been created for a status update matching the input file combination of PO ID, Status Update ID, and/or Progress Payment Request Number [RECPT_HDR.VCHR_KEY is not null for RECPT_HDR row with matching {(PO_ID) + (RECPT_ID and/or DRAW_RQST_ID)}, for your company]. |
|
|
All existing status update transactions for this subcontract PO must be vouchered before a new one can be created. |
If there is no status update record for the input file combination of PO ID, Status Update ID, and/or Progress Payment Request Number, and there are Subcontract PO Status Updates (for matching PO) that have NOT been vouchered [Input file combination of {(PO_ID) + (RECPT_ID and/or DRAW_RQST_ID)}, does not exist in RECPT_HDR, and RECPT_HDR.VCHR_KEY is NULL for any RECPT_HDR row with matching PO_ID (for your company)]. |
|
|
This Receipt ID already exists for a different PO/Progress Payment combination. |
If the input file has a PO/Status Update ID/Progress Payment Request Number combination, and a row already exists in RECPT_HDR (for your company) with RECPT_ID equal to Status Update ID in input file, but for different PO_ID/DRAW_RQST_NO. |
Status Update ID |
|
Error Message |
Error Condition |
Column(s) |
|
Every Line Input record must have an associated Update Header Input record. |
No row exists in input file with Record Type = "H" for matching PO_ID/Status Update ID combination. |
Update Line |
|
Status updates cannot be made to subcontract POs with a line status of "C" (Closed), "V" (Void) or "P" (Pending). |
PO Line Status is "C" (Closed), "V" (Void), or "P" (Pending) in associated PO (for your company). |
PO Line |
|
This PO line does not exist in the associated PO. |
PO line number does not exist for the PO (for your company) on the input file row. |
PO Line |
|
This PO line occurs multiple times for the same PO in the input file. |
Input file has multiple rows with same PO line number for same PO_ID (for your company). |
PO Line |
|
This amount cannot be negative. |
Value < "0." |
Requested Work Amt |
|
Warning: Requested Work Amount submitted by the subcontractor is different from the sum of Completed Work Amount and Stored Materials Amount. |
Requested Work Amt (PO_LN.TRN_RQSTD_AMT) is not equal to Completed Work Amt + Stored Materials Amt (PO_LN.TRN_COMPLT_AMT + TRN_STORED_AMT) for PO associated with your company. |
Requested Work Amt |
|
Should be 0-100 % |
Value not "0" - "100." |
Percent Complete |
|
This amount cannot be negative when the Subcontract PO line Order Amount is positive. |
Value < "0," and Subcontract PO line Order Amount > "0" (for PO associated with your company). |
Completed Work Amt |
|
This amount must be zero when the Subcontract PO line Order Amount is zero. |
Value <> "0," and Subcontract PO line Order Amount is equal to zero (for PO associated with your company). |
Completed Work Amt (PO_LN.TRN_COMPLT_AMT, PO_LN.TRN_PO_LN_EXT_AMT) |
|
Should be 0-100 % |
Value not "0" - "100." |
Completed Work Retention Pct |
|
This amount cannot be negative. |
Value < "0." |
Completed Work Retention Amt |
|
This amount cannot be positive when the Subcontract PO line Order Amount is zero. |
Value <> "0," and Subcontract PO line Order Amount is equal to zero (for PO associated with your company). |
Completed Work Retention Amt |
|
Completed Work Retention Amount cannot be greater than the Completed Work Amount for the PO line. |
For the PO line, Completed Work Retention Amt entered is greater than Completed Work Amt (for PO associated with your company). Applicable only when Subcontract PO line Order Amount > "0." |
Completed Work Retention Amt (PO_LN.TRN_COMPLT_RET_AMT, PO_LN.TRN_COMPLT_AMT) |
|
This amount cannot be negative. |
Value < "0." |
Stored Materials Amt |
|
Should be 0-100 % |
Value not "0" - "100." |
Stored Materials Retention Pct |
|
This amount cannot be negative. |
Value < "0" |
Stored Materials Retention Amt |
|
Stored Materials Retention Amount cannot be greater than the Stored Materials Amount for the PO line. |
For the PO line, Stored Materials Retention Amt entered is greater than Stored Materials Amt (for PO associated with your company). Applicable only when Subcontract PO line Order Amount > "0." |
Stored Materials Retention Amt (PO_LN.TRN_STORED_RET_AMT, PO_LN.TRN_STORED_AMT) |
|
All existing status update transactions for this subcontract PO must be vouchered before a new one can be created. |
Subcontract PO has an existing status update transaction that has not yet been vouchered (RECPT_HDR.VCHR_KEY=Null) for PO associated with your company. |
RECPT_HDR.VCHR_KEY |
|
Sum of Completed Work Amt and Stored Materials Amt for the line cannot exceed the PO line amt. |
(Completed Work Amt + Stored Materials Amt) > PO Line Amt (for PO associated with your company). Applicable only when Subcontract PO line Order Amount > "0." |
PO_LN.TRN_COMPLT_AMT, PO_LN.TRN_STORED_AMT, PO_LN.TRN_PO_LN_EXT_AMT |
|
Warning: This update will make the PO line amount that is eligible for voucher to be negative. |
Value of (Total Completed Work Amt + Total Stored Materials Amt - Completed Work Retention Amt - Stored Materials Retention Amt - Previously Vouchered Amt) is negative for PO associated with your company. Applicable only when Subcontract PO line Order Amount > "0." |
PO_LN.TRN_COMPLT_AMT, PO_LN.TRN_STORED_AMT, PO_LN.TRN_COMPLT_RET_AMT, PO_LN.TRN_STORED_RET_AMT, PO_LN.TRN_VCHRD_AMT |
|
Warning: The PO line amount that is eligible for voucher is positive. |
Value of [(Completed Work Amount + Stored Materials Amount - Completed Work Retention Amount - Stored Materials Retention Amount) - (Previously Vouchered Extended Cost Amounts)] * [{1+(PO Line Sales Tax Rate) if Voucher Settings Discount Tax Flag is "Y"}] is positive. |
PO_LN.TRN_COMPLT_AMT, PO_LN.TRN_STORED_AMT, PO_LN.TRN_COMPLT_RET_AMT, PO_LN.TRN_STORED_RET_AMT, PO_LN.TRN_VCHRD_AMT |
|
Warning: This PO line has a status of "S" (System closed). Modifications made will cause this PO line status to be changed to "O" (Open). |
|
PO_LN.S_LN_STATUS_TYPE, PO_LN.TRN_STORED_AMT, PO_LN.TRN_COMPLT_AMT, PO_LN.TRN_COMPLT_RET_AMT, PO_LN.TRN_PO_LN_EXT_AMT |
|
This amount must be zero when the Subcontract PO line Order Amount is negative. |
Value > "0," and Subcontract PO line Order Amount < "0" (for PO associated with your company). |
Requested Work Amt |
|
This amount cannot be positive when the Subcontract PO line Order Amount is negative. |
Value > "0," and Subcontract PO line Order Amount < "0" (for PO associated with your company). |
Completed Work Amt |
|
Completed Work Amt (negative) for the line cannot be less than the PO line amt (negative). |
Completed Work Amt (negative) < PO Line Amt (negative), and Subcontract PO line Order Amount < 0 (for PO associated with your company). |
Completed Work Amt |
|
This value must be zero when the Subcontract PO line Order Amount is negative. |
Value > "0," and Subcontract PO line Order Amount < "0" (for PO associated with your company). |
Completed Work Retention Pct |
|
This amount must be zero when the Subcontract PO line Order Amount is negative. |
Value > "0," and Subcontract PO line Order Amount < "0" (for PO associated with your company). |
Completed Work Retention Amt |
|
This value must be zero when the Subcontract PO line Order Amount is negative. |
Value > "0," and Subcontract PO line Order Amount < "0" (for PO associated with your company). |
Stored Materials Retention Pct |
|
This amount must be zero when the Subcontract PO line Order Amount is negative. |
Value > "0," and Subcontract PO line Order Amount < "0" (for PO associated with your company). |
Stored Materials Amt |
|
This amount must be zero when the Subcontract PO line Order Amount is negative. |
Value > "0," and Subcontract PO line Order Amount < "0" (for PO associated with your company). |
Stored Materials Retention Amt |
|
This is not a valid warehouse ID. |
Not null, and Warehouse does not exist (WHSE for your company). |
Warehouse |