PRIOR YEAR T&M REVENUE

Use this screen to initialize prior year T&M Revenue information. The system uses this information to enforce hours-based ceilings and to calculate the hours in excess of ceiling for projects with loaded labor rate revenue formulas (T&Ms). Enter hours by labor category, or, optionally, by employee/vendor. You do not need to initialize this screen if you do not have hours ceilings on your loaded labor rate (T&M) projects.  All inception-to-date revenue, cost, and hours information for project reports will come from the Prior Year Cost and Revenue screen (Projects » Project Setup » Project History) and the Maintain Labor Summary screen (Projects » Project Setup » Project History).

This screen updates the Prior Year Project Labor History table by fiscal year. This table is also updated as part of the fiscal year close program. Initialize this screen before computing T&M revenue on projects that contain a loaded labor rate revenue formula in the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup).

Fiscal Year

Select the fiscal year you are updating. The fiscal year must be set up as a valid fiscal year.

Project

Select the project to update. For hours to be recognized in the revenue calculation, this project level must be the same as, or lower than, the level at which the revenue formula is set up in the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup). For example, assume a three-level project. Revenue is recognized at the second level, costs are charged at level three. You must enter hours at the second or third level for them to be recognized in the calculation of revenue and ceilings. Hours entered at level one are ignored. The field to the right of the project displays the project name.

Prior Year Amounts

Account

Enter, or use to select, the account to which you will charge the hours. This account must be a detail account, and it must be set up as a Project Required account in the Maintain Accounts screen (Accounting » General Ledger » Accounts).

Account Name

The account name is displayed from the Account table.

Org

Enter, or use to select, the organization to which you will charge the hours.

PLC

Enter the PLC hours that should be charged. This PLC must be a valid labor category.

GLC

Enter the GLC hours that should be charged. Records can contain both a PLC and GLC. Billing rates are determined by PLC, however.

Actual Amount

Enter the actual amount paid.

Actual Hours

Enter the actual hours worked.

Allowable Hours

Enter the allowable hours. Allowable hours cannot exceed actual hours worked. Allowable hours are used in the calculation of over ceiling amounts.

Billing Rate

Enter the applicable billing rate for the hours worked.

Billing Rate Before Discount

Enter the billing rate before discount.  This is for informational purposes only.  If you are not using billing discounts, this field is hidden. This field is updated by the Update Prior Year History screen (Projects » Project Setup » Project History).

Rate Type

Use the drop-down list to select a valid rate type. Valid options are:

• A

• B

• C

• S

Employee

If you are entering hours by employee, enter, or use to select, the employee who worked these hours.

Vendor

If you are entering hours by vendor, enter, or use to select, the vendor who charged these hours.

Vendor Employee ID

Enter the vendor employee ID, up to 12 characters.

Table Information

Changes to this screen update the PY_PROJ_LAB_HS table.