Options Tab

Use this tab to select parameters for calculating standard bills.

Selection Ranges

Use this block to limit standard bills that are calculated.

Accounting Period

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 are included in the process.

Field Description
Option

This field always displays One.

Fiscal Year

Enter, or click the to select, the fiscal year for which you want to calculate billings.

Period

Enter, or click the to select, the accounting period for which you want to calculate billings.

Subpd

Enter, or click the to select, the subperiod for which you want to calculate billings. Costs posted to the general ledger up through the selected subperiod are included in the billing calculations.

Ending Date

After you make your selection in the Fiscal Year, Period, and Subpd fields, this field displays the date for the selected subperiod.

Note: For modifications, Costpoint looks at both the modification effective date and subperiod ending date when computing bills. Only those modifications with an effective date earlier than or equal to the subperiod ending date will be included in the total modification amounts (total value, cost, and fee amounts). This is to prevent these amounts from being released early in case future funding modifications are entered.

Projects

Billings are calculated only for the range of projects you specify here.

Field Description
Option

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 One.

Start

Enter, or click to select, the starting project to be included in the billing calculations. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending project to be included in the billing calculations. If you select All, One, or To End in the Option field, this field is inactive.

Bill Groups

Use these fields to select the billing user groups to be included in the billing calculations. Billings are calculated only for projects that have been assigned one of the selected billing user groups on the Manage Project Billing Information screen. This group box is disabled if the Assign Bills to User Groups check box on the Configure Billing Settings screen is not selected.

Field Description
Option

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.

Start

Enter, or click 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 Option field, this field is inactive.

End

Enter, or click 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 Option field, this field is inactive.

Billing Cycles

Use these fields to select the billing cycle to be included in the billing calculations. Billings are calculated only for projects that have been assigned one of the selected billing cycles on the Manage Project Billing Information screen. This group box is disabled if the Use Billing Cycles check box on the Configure Billing Settings screen is not selected.

Field Description
Option

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.

Start

Enter, or click 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 Option field, this field is inactive.

End

Enter, or click 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 Option field, this field is inactive.

Options

Use this block to select options for calculating standard bills.

Calculate

Field Description
Billings

Select this option to calculate invoices. All options on the screen are available when you select this option. Calculated invoices are available on the Manage Standard Bills screen after you run this process.

Billable Value on Open Transactions

Select this option to calculate the billable value of transactions in Open Billing Detail. This enables you to analyze the amount that is billable without regard to ceilings, retainages, sales taxes, scheduled items, or other charges. Only items that reside in Open Billing Detail are considered when you use this option. No invoices are produced. When you select this option, the Include in Process and Include group boxes are unavailable.

Costpoint creates a report table named Z_BLPUBILL_RPT when you run this process. No standard report is available, so you need a report writer to access the information in this table.  

Billable Value on Unbilled Transactions

This option is available only when the Use Goal Multipliers for Billable Value Calculations check box is selected on the Projects tab of the Configure Project Settings screen. Select this option to compute the billable value of items in Open Billing Detail using multipliers. When you select this option, the Processing Options 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 need a report writer to access the information in this table. 

Invoice Date

Enter, or click to select, an invoice date, or use the system date as the default. This date displays in the Invoice Date field of the Manage Standard Bills screen, where it can be edited. This date also displays in the header of the bill when it is printed.

Include

Use this group box to customize the data that is calculated on your billings.

Field Description
Current Activity Only

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 on the Manage Open Billing Detail screen are calculated. This saves processing time because Costpoint does 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 ensures that any "amounts in excess" from previous bills are billed, up to the new ceiling.

Transactions with Zero Bill Rate

Select this check box to include T&M transactions with a zero billing rate. This can be helpful in identifying missing billing rates.

Transactions with Zero Cost Amount

Select this check box to include transactions with a zero cost amount.

Transactions with Zero Units Quantity

Select this check box to include transactions with a zero unit quantity amount.

Projects with "Final Billing Completed" checked

Select this check box to include projects that are marked as "final billed" (that is, the Final Billing Completed check box is selected on the Manage Project Billing Information screen for these projects).

Processing Options

Use this group box to select additional processes to be computed during the Calculate Billings process.

Field Description
Auto-Release On-Hold Items

When you select this check box, Costpoint will move the amounts/hours/units on hold for the selected bills to the amounts/hours/units to be billed when the Release Date specified on the Manage Open Billing Detail screen is prior to or equal to the subperiod end date of the billing calculation. After moving the values, Costpoint clears the Release Date field.

