to select values from the appropriate table.Use this screen to update the Subcontractor Progress Payments table, which is used by projects that bill using form 1443, Contractor's Request for Progress Payment. This screen updates the Maintain Subcontractor Progress Payments screen (Projects » Billing » Billing History) with information from the Open Billing Detail file and the voucher and check history files. This process is executed at month-end to update subcontractor invoices that have been entered and paid through Costpoint Accounts Payable. This process is necessary because subcontractor costs are treated separately on the form 1443. When the progress payment bills are calculated, subcontractor costs are obtained from the Maintain Subcontractor Progress Payments screen instead of from Open Billing Detail, which is the source of all other transactions. Since form 1443 differentiates between paid and unpaid subcontractor costs, every organization billing progress payments must execute this process, regardless of status (large or small business). If this process is not used, the Maintain Subcontractor Progress Payments table must be maintained manually.
The process updates only projects that have a progress payment billing formula. It retrieves transactions from Open Billing Detail that have been identified as company-wide subcontractor accounts in the Maintain Billing Accounts screen. The voucher history files (VCHR_HDR_HS and VCHR_LN_ACCT_HS) are referenced for the selected transactions to obtain information such as the bill type, shipment value, and invoice amount. Payment information is added from the vendor check history files (VEND_CHK and VEND_CHK_VCHR). After the system updates the Maintain Subcontractor Progress Payments file, it deletes the transactions from Open Billing Detail. The Maintain Subcontractor Progress Payments file then becomes the source for line 14 and for delivery invoices billed on line 9 of the form 1443.
Run this screen after printing checks and accepting them for the period that you want to update. (Note that cash disbursements do not need to be posted before you run this process.) Run this screen before calculating progress payment bills.
In this group box, choose one project or a range of projects to be processed.
Enter, or use the drop-down list to select, the range of projects you want to update. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
The value entered in this field varies depending on the Range Option that you selected. If you selected All projects, this field is inactive. If you selected One project, enter the project in this field. If you elected to update a Range of projects, enter the starting project in this field. If you selected the From Beginning option, this field is inactive. If you selected the To End option, enter the beginning project in this field.
Use to select values from the appropriate table.
The value entered in this field varies depending on the Range Option that you selected. If you selected All projects or One project, this field is inactive. If you elected to update a Range of projects, enter the ending project in this field. If you selected the From Beginning option, enter the ending project in this field. If you selected the To End option, this field is inactive.
Use to select values from the appropriate table.
Use this group box to select the ending subperiod that you want to update. Note that all previous subperiods will be updated through the subperiod selected.
Enter, or use the drop-down list to select, a valid fiscal year that you want to update.
Enter, or use the drop-down list to select, a valid period that you want to update.
Enter, or use the drop-down list to select, a valid subperiod that you want to update. The field to the right displays the ending date for the selected subperiod.
When you have finished making your selections, click this icon on the toolbar to start the update process.
Changes to this screen update the SUBCTR_PRG_PMT table.