Project Fields

Here is a description of the fields that make up a project record. Some of these fields may not be visible or editable at all times, or in all package combinations.

Key: R – Read-only

Field   Description
Account   Lookup to the related account for the project. Enter the customer account for the Project, unless you are using it to track items other than revenue such as vacations or internal non-billable Projects.
Billing Type   Type of billing, such as Fixed Price or Time and Materials. A Time and Materials project tracks hours entered by resources with assignment and schedules as the main method of billing.
Currency   When working with multiple currencies, allows you to choose a currency to report the project figures in when different from the default currency for your Salesforce org.
End Date   Date this project ends.
Exclude from Backlog   Indicates whether the project is to be excluded from backlog calculations.
Group   Lookup to the related groupCollapsed to which the project actuals roll up to.
Include in Forecasting   Indicates whether the project is to be included in forecasting.
Location   The project's location.
Notes   A field where you can enter project staffing notes.
Opportunity   Lookup to the related opportunity. Enter the opportunity for the project unless you are using it to track items other than revenue such as vacations or internal non-billable projects.
Opportunity Owner   Contact who owns the related opportunity.
Practice   Lookup to the related practiceCollapsed to which the project actuals roll up to.
Pre-Bill Type R The type of pre-billing selected for the project. This indicates whether the customer has been pre-billed for a part of the budget or all of it.
Project ID R Unique project identifier assigned by the system.
Project Manager   Lookup to the related contact. Used on the resource planner.
Project Name   Name of the project. Should relate to the account and opportunity.
Project Phase   Current phase of the project.
Project Type   Classification of the project.
Region   Lookup to the related regionCollapsed to which the project actuals roll up to.
Share with Project Manager   Indicates whether project related business records such as milestones are shared with the project manager.
Share with Project Resources   Indicates whether project related business records such as milestones are shared with resources assigned to the project.
Stage   Current stage of the project.
Start Date   Date this project starts.
Template   Indicates that this project is a template and appears in the list of projects when you select Create Project From Template.

Project Status

Field   Description
Planned Hours   The number of planned hours for the project. This field exists on projects, assignments and milestones and is for simple planning purposes. When a project is created from a template, the number of hours from the template is copied to this field.
Project Status   Status of the project. The defaults are Red, Yellow and Green, but you can customize this picklist.
Project Status Notes   Notes on the project status.

Project Attributes

Key: G – Used in global projects.

Field   Description
Active   Indicates whether this project is active. When deselected, this project's Scheduled Backlog will not be calculated or reflected in roll-upsCollapsed. Also when deselected, you cannot enter, delete or materially update further business records on this project.
Note
You cannot de-activate a project if it has child projects that are active.
Billable G Indicates that this project is billable. When deselected this project's numbers will not be reflected in any billing information.
Exclude From Billing   Indicates that this project should be excluded from billing events.
Closed for Time Entry   Indicates that this project is closed for timecard entry.
Closed for Expense Entry   Indicates that this project is closed for expense entry.
Exclude from Project Planner   Indicates that this project is hidden from view in the Project Planner.
Allow Self Staffing   Indicates whether resources have permission to create their own assignments for the project. This overrides the staffing permission controls for the project or resource.
Allow Timecards Without Assignment G Enables the entry of timecards without the resource requiring an assignment.
Allow Expenses Without Assignment G Enables the entry of timecards and expenses without the resource requiring an assignment.
Time Credited   Indicates that non-billable time should be credited for utilization. For instance, you may want time spent on consulting to count towards utilization.
Time Excluded   Indicates that non-billable time should neither count for nor against utilization.
Daily Timecard Notes Required   Makes the entry of timecard notes mandatory.
Billable Expense Fee Percentage   Fee percentage by which to increase the billable amount of any Expense logged for the Project. Set to 0% for no increase (default). Set to 100% to double the amount. The calculation applies the percentage expense fee before any flat expense fee.
Billable Expense Fee Flat   The flat fee in project currency by which to increase the billable amount of an expense logged to the project. The increase is applied after any percentage fee increase. The default value is taken from the Billable Expense Fee Flat field on the project.
Expense Notes   Makes the entry of expense notes mandatory.
Share with Project Manager   Enables the sharing of project information with the user designated as project manager.
Share with Project Resources   Enables the sharing of information such as milestones with resources assigned to the project.

Task Information

Field   Description
Tasks Total Points   Total of points on all project tasks.
Tasks Total Points Complete   Total of points on completed project tasks.
Tasks Total Percent Complete (Points) R Percentage of project tasks that are complete based on task points.
Total Number of Tasks   Total number of project tasks.

Project Monitor

Key: R – Read-only

Field   Description
Planned Hours   Number of hours planned for the project.
Total Assigned Hours R Total number of hours from project assignments.
Total Projected Revenue From Assignments R Total projected revenue from all project assignments

Selected Time Period

Key: R – Read-only

Field   Description
Action: Update Current Time Period   Indicates whether project numbers within the current time period are to be updated when you next save the project. Use this checkbox to update project numbers after changing the Project Time Period field.
Current Time Period R Name of the current time period.
Current Time Period End Date R Last day of current time period.

Actuals

Actual values, for the project, at a given point in time, based on selected time period. All read-only.