All release dates subsequent to the subperiod end date of the billing calculation will be left in effect and the values will remain on hold.

If the items on hold for the selected bills have a blank Release Date, Costpoint will release all these items when you select the Auto-Release On-Hold Items check box.

To release only selected items, use the Adjust Open Billing Detail Records screen.

Create Zero Retainage and Over-Ceiling Rows

Select this check box 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 typically use this option for billing over ceiling amounts after you have received additional funding, or during contract closeout for billing retainage.

Create Zero Fee Rows

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.

Create Zero Discount Rows

Select this check box 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, Costpoint creates zero discount rows so that, if a user edits the discount amounts on the bill, the detail bills equal the total invoice amount due.

Note: Costpoint creates new rows only for projects that have a Discount Method selected on the Manage Project Billing Information screen.
Create Zero Withholding Row

Select this check box to create a zero withholding row.

Create Zero Withholding Release Row

Select this check box to create a zero withholding release row.

If you select either the Create Zero Withholding Row or the Create Zero Withholding Release Row check box, Costpoint creates a row on the bill for withholding release if:

  • The calculated amount is zero and ITD totals are not being printed on the bill per the billing format setup, or
  • The current amount and ITD amount are both zero, and the Subject to Withholding check box is selected for the billing project ID on the Global Withholding tab of the Manage Project Billing Information screen (PROJ_BILL_INFO table). (The zero row is not added for projects that are not subject to withholding.)

Consolidated Standard/Retro Billing Options

Use this group box to select options in including standard and/or retroactive bills in the billing calculations. The options in this group box are enabled only if you select the Allow Consolidated Standard/Retroactive Bills check box on the Configure Billing Settings screen.

Select Retroactive Bill Calculation Type

Field Description
None

This is the default selection. You can retain this default if you do not want to include retroactive bills in the computation.

Indirect costs

Select this option to calculate retroactive bills that apply provisional indirect cost rates to direct cost amounts.

Indirect Costs Retroactive Billing Options

The options in this group box are enabled only if you select the Indirect costs calculation type.

Include Current Fiscal Year

Select this check box to include bills from the current fiscal year in the billing calculations. When you select this check box, the Fiscal Year and Period For Rates fields adjacent to it become enabled.

Field Description
Fiscal Year

This defaults to the fiscal year entered in the Fiscal Year field in the Accounting Period group box.

Period For Rates

Enter, or click to select, the current fiscal year period for rates. This period must not be greater than the period entered in the Period field in the Accounting Period group box.

Period From

Enter, or click to select, the starting current fiscal year period to be included in the billing calculations.

Period To

Enter, or click to select, the ending current fiscal year period to be included in the billing calculations.

Note: The Period From and Period To fields are only shown when the Current Period Rates option is selected on the Corporate Settings subtask of Configure Project Settings.

Include One Prior Fiscal Year

Select this check box to include bills from a prior fiscal year in the billing calculations. When you select this check box, the Fiscal Year and Period For Rates fields adjacent to it become enabled.

Field Description
Fiscal Year

Enter, or click to select, the prior fiscal year.

Period For Rates

Enter, or click to select, the prior fiscal year period for rates.

Period From

Enter, or click to select, the starting prior fiscal year period to be included in the billing calculations.

Period To

Enter, or click to select, the ending prior fiscal year period to be included in the billing calculations.

Note: The Period From and Period To fields are only shown when the Current Period Rates option is selected on the Corporate Settings subtask of Configure Project Settings.
Include Multiple Prior Fiscal Years (see 'Retro Billing Indirect Costs Fiscal Years' subtask)

Select this check box to include bills from multiple prior fiscal years in the billing calculations. To specify the fiscal years to include, go to the Retro Billing Indirect Costs Fiscal Years subtask.

Note: You must clear the Include One Prior Fiscal Year check box before selecting this check box.
Calculate

After you have selected your parameters for billings to be calculated, click to start the billing calculation process.

If you are using discount functionality, Costpoint follows these general rules when calculating bills:

  1. Burdens apply to the amount BEFORE discount.
  2. Discounts apply to the direct cost amounts (or direct cost amounts including burden on the w/burden discount methods).
  3. Fee applies to the total AFTER discount.
  4. Sales Tax applies to the amount AFTER discount.
  5. Retainage applies AFTER discount.

Ceilings:

  • Account Ceilings are enforced BEFORE discounts are applied.
  • Project Total Ceilings are enforced AFTER discounts are applied.