to select, the starting value for the
range you want to include. If you select All
or From Beginning in the Range Option field,
this field will be inactive. Use this screen to populate the Open Billing Detail and/or the Labor History table with appropriate billing rate information. There are many ways to link a billing rate to a project in Costpoint. Multiple tables accommodate this. You can set up and maintain Project Labor Categories (PLCs) and their associated billing rates in the Project Labor menu of Costpoint Project Setup. The Load Labor Rates process uses the Define T&M rate Sequence table to determine which billing rate table to use for a project. The process evaluates the effective date in Labor History and Open Billing Detail and compares it to the start and end dates in the rate tables to determine the proper billing rates. Once the proper rates have been found, the billing rates are copied into the Labor History table and/or the Open Billing Detail table.
If the Use Goal Multipliers for Billable Value Calculations check box is selected in the Project Settings screen (Projects » Project Setup » Controls), this program will perform additional steps. Currently, this program uses the Define Rate Sequence screen (Projects » Project Setup » Revenue Setup) to assign billing rates to Labor History and Open Billing Detail for hourly base projects. Hourly based projects are those projects billed out using loaded labor rates. For these projects, Costpoint loads the billing rate into the REV_RT_AMT column of LAB_HS (Labor History), and the BILL_RT_AMT column of OPEN_BILLING_DETL.
If you want to compute and report Billing Value, a value is required in the REV_RT_AMT column of the LAB_HS (Labor History) table for all labor hours incurred. For hourly based projects, this field will be computed as previously outlined. For all other projects (CPFF, CPFH, Units based, Cost Time Multiplier), the actual hourly rate will be loaded into the REV_RT_AMT column of LAB_HS (Labor History). The allowable hours column (ALLOW_REV_HRS) will be set equal to the actual hours worked. The rate type column (S_BILL_RT_TYPE_CD) of LAB_HS (Labor History) will be set to the appropriate rate type (A (Actual), B (Billing), C (Ceiling)). These types of projects bill labor hours at the hourly payroll rate, rather than a loaded billing rate.
The Revenue and Billing calculation programs use the billing rate stored in Labor History and Open Billing Detail, respectively, as the basis for revenue and billing amounts on projects with T&M or Loaded Labor formulas. Therefore, you must run this program before computing revenue or billings. You should also initialize PLC billing rates by project before running this program. In addition to using revenue and billing programs, the Billing Value report also uses the billing rate stored in Labor History as the basis for deriving the billing value of costs incurred.
Only those records that have a fiscal year, period and subperiod equal to the Fiscal Year, Period, and Subperiod entered in this screen will be evaluated. Therefore, if you posted labor adjustments to more than one period, you should run this program for each period affected by the changes.
The billing rate that is selected from the billing rate table will be based on the effective date in Labor History and/or Open Billing Detail. The effective date will be compared to the start and end dates in the billing rate tables to determine the proper rate.
Use the options in this group box to select the projects you want to update in the Labor History table and/or Open Billing Detail table. The project range selected should include all projects for which you want to compute revenue and/or billing.
Use this drop-down list to select the range of values to be included. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
Enter, or use to select, the starting value for the
range you want to include. If you select All
or From Beginning in the Range Option field,
this field will be inactive.
Enter, or use to select, the ending value for the range
you want to include. 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 tables that will be updated with the billing rate.
Select this option to update the billing rate in the Labor History table. This is the REV_RT_AMT column of the LAB_HS table. Select this option if you want the billing rates updated only for the revenue computation.
Select this option to update the billing rate in the Open Billing Detail table. This is the BILL_RT_AMT column of the OPEN_BILLING_DETL table. Select this option if you want the billing rates updated only for the billing computation.
Select this option to update the billing rate in both the Labor History and Open Billing Detail tables. Select this option if you want the billing rates updated for both revenue and billing computations. This option is selected by default.
Enter the exchange rate date that you wish to use for the labor rates. The Calculate Billings screen (Projects » Billing » Calculate Billings) will use this date when converting the billing rates. The default is the system date.
Use the options in this group box to select the subperiods with which you want to update labor rates. If more than one period requires updating, the program must be run individually for each period being updated.
Use this drop-down list to select the range of values to be included. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
Enter, or use to select, the starting value for the
range you want to include. If you select All
or From Beginning in the Range Option field,
this field will be inactive. If the Subperiod
field is active and you have made your selections, the field to the right
will display the beginning date for the selected subperiod.
Enter, or use to select, the ending value for the range
you want to include. If you select All,
One, or To
End in the Range
Option field, this field will be inactive. If the Subperiod
field is active and you have made your selections, the field to
the right will display the ending date for the selected subperiod.
When you have finished making your selections, click this icon on the toolbar to start loading updated billing rates into the Labor History table and/or the Open Billing Detail table.
Changes to this screen update the following tables:
LAB_HS
OPEN_BILLING_DETL