to select, the starting project for the
range for which you want to compute billable value, revenue and/or billing.
If you select All or From
Beginning in the Range
Option field, this field will be inactive.Use this process to select labor rates from the labor rate screens and to calculate the labor rates based on effective dates and rate types. These labor rates are used to calculate revenue and billing.
This process selects labor rates for a PLC from the labor rate screens based on the information in the Define Rate Sequence screen (Projects » Project Setup » Revenue Setup) for a project. Once the correct labor rate screen has been identified, this process uses effective dates and rate types to calculate the labor rates and insert them into the Maintain Labor Summary (Projects » Project Setup » Project History) and Maintain Open Billing Detail (Projects » Billing » Prepare Billings) screens. The Maintain Labor Summary screen is the screen that is used in the computation of revenue and the Maintain Open Billing Detail screen is the screen that is used in the calculation of bills for hours-based revenue and billing formulas.
The screens that are classified as labor rates screens include Set Up Project Labor Categories (PLC) (Projects » Project Setup » Project Labor), Project PLC Rates (Projects » Project Setup » Project Labor), and Project PLC Rates by Employee/Vendor (Projects » Project Setup » Project Labor). You can have PLCs and related billing rates set up in any or all of these screens. Use the Define Rate Sequence screen to identify a sequence in which you want the Load Labor Rates process to select labor rates from the labor rate screens. Once the correct labor rate screen is identified for a PLC, this process compares the effective date in the Maintain Labor Summary and the Maintain Open Billing Detail screens to the effective date range in the labor rate screen. This process selects the labor rate for the PLC where the effective date in the Maintain Labor Summary and/or the Maintain Open Billing Detail screen falls within the date range in the labor rate screen.
The Load Labor Rates process uses the rate type to do the final calculation of the labor rate for the PLC. See the labor rate screens for more information on how rate types are used in the calculation of labor rates. The process inserts the labor rate into the Maintain Labor Summary and the Maintain Open Billing Detail screens once the correct labor rate is selected and calculated.
If you selected the Use Goal Multipliers for Billable Value Calculations check box in the Project Settings screen (Projects » Project Setup » Controls), this process will insert labor rates for all projects including projects that are not hours-based. For hours-based projects, the process will calculate labor rates as noted previously. For all other types of projects, the process will set the Rate Type field in the labor rates screens to A, and calculate the labor rate by dividing total labor cost by actual hours incurred.
You must run this program before computing revenue, billings, or billable value of cost incurred, and you must initialize PLC labor rates by project before running this program. The Revenue and Billing calculation programs use the labor 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.
Note that this program updates labor rates by effective date; therefore, if you have posted labor adjustments, you should run this program again after posting the adjustments. The Billing Value report also uses the billing rate stored in Labor History, in addition to revenue and billing programs, as the basis for deriving the billing value of costs incurred.
Use this group box to select the projects you want to update in the Labor History and/or Open Billing Detail screens. The project range selected should include all projects for which you want to compute billable value, revenue and/or billing. This process will only affect projects with hours-based billing and/or revenue formulas. If you have selected the Use Goal Multipliers for Billable Value Calculations check box in the Project Settings screen (Projects » Project Setup » Controls), all projects included in this range will be affected.
Use this drop-down list to select the range you want to include. Valid options are:
All
One
Range
From Beginning
To End
Enter, or use to select, the starting project for the
range for which you want to compute billable value, revenue and/or billing.
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 for the
range for which you want to compute billable value, revenue and/or billing.
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 labor rate and rate type.
Select this option to update the labor rate and rate type in the Billing Rate and Rate Type fields in the Maintain Labor Summary screen (Projects » Project Setup » Project History). The Maintain Labor Summary screen is used for computation of revenue and billable value.
Select this option to update the Billing Rate and Rate Type fields in the Labor subtask of the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings). The Maintain Open Billing Detail screen is used for the calculation of bills.
Select this option to update the Billing Rate and Rate Type fields in both the Maintain Labor Summary and the Labor subtask of the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings). Select this option to update the labor rates for revenue, billing, and billable value computations.
Enter the date that you would like to use for exchanges rates. This date is only used for PLCs that have a rate type of T. The Load Labor Rates process uses the date entered in this field to select the appropriate rate from the Maintain Exchange Rates by Date screen (Accounting » Multicurrency » Exchange Rates). You must have selected the Use Transactional Currency Billing check box in the Other Info subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) in order for T rates to be calculated correctly. The date entered in this field will be ignored for purposes of currency conversion on projects that are not using T rate types.
Use this group box to select the subperiods for which you want to update labor rates. If you need to update more than one period, run the program individually for each period being updated. The Fiscal Year, Period, and Subperiod must be open to update labor rates. Only the transactions that fall on or before this subperiod ending date will be evaluated during the Load Labor Rates process.
Use this drop-down list to select the range of subperiods for updating labor rates. Valid options are:
All
One
Range
From Beginning
To End
Enter the fiscal year and period or select one from the drop-down list.
Use this field to enter the subperiod from which you want to begin the process. This field will be inactive if you have selected All or From Beginning in the Range Option field. The non-editable field to the right displays the selected subperiod end date.
Use this field to enter the subperiod through which you want to run this process. This field will be inactive if you selected All, One, or To End from the Range Option field. The non-editable field to the right displays the subperiod end date.
Once you have made your selections, click the Load Rates icon on the toolbar to begin loading rates into the Maintain Labor Summary (Projects » Project Setup » Project History) and/or the Maintain Open Billing Detail (Projects » Billing » Prepare Billings) screens.
Changes to this screen update the following tables:
LAB_HS
OPEN_BILLING_DETL