Use this screen to calculate your Costpoint billings, based on information you have set up in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). Once you have calculated billings, you can review them in the screens on the Edit Billings menu.
Refer to Billing Special Topic BL-3, "Calculate Billings," for more information.
Calculate billings after all transactions for the period to be billed have been posted. If you are using cash basis billing, be sure to run the Update Cash Basis Information screen (Projects » Billing » Prepare Billings) before you calculate billings. For system-calculated bills, you must calculate billings before you can edit, print, and post your bills.
Costpoint 6 now has four new tables to improve the processing performance of the Compute Revenue (Projects » Cost and Revenue Processing » Revenue Processing) and Calculate Billings (Projects » Billing » Calculate Billings) applications.
In this group box, select the fiscal year, period, and subperiod for which you would like to calculate billings. All records up to and including the fiscal year, period and subperiod entered here will be included in the process.
Enter, or use the drop-down list to select, the fiscal year for which you want to calculate billings.
Enter, or use the drop-down list to select, the accounting period for which you want to calculate billings.
Enter, or use the drop-down list to select, the subperiod for which you want to calculate billings. Costs posted to the general ledger up through the selected subperiod will be included in the billing calculations. Once you have made your selections, the field to the right will display the date for the selected subperiod
Use this group box to select the billing user groups to be included in the billing calculations. Billings will be calculated only for projects that have been assigned one of the selected billing user groups in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). This group box is disabled if the Assign Bills to User Groups check box in the Billing Settings screen (Projects » Billing » Controls) is not selected.
Use this drop-down list to select the range of billing user groups to be included in the billing calculations. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
Enter, or use to select, the starting billing user group code for the billing user groups to be included in the billing calculations. If you select All or From Beginning in the Range Option field, this field will be inactive.
Enter, or use to select, the ending billing user group code for the billing user groups to be included in the billing calculations. If you select All, One, or To End in the Range Option field, this field will be inactive.
Billings will be calculated only for the range of projects you specify in this group box.
Use this drop-down list to select the range of projects to be included in the billing calculations. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
Enter, or use to select, the starting project to be included in the billing calculations. If you select All or From Beginning in the Range Option field, this field will be inactive.
Enter, or use to select, the ending project to be included in the billing calculations. If you select All, One, or To End in the Range Option field, this field will be inactive.
Use this group box to select the billing cycle to be included in the billing calculations. Billings will be calculated only for projects that have been assigned one of the selected billing cycles in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). This group box is disabled if the Use Billing Cycles check box in the Billing Settings screen (Projects » Billing » Controls) is not selected.
Use this drop-down list to select the range of billing cycles to be included in the billing calculations. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
Enter, or use to select, the starting billing cycle code for the billing cycles to be included in the billing calculations. If you select All or From Beginning in the Range Option field, this field will be inactive.
Enter, or use to select, the ending billing cycle code for the billing cycles to be included in the billing calculations. If you select All, One, or To End in the Range Option field, this field will be inactive.
Enter an invoice date, or use the system date as the default. This date will display in the Invoice Date field of the Edit Standard Bills screen, where it can be edited. This date will also display in the header of the bill when it is printed.
Click this option to calculate invoices. All options on the screen will be available when you click this option. Calculated invoices will be available in the Edit Standard Bills screen (Projects » Billing » Edit Billings) after you run this process.
Select this option to calculate the billable value of transactions in Open Billing Detail. This enables you to analyze the amount that will be billable without regard to ceilings, retainages, sales taxes, scheduled items, or other charges. Only items that reside in Open Billing Detail will be considered when you use this option. No invoices will be produced. When you select this option, the Include in Process and Include group boxes are unavailable.
The system will create a report table named Z_BLPUBILL_RPT when you run this process. No standard report is available, so you will need a report writer to access the information in this table.
This option is available only when the Use Goal Multipliers for Billable Value Calculations check box is selected in the Project Settings screen (Projects » Project Setup » Controls). Select this option to compute the billable value of items in Open Billing Detail using multipliers. When you select this option, the Include in Process and Include group boxes are unavailable.
This process creates a report table called PROJ_GOAL_UNBILL. No standard report is available when you select this option, so you will need a report writer to access the information in this table.
Use this group box to select additional processes to be computed during the Calculate Billings process (Projects » Billing » Calculate Billings).
Select this check box to release all items on hold for the selected bills. To release only selected items, use the Adjustments in Open Billing Detail screen (Projects » Billing » Prepare Billings).
Select this checkbox to print retainage or over ceiling lines on your bills, even if the lines do not have any current amounts to bill for these items. Retainage or over ceiling lines with amounts other than zero always print on the bill if they have been formatted to do so. This option allows you to print the lines on the bill even if they are zero. This allows you to edit the over-ceiling and retainage amounts for the current billing amount. Over ceiling rows include over fee ceiling, over cost ceiling, and over total ceiling. You will typically use this option for billing over ceiling amounts after you have received additional funding, or during contract closeout for billing retainage.
Select this check box to print fee lines on your bills, even if the fee lines do not have a current amount to bill. Fee lines with amounts other than zero always print on the bill if they have been formatted to do so. This option allows you to print the fee lines on the bill even if they are zero. This allows you to edit the fee amounts for the current billing amount. Note that there must be a previously billed fee amount in order to create a zero fee row. A zero fee row cannot be created if there has been no fee recognized on a previous bill. You can use this option if you have an award fee billing.
Select this checkbox to print labor and non-labor discount lines on your bills, even if the discount lines do not have a current amount to bill. When calculating bills, the system creates zero discount rows so that, if the user edits the discount amounts on the bill, the detail bills will equal the total invoice amount due.
Use this group box to customize the data that is calculated on your billings.
Select this check box to calculate only those bills that have current activity. If this check box is selected, only those bills that have transactions in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings) will be calculated. This will save processing time because Costpoint will not calculate bills for which there is no current activity. Note that if a project ceiling level has been increased, the bill should be calculated even though there have not been any new transactions posted to the project. This will ensure that any "amounts in excess" from previous bills will be billed, up to the new ceiling.
Select this check box to include T&M transactions with a zero billing rate. This can be helpful in identifying missing billing rates.
Select this check box to include transactions with a zero cost amount.
Select this check box to include transactions with a zero unit quantity amount.
After you have selected your parameters for billings to be calculated, click to start the billing calculation process.
If you are using discount functionality, the system follows these general rules when calculating bills:
Burdens apply to the amount BEFORE discount.
Discounts apply to the direct cost amounts (or direct cost amounts including burden on the w/burden discount methods).
Fee applies to the total AFTER discount.
Sales Tax applies to the amount AFTER discount.
Retainage applies AFTER discount.
Ceilings:
Account Ceilings are enforced BEFORE discounts are applied.
Project Total Ceilings are enforced AFTER discounts are applied.
OPEN_BILLING_DETL
PROJ_BILL_INFO
ACCT_DISC
CUST_VOLUME_DISC
PROJ_VOLUME_DISC
PROJ_INVC_PROJ
PROJ_HIERARCHY
Changes to this screen update the following tables:
BILL_EDIT_DETL
BILL_EDIT_INVC_HDR
PROJ_GOAL_UNBILLED