Progress Payment Processing

Processing progress payments involves the following processes:

  • Calculate Inception to Date Costs process.

  • Contracts Billing Interface process.

  • Progress Payment Liquidation process.

Calculate Inception to Date Costs (Calculate ITD Costs process)

To calculate allowable progress payment request amounts based on the projects and activities costs tracked in Project Transactions, you must first run the Calculate ITD Costs (CA_PGP_CALC) process. This batch process retrieves the current inception to date and estimated cost to complete costs from the Project Transactions (PROJ_RESOURCE) table for projects and activities associated to the progress payment terms, then inserts the resulting rows into the Progress Payment Costs (CA_PGP_COSTS) table. Any rows (associated with the same As of Date) that already exist in the table are updated and overwritten by the process. After the process is complete, you can copy the costs data from the Progress Payment Costs table into the various fields in the progress payment worksheet.

See Accumulate Progress Payments Costs Page.

Contracts Billing Interface Process

The Contracts/Billing Interface process (CA_BI_INTFC) is used to populate the billing interface tables and generate bills for contracts. For progress payment processing, this process is used to process progress payment requests and liquidation through to PeopleSoft Billing.

Progress payment request bills are controlled by the immediate billing plan associated with the progress payment worksheet. The Contacts/Billing Interface processes progress payments that are associated with progress payment terms with a Ready status, have an immediate billing plan associated to the progress payment worksheet in Ready status, and the contract is in Active processing status. If all of these conditions are met, the Contracts/Billing Interface process performs the following actions:

  • Creates a bill line type of REV.

  • Updates the billing plan status for the immediate bill plan to In Progress.

  • Inserts a row into the Contracts/Billing Plan Cross-Reference (CA_BP_XREF) table.

    Each row inserted into the Contracts/Billing Plan Cross-Reference table inherits the sequence number (CA_PGP_SEQ) associated with the progress payment terms to uniquely identify that row as a progress payment request row for a specific set of progress payment terms.

After the bills are finalized in PeopleSoft Billing, you must run the Billing to Project Costing/Contracts Interface process (BIPCC000) to update the bill row in the billing plan history page to a status of FIN (finalized) and update the progress payment amount and unliquidated amount to include the finalized progress payment request amount.

WARNING:

The Billing to Project Costing/Contracts Interface process updates the progress payment tables and fields with the original progress payment amounts that are sent to PeopleSoft Billing. Any manual adjustments made in PeopleSoft Billing for these amounts are ignored by the system and can cause the applications to be out of sync. It is strongly recommended that any required adjustments are made in PeopleSoft Contracts.

See Managing Progress Payments.

Progress Payment Liquidation process

Progress payment liquidation is triggered by the processing of billing plans for amount-based contract lines that are associated with progress payment terms. After the Contracts/Billing Interface process selects contract line amounts for bill processing, but prior to passing the billing data to PeopleSoft Billing, the Progress Payment Liquidation process (CA_PGP_LIQ) is called. This process liquidates eligible progress payment amounts against bills for contract line items that are delivered.

The Progress Payment Liquidation process only liquidates progress payment amounts if the progress payment terms are defined and have a status of Ready, the contract processing status is active, and the progress payment amount has not been fully liquidated.

The Progress Payment Liquidation process performs the following actions:

  • Creates a bill line type of UTL.

  • Creates a negative bill line amount that is passed as a credit to PeopleSoft Billing.

  • Calculates the liquidation amount.

  • Updates the committed amount with the amount to be liquidated.

  • Inserts a row in the Contracts/Billing Plan Cross-Reference (CA_BP_XREF) table for the contract's line liquidated billing plan reflecting the credit sent to PeopleSoft Billing.

    Each row inserted into the Contracts/Billing Plan Cross-Reference table inherits the sequence number associated with the progress payment terms to uniquely identify that row as a progress payment liquidation row for a specific set of progress payment terms.

After the bills are finalized in PeopleSoft Billing, you must run the PeopleSoft Billing to Project Costing/Contracts Interface process to relieve the committed amount, update the unliquidated amount accordingly and update the row status in the Contracts Billing Cross reference table to Finalized (FIN) status.

Note:

Progress payment requests must be finalized to be eligible for liquidation.