Revenue Actuals

Field   Description
Billed   Sum of billed amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to billed revenue after they are billed/invoiced. Milestones contribute to billed and invoiced revenue after they are billed/invoiced.
Billings   Sum of Ready-to-Bill Revenue from Timecards and Milestones.
Bookings   Booked revenue for this project. Budgets of type Customer PO and Customer PO Change Order contribute to bookings.
Expense Budget   Sum of expense budgets for the project. The Expense Amount field of a budget contributes to this field if the budget is of type: Customer PO, Customer PO Change Order, Internal Budget or Internal Budget Change Request.
Internal Budget   Sum of internal budgets for the project. The Amount field of a budget contributes to this field if the budget is of type: Internal Budget or Internal Budget Change Request.
Invoiced   Sum of invoiced amounts. Expenses, timecard splits and miscellaneous adjustments that are billable contribute to invoiced revenue after they are billed/invoiced. Milestones contribute to invoiced revenue after they are billed/invoiced.
Pass-Through Billing   Sum of pass-through billings, including expenses.
Pre-Billed   Amount already billed for the project.
Revenue   Revenue is not calculated or rolled up. Enter a miscellaneous adjustment to show revenue on the project actuals.
Margin   Billings minus Total Costs.

Cost Actuals

Field   Description
Internal Costs   Sum of internal costs, whether billable or not. Internal Costs are only for resources that are not marked External. This is calculated using this formula:
approved timecard hours * cost rate + expense costs in approved expense reports.
Expense costs include both billable and non-billable costs.
External Costs   Sum of external costs, whether billable or not.
Milestones may contribute to flat External Cost if the External Cost field is completed, and the Log Cost as External checkbox is selected. For example, when you count subcontractor fees as a flat cost amount that helped you reach the milestone and achieve the billings.
Expense Costs   Sum of approved expenses in expense reports, whether billable or not.
Other Costs   Any other project costs. Other costs might include things like material or capital costs incurred on the project.These are only generated through miscellaneous adjustments which can also generate any other category of revenue or cost. The Amount field of a budget also contributes to this field if the budget is of type Work Order or Work Order Change Request.
Total Costs   Total costs from all projects in the project hierarchy.

Time Actuals

Field   Description
Billable Hours (External)   Not included in utilization calculation.
Billable Hours (Internal)   Included in utilization calculation.
Credited Hours   Hours taken from timecards where the project has Time Credited checkbox selected.
Excluded Hours   Hours taken from timecards where the project has Time Excluded checkbox selected.
Non-Billable Hours (External)   Not included in utilization calculation.
Non-Billable Hours (Internal)   Not included in utilization calculation.

Backlog

When you run a backlog calculation the details are copied from the backlog detail object to the project.

Field   Description
Scheduled Backlog Amount   Value of scheduled hours backlog.
Scheduled Backlog Calculation Date   Start date of scheduled backlog calculation (usually today).
Scheduled Backlog End Date   End date of scheduled backlog calculation
Scheduled Milestone   Value of scheduled milestone backlog.This value depends on the time period. For instance if the backlog is calculated for all time periods, the value includes all time periods up to the end of the last future milestone.
Scheduled Time   Value of scheduled time backlog. This value depends on the time period. For instance if the backlog is calculated for all time periods, the value includes all time periods up to the end of the last assignment.
Unscheduled Backlog   Value of unscheduled revenue.

Billing Eligible Records

Field Description
Billing Eligible Last Updated Displays the date on which the Billing Eligible fields were last updated on the project.
Action: Count Billing Eligible Records Indicates whether the fields above are updated when you save the project. When you save the project, the checkbox is automatically deselected.
Billing Eligible Budgets The number of budgets that are eligible for billing event generation and creation.
Billing Eligible Expenses The number of expenses that are eligible for billing event generation and creation.
Billing Eligible Milestones The number of milestones that are eligible for billing event generation and creation.
Billing Eligible Misc Adjustments The number of miscellaneous adjustments that are eligible for billing event generation and creation.
Billing Eligible Timecard Splits The number of timecard splits that are eligible for billing event generation and creation.

In addition, for an item to be eligible for billing, the following applies:

Project Hierarchy

Field   Description
Parent Project   Next level up in the project hierarchy.
Master Project   Highest project in the hierarchy.
Hierarchy Depth   Level within the project hierarchy.
Project Name Chain   Name of system-generated chain for linking to the project.
Project ID Chain   ID for system-generated chain for linking to the project.

Optional Related Lists

Buttons

Button Description
Edit Allows you to edit the project.
Delete Allows you to delete the project.
Clone Allows you to clone the project.
Create Change Request Displays the Create Change Request page where you can create a new change request opportunity from the project.
Project Planner Displays the Project Planner.
Share Project Displays the Share Project page where you can share related objects such as milestones with resources assigned to the project.
Manage Project Tasks Displays the PSA Task Management page where you can manage project tasks.

Related Information

Projects

Milestones

About the Project Planner

Project Hierarchies

Related Tasks

Creating a New Project

Deleting a Project

Creating a Milestone

Creating a Change Request

Sharing a Project

Creating Child a Project

© Copyright 2009-2012 FinancialForce.com, inc. All rights reserved.
Various trademarks held by their respective owners.