Use this screen to calculate progress payment bills for organizations that use government form 1443, Contractor's Request for Progress Payment. This process generates bills that you can review and edit in the Edit Progress Payment Bills screen before printing and posting them. You must set up projects in the Project Billing Information screen (Projects\Maintain\Billing) with the "Progress Payment" formula before they can be calculated in this screen.
|
|
Note: This process is separate from the calculation of all other types of bills, which is done in the Calculate Bills screen (Projects\Process\Billing). |
Transactions must meet the following validations before they can be included on a Progress Payment bill:
They must be posted to the general ledger and included in the Open Billing Detail file.
Subcontractor transactions must be included in the Subcontractor Progress Payments file via the Update Subcontractor Progress Payments screen. If the organization sending the bill is considered "large business," accounts payable transactions must have been paid for before they are eligible to be billed. Before calculating progress payment bills, use the Update Cash Basis Bills screen (Projects\Process\Billing) to update this payment information for your accounts payable transactions.
If the Limit Transactions to Period of Performance checkbox has been selected in the Other Info subtask of the Project Billing Information screen (Projects\Maintain\Billing), the subperiod in which the transactions have been posted must be within the project start and end dates entered in the Enter Project Modifications screen (Projects\Transactions\Project\Enter Project Modifications).
If you have hours-based pools and you are billing subcontractor progress payment delivery invoices, you must have entered the delivery hours in the Subcontractor Progress Payments (Projects\Configure\Billing History) screen.
Execute the Update Subcontractor Progress Payments screen before you calculate progress payment bills. If your organization is considered "large business," you must also run the Update Cash Basis Bills screen (Projects\Process\Billing).
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this group box to select the periods that you want to include in the calculation. You can limit the bills that will be included in the calculation by project, bill group, or billing cycle.
Subperiod *
This non-editable field displays "One." This field is non-editable because you can calculate for only one ending subperiod. All bills in the Edit Progress Payment Bills screen (Projects\Transactions\Billing) that have a subperiod up to and including the subperiod entered in this field will be included in the calculation.
Enter, or use the Lookup to select, the fiscal year for which you want to calculate billings.
Enter, or use Lookup to select, the period for which you want to calculate billings.
Enter, or use Lookup to select, the subperiod for which you want to calculate billings. Once you have made your selections, the field to the right displays the ending date for the subperiod selected.
Once you have selected the Subpd, this field displays the ending date for the subperiod selected.
Projects *
Use this drop-down box to select the project range that you want to include in the process. The following options are available:
All - Select this option to include all available projects. The Start and End fields are disabled for this option.
One - Select this option to include only one project. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of projects. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the projects from the beginning of the available projects to a specific project in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the projects from a specific project to the end of all the available projects. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the beginning project for which you want to calculate progress payment bills. The system will calculate only those bills that have a project number falling within the range entered in the Start and End fields.
Enter, or use Lookup to select, the ending project that you want to include in the range. The system will calculate only those bills that have a project number that falls within the range entered in the Start and End fields.
Bill Groups *
Use this drop-down box to select the bill group range that you want to include in the process. The following options are available:
All - Select this option to include all available bill groups. The Start and End fields are disabled for this option.
One - Select this option to include only one bill group. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of bill groups. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the bill groups from the beginning of the available bill groups to a specific bill group in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the bill groups from a specific bill group to the end of all the available bill groups. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
|
|
Note: You can set up bill cycles in the Billing User Groups screen. After you have established billing user groups to can assign the billing user groups to individual projects in the Project Billing Information screen. |
Enter, or use Lookup to select, the beginning bill group for which you want to calculate progress payment bills.
The system will only calculate the bills that have a bill group falling within the range entered in the Start and End fields.
Enter, or use Lookup to select, the ending bill group that you want to include in the range. The system will calculate only those bills that have a bill group that falls within the range entered in the Start and End fields.
Billing Cycles *
Use this drop-down box to select the billing cycles range that you want to include in the process. The following options are available:
All - Select this option to include all available billing cycles. The Start and End fields are disabled for this option.
One - Select this option to include only one billing cycle. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of billing cycles. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the billing cycles from the beginning of the available bill cycles to a specific bill cycle in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the billing cycles from a specific bill cycle to the end of all the available bill cycles. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
|
|
Note: You can set up bill cycles in the Billing Cycles screen. After you have established billing cycles to can assign the billing cycles to individual projects in the Project Billing Information screen. |
Enter, or use Lookup to select, the beginning billing cycle for which you want to calculate progress payment bills. The system will calculate only those bills that have a billing cycle falling within the range entered in the Start and End fields.
Enter, or use Lookup to select, the ending billing cycles that you want to include in the range. The system will calculate only those bills that have a billing cycles that falls within the range entered in the Start and End fields.
Use the fields in this group box to enter an invoice date, select a rate type, and select an option for current period activity only.
Enter, or use Calendar Lookup to select, the invoice date to be used on the bill. The system date will automatically display as the default.
This date will display in the 8B. Date of This Request field in the Section I - Identification Information subtask of the Edit Progress Payment Bills screen (Projects\Transactions\Billing). This date can be edited and will print on the progress payment bill in box 8B of the header.
Select this checkbox to calculate for only those bills that have current activity.
If this checkbox is selected, only those bills that have transactions in the Open Billing Detail screen (Projects\Maintain\Billing) or the Subcontractor Progress Payments screen (Projects\Configure\Billing History) will be calculated. This will save processing time because the system will not calculate bills for which there is no current activity.
Select the appropriate burden rate type, "Actual" or "Target," that will be used in the calculation of line 12a, Total Costs Incurred To Date.
* A red asterisk denotes a required field.
Changes to this screen update the following tables:
PRG_PMT_EDIT_HDR (Progress Payment Edit Header)
PRG_PMT_EDIT_DETL (Progress Payment Edit Detail)
