|
Column(s) |
Error Message |
Error Condition |
|
All Required Fields |
The XXXXXXXXXXXX field must be entered. |
Not supplied in input file. |
|
Record Type |
Input File Line Type must be H or L |
Not H or L. |
|
Column(s) |
Error Message |
Error Condition |
|
Update Header |
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/Warehouse combination. |
|
Status Update ID |
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. |
|
Warehouse |
This is not a valid warehouse ID. |
Not null, and Warehouse does not exist (WHSE for your company). |
|
Employee |
This XXX does not exist or is inactive. |
Invalid or inactive Employee (EMPL for your company). |
|
PO ID |
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). |
|
Progress Payment Request |
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 draw request number. |
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). |
|
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)]. |
|
|
Status Update ID |
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. |
|
Column(s) |
Error Message |
Error Condition |
|
Update Line |
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/Warehouse combination. |
|
PO 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). |
|
Requested Work Amt |
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. |
|
Percent Complete |
Should be 0-100 % |
Value not 0 - 100. |
|
Completed Work Amt |
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 (PO_LN.TRN_COMPLT_AMT, PO_LN.TRN_PO_LN_EXT_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 Retention Pct |
Should be 0-100 % |
Value not 0 - 100. |
|
Completed Work Retention Amt |
This amount cannot be negative. |
Value < 0. |
|
Completed Work Retention 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 Retention Amt (PO_LN.TRN_COMPLT_RET_AMT, PO_LN.TRN_COMPLT_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. |
|
Stored Materials Amt |
This amount cannot be negative. |
Value < 0. |
|
Stored Materials Retention Pct |
Should be 0-100 % |
Value not 0 - 100. |
|
Stored Materials Retention Amt |
This amount cannot be negative. |
Value < 0 |
|
Stored Materials Retention Amt (PO_LN.TRN_STORED_RET_AMT, PO_LN.TRN_STORED_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" |
|
RECPT_HDR.VCHR_KEY |
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. |
|
PO_LN.TRN_COMPLT_AMT, PO_LN.TRN_STORED_AMT, PO_LN.TRN_PO_LN_EXT_AMT |
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_COMPLT_RET_AMT, PO_LN.TRN_STORED_RET_AMT, PO_LN.TRN_VCHRD_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. Previously Vouchered Ext Cost Amt = (Sum of VCHR_LN.TRN_EXT_CST_AMT + VCHR_LN_HS.TRN_EXT_CST_AMT) for matching PO/line]. |
|
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 |
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 line status = S, and subcontract status update modifies amounts so that either (PO_LN.TRN_STORED_AMT is not equal to zero) or [(PO_LN.TRN_COMPLT_AMT - TRN_COMPLT_RET_AMT) is not equal to PO_LN.TRN_PO_LN_EXT_AMT)], (for PO associated with your company) |
|
Requested Work 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). |
|
Completed 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 Retention Pct |
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 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 Pct |
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 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 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). |
|
Warehouse |
This is not a valid warehouse ID. |
Not null, and Warehouse does not exist (WHSE for your company). |