Progress Payment Requests (tppin0170m000)
Use this session to create and maintain the progress payment requests for a contract.
- LN prints the Contract code, Task or Delivery Order Number (4b), Progress Payment Request Number (8a) (only if the progress payment request is transferred to Invoicing), and the Invoice Date (only if an invoice exists) on the report.
- When processed in Invoicing, the Contract, Revenue Code, Project, Activity, Element, and Invoicing Method (revenue type) data is posted to the Revenue Transactions (tpppc3505m000) session.
- LN updates the progress payment request number when the progress payment invoice is printed.
- The value in the Invoice Document and the Invoice Date fields is updated when the progress payment request is invoiced.
- Progress Payment Requests are made using the funds allocated for the contract line, as specified in the Funding Distribution (tpctm0170m000) session.
- If the Billable Cost Report check box is selected in the Contract Lines (tpctm1110m000) session, Invoicing prints the billable cost lines and the related costs as an annex to the invoice taking into account the aggregation of the Invoicing Method.
Field Information
- Contract
-
The contract linked to the progress payment request.
- Description
-
The description or name of the code.
- Status
-
The Contract Line Status of the contract linked to the progress payment request.
- Contract Line
-
The contract line linked to the progress payment request.
- Description
-
The description or name of the code.
- Progress Date
-
The reference date used to save the progress payment requests related transaction data before invoicing.
Note: This value is defaulted from the Create Progress Payment Requests (tppin0270m000) session. - Agreement
-
- Invoice-to Business Partner
-
The invoice-to business partner linked to the progress payment request, defaulted from the Contract Lines (tpctm1110m000) session. This is a display field.
- Invoice-to Address
-
The address of the invoice-to business partner defaulted from the Contract Lines (tpctm1110m000) session..
- External Address Code
-
The external code of the invoice-to address defaulted from the Contract Lines (tpctm1110m000) session.
- Contracting Officer
-
The contact linked to the invoice-to business partner for the progress payment request.
- Description
-
The description or name of the code.
- Phone
-
The phone number for the invoice-to business partner.
- External Sales Representative
-
The name of the employee who is the external sales representative for the progress payment request, defined in the Employees - General (tccom0101m000) session.
- Description
-
The description or name of the code.
- Project
-
The project linked to the progress payment request.
Note: LN defaults the project linked to the contract line. - Description
-
The description or name of the code.
- Element
-
The element linked to the progress payment request.
- Description
-
The description or name of the code.
- Activity
-
The activity linked to the progress payment request.
- Description
-
The description or name of the code.
- Invoicing
-
- Revenue Code
-
The default revenue code defined for the progress payment request in the Project Parameters (tppdm0100s000) session.
- Description
-
The description or name of the code.
- Invoicing Method
-
The invoicing method for the progress payment request, defaulted from the Contract Lines (tpctm1110m000) session.
- Description
-
The description or name of the code.
- Payment Terms
-
The payment terms for the progress payment request, defaulted from the Contract Lines (tpctm1110m000) session.
- Description
-
The description or name of the code.
- Payment Method
-
The payment method for the progress payment request, defaulted from the Contract Lines (tpctm1110m000) session.
- Description
-
The description or name of the code.
- Billing Cycle
-
The billing cycle for the progress payment request, defaulted from the Contract Lines (tpctm1110m000) session.
- Description
-
The description or name of the code.
- Billing Cycle Invoice Date
-
The date of invoicing for the billing cycle of the progress payment request.
- Payment Amount Settled
-
The amount paid to settle the progress payment request.
- Amount of current Invoice (26)
-
The amount in the current invoice for the progress payment request.
- Currency
-
The currency used to express the amount for current invoice.
- Section I
-
- Small Business (3)
-
If this check box is selected, the contract is linked to a small business.
Note: LN selects this check box only if the Small Business check box is selected in the Contract Parameters (tpctm0100m000) session . - Contract Number (4a)
-
The customer order number specified on the contract line linked to the progress payment request. LN defaults this value to the Revenue Transactions (tpppc3505m000) session.
- Task or Delivery Order Number (4b)
-
The task or delivery order number for the progress payment request.
- Contract Price (5)
-
The contract line amount defaulted from the Contract Lines (tpctm1110m000) session, expressed in USD. This is a display field.
Note: LN defaults the value from the contract line. - Progress Payment (6a)
-
The progress payment percentage specified on the contract line.
- Liquidation (6b)
-
The liquidation percentage specified for the progress payment request on the contract line.
- Contract Award Date (7)
-
The date when the contract is awarded. This date is defaulted from the contract line.
- Invoice Document Company
-
The financial company specified on the invoice document for the project linked to the progress payment request.
Note: This field is populated with the company in which invoice is created for the progress payment request line, when you post the invoice. - Invoice Document Transaction Type
-
The transaction type specified on the invoice document for the project linked to the progress payment request.
Note: This field is populated with the transaction type of the invoice related to the progress payment request line, when you post the invoice. - Invoice Document Number
-
The sequence number of the invoice document.
Note:- This field is populated with the invoice number of the related progress payment request line, when you post the invoice.
- LN updates this value with the number of the new invoice that is created when you cancel and regenerate the invoice, in Invoicing . When you cancel the invoice, you can only modify the invoice data such as reference, address, and tax number, if required.
- You can also modify the Invoice Amount when you create a credit note for a specific invoice line.
- LN updates this value with the number of the new invoice that is created when you cancel and regenerate the invoice, in Invoicing.
- When you cancel the invoice, you can modify the invoice data such as reference, address, and tax number. However, you can also modify the Billable Amount if you create a credit note for a specific invoice line. Only the authorized users (in Invoicing) can modify the amount.
- The invoice must not be linked to an installment.
- The status of the project must be not be Closed.
- Progress Payment Request Number (8a)
-
The number used to identify the progress payment request.
- Date of this Request (8b)
-
The date when the progress payment request is created.
Note:- This field is populated with the date when the invoice is created for the fee or penalty line, when you post the invoice.
- LN updates this field with the date when the new invoice is created by cancelling the related invoice, in Invoicing . When you cancel the invoice, you can only modify the invoice data such as reference, address, and tax number.
- You can also modify the Invoice Amount when you create a credit note for a specific invoice line, such as manual sales invoice.
- LN updates the value in this field, when the invoice is cancelled and regenerated, in Invoicing. When you cancel the invoice, you can modify the invoice data such as reference, address, and tax number. However, you can also modify the Billable Amount, if you create a credit note for a specific invoice line. Only the authorized users (in Invoicing) can modify the amount.
- Status
-
- Approved for Invoicing
-
LN selects this check box to indicate that the progress payment request is approved for invoicing.
Note: LN selects this check box when you approve the progress payment request line, using the Approve option. - Transferred to Invoicing
-
LN selects this check box when you transfer the approved progress payment request line to Invoicing, using the Transfer option.
Note: LN clears this check box when you cancel and delete the billable line of the invoice related to the progress payment request line in Invoicing . - Payment Request Settled
-
LN selects this check box to indicate that the progress payment request is settled.
- Section II and III
-
- Reserved (9)
-
The costs that are paid for the progress invoice.
Note: This field is disabled if the Small Business (3) check box is selected. - Reserved (10)
-
The costs that are incurred for the progress payment request.
- Costs Eligible (11)
-
The cost amount based on which the progress payment request can be created.
- Total Contract Costs to Date (12a)
-
The total cost incurred to date for the contract. The value is defaulted based on the total billable costs for the contract.
- Estimated Cost to Complete (12b)
-
The total estimate-to-complete cost for the project linked to the progress payment request.
Note: Overhead cost forecasts are also included when calculating the Estimated to Complete (ETC) cost. - Total Estimated Cost of Performance (12c)
-
The total estimated cost of performance calculated using the following formula:
Total Estimated Cost of Performance = Total contract costs incurred to date + Estimated Cost to Complete
- Item 11 multiplied by Progress Payment % (13)
-
This value is calculated using the formula:
Total eligible costs * Progress Payments %
- Financing Payments paid to Subcontractors (14a)
-
The financing amount paid to the subcontractors linked to the contract.
- Liquidated Financing Payments paid to Subcontractors (14b)
-
The liquidated financing payments paid to the subcontractors linked to the contract.
- Unliquidated Financing Payments paid to Subcontractors (14c)
-
The unliquidated financing payments paid to the subcontractors linked to the contract.
Unliquidated Financing Payments to Subcontractor = Financing Payments paid to Subcontractors - Liquidated Financing Payments paid to Subcontractors
- Subcontract Financing Payments for current Payment (14d)
-
The subcontract financing payment for the current payment.
Note: This value is zero if the Small Business (3) check box is cleared. - Eligible Subcontractor Financing Payments (20d)
-
The eligible subcontractor financing payments can be calculated using the formula:
Eligible Subcontractor Financing Payments = Unliquidated Financing Payments to Subcontractor + Subcontract financing payments approved for current payment
- Total Amount (15)
-
The total amount expressed in USD that is calculated using the formula:
Total Amount = (Total eligible costs * Progress Payments %) + Eligible Subcontractor Financing Payments
- Contract Price multiplied by Liquidation Rate (16)
-
This value can be calculated using the formula:
Contract Price in USD * Liquidation %
- Lesser of item 15 or item 16 (17)
-
LN displays the amount that is lesser; the Total Amount (15) or the Contract Price multiplied by Liquidation Rate (16).
- Total Amount of previous Progress Payments (18)
-
The total of the invoiced amount for the previous progress payment requests created for the contract.
- Maximum Balance Eligible (19)
-
The maximum balance for which the progress payment request is created that can be calculated using the formula:
Total Amount of previous Progress Payments - Lesser of Total Amount or Contract Price multiplied by Liquidation Rate
- Section III
-
- Costs for delivered Items (20a)
-
The cost of the contract deliverables.
Note: This field is enabled if the status of at least one or more contract deliverables linked to the contract is set to Delivered.Note
Note Data must be specified in Section III, only if the contractor receives advance payments against the contract, or if the items are delivered, invoiced, and approved on or before the Progress Date specified in Section II. Also, the amount for all progress payment requests must be approved (as specified in the Amount approved by Contracting Officer (27) field), when the Total Estimated Cost of Performance (12c) amount exceeds the Contract Price (5) amount.
- Costs for undelivered Items (20b)
-
The cost of undelivered items.
Cost of undelivered items = Costs for delivered Items - Costs Eligible
- Item 20b multiplied by Progress Payment % (20c)
-
This value is calculated using the formula:
Costs for undelivered Items * Progress Payment %
- Limitation (20e)
-
This value is calculated using the formula:
Limitation = (Costs for undelivered Items * Progress Payment %) + Eligible subcontractor progress payments
- Costs included in 11 for delivered Items (21a)
-
The price including the cost for the items delivered and invoiced to date.
Note: This field is enabled if the status of at least one or more contract deliverables linked to the contract is set to Delivered. - Costs eligible for undelivered Items (21b)
-
This value is calculated using the formula:
Costs eligible for undelivered Items = Costs included in 11 for delivered Items - Costs Eligible
- Item 21b multiplied by Liquidation Rate (21c)
-
This value is calculated using the formula:
Costs eligible for undelivered Items * Liquidation %
- Unliquidated Advance Payments plus accrued Interest (21d)
-
The value is defaulted based on the total unliquidated and the accrued interest for the contract line, linked to the progress payment request. The unliquidated advance payments plus accrued interest is calculated using the formula:
Unliquidated Advance Payments = Advance Payment - sum of settled Advance Payment (Unliquidated Advance Payments + accrued Interest) = Unliquidated Financing Payments to Subcontractor + Subcontract financing payments approved for current payment
- Limitation (21e)
-
This value is calculated using the formula:
Limitation = (Costs eligible for undelivered Items * Liquidation %) + (Unliquidated Advance Payments + accrued Interest)
- Maximum unliquidated Progress Payments (22)
-
LN displays the amount that is lesser; the Limitation (20e) or the Limitation (21e).
- Total Amount liquidated and to be liquidated (23)
-
The total amount that is liquidated and that is yet to be liquidated.
- Unliquidated Progress Payments (24)
-
This value is calculated using the formula:
Unliquidated Progress Payments = Total Amount liquidated and to be liquidated - Total Amount of previous Progress Payments
- Maximum permissible Progress Payments (25)
-
The maximum amount for which LN allows progress payments to be created.
Maximum permissible Progress Payments = Unliquidated Progress Payments - Maximum unliquidated Progress Payments
- Amount approved by Contracting Officer (27)
-
The amount approved by contracting officer defaulted based on the amount for current invoice for the progress payment. LN allows you to modify this value only to a value less than the defaulted value.
- Tax
-
- Tax Classification
-
The tax classification for the progress payment request, defined in the Tax Classifications (tctax0116m000) session.
- Exempt
-
If this check box is selected, the tax is exempted for the progress payment request.
Note: The tax exemption check is performed for all the financial companies linked to the current logistic company. - Tax Country
-
The tax country for the progress payment request.
- Tax State/Province
-
The state/province of the tax country for which the tax and registration data is displayed.
- Tax Code
-
The tax code defined in the Tax Codes by Country (tcmcs0536m000) session for the progress payment request.
- Identification Number
-
The tax number of the company.
Note:- This is a display field.
- LN populates this value based on the:
- The Financial company that is linked to the Sales Office of the contract line.
- The Tax country linked to the contract line.
- The Reference date from which the tax is applicable. Usually, the invoice date is considered as the reference date.
- Legal Name
-
The name linked to the registration ID which can be used on the legal reports.
- Exemption Certificate
-
The tax exemption certificate number if tax is exempted for the progress payment request.
Note:You can specify the tax exemption certificate number if the Exempt check box is selected.
You can view this field if in the Tax Parameters (tctax0100m000) session:
- the Tax Exempt Level field is set to Extended and
- at least one of the search sequence levels is set to Exemptions by Country or Exemptions by Country Set.
- Exemption Reason
-
The code that identifies the reason if tax is exempted for the progress payment request.
Note:You can enter the tax exemption reason if the Exempt check box is selected.
You can view this field if in the Tax Parameters (tctax0100m000) session:
- the Tax Exempt Level field is set to Extended and
- at least one of the search sequence levels is set to Exemptions by Country or Exemptions by Country Set.
- Tax and Registration Data Complete
-
Indicates whether the tax and registration data generation process is completed for the progress payment request.
- Tax Country
-
The tax country of the sold-to business partner for the progress payment request.
- Tax State/Province
-
The code of the state/province to which the sold-to business partner is linked.
- Identification Number
-
The tax number allotted by the government to the sold-to business partner.
- Legal Name
-
The name linked to the registration ID of the sold-to business partner that can be used on the legal reports.
- Description
-
The description or name of the code.
- Name
-
The description or name of the code.