Setting up Project Tracking

Modified on Sat, 20 Jul at 10:36 AM

Maintaining Project Setup Details

Use the Project Setup window to maintain general details about the Project Tracking module such as project numbering and project dimension integration.

To access Project Setup, see Accessing the Project Tracking Module.

The following table provides details for each of the fields in the Project Setup window.

Field Name	Details
Project Dimension Code	Use this field to select the dimension that has been set up to capture project data.
Project No. Series	Use this field to select the no. series that has been set up for numbering projects. Use the no. series relationships to set up multiple no. series for projects. If you wish to manually number projects then leave this field blank or allow manual numbering on the number series set-up.
Shortcut Dimensions No.	This value displays the dimension no. based on the dimension code selected for the Project Dimension Code above.
Current Project Budget	Use this field to select the budget name to be used for filtering purposes on the Project Card. This value will need to be updated once per year if you are using a new budget code each year. NOTE: In order to support project budget checking across multiple years seamlessly, you may want to consider using a single budget for all budget years. You can copy the board approved budget into an ongoing budget code. If you take this approach, the budget name code should be the code that represents that ongoing budget.
New Project Budget Name	Use this field to enter the new project budget name.
Update Project Budget on G/L Post	Select this field if you want the project budget to get updated on every G/L post.
Update Project Budget on Deposit Post	Place a checkmark in this field if you want the project budget updated every time a deposit is posted. The budget data will be created based on the settings in the Project Funding Type (Create Budget from Action, Budget Revenue Acct. No. and Budget Expense Account No.)

Maintaining Project Statuses

Use this section to define the status that will be used in the Project Tracking process. This status is typically included throughout the project’s life cycle from the project planning stages until its completion.

To access Project Status, see Accessing the Project Tracking Module.

The following table provides details for each of the fields in the Project Status window.

Column Name	Details
Code	This column creates a code that represents the status of the project.
Sequence	Enter a numerical value here. The list of statuses will be sorted numerically by this field. These should follow the natural progression of your project as when you are working on a project the system will not allow a user to move status backwards in the sequence
Description	Enter a description for the status.
Default	Select only one status as the default. This status will be set for all new projects as they are created. Normally on the first status in the sequence.
Create Dimension Value	Place a checkmark in this column for each status that you would like to use as a trigger for creating a dimension value. If a project is given this status with this value selected, the system will automatically create a dimension value for it if one does not already exists.
Block Dimension Value	Place a checkmark in this column for each status where you would like to prevent a transaction from taking place with the project. If a project is given this status with this value selected, the dimension value will be blocked and all transactions prevented.
No. of Projects	This field displays the no. of projects currently with this status. Drill down to view the project list under this status.

Maintaining Project Types

Use this section to define the project types used when categorizing projects. Project types are typically natural classifications for different types of projects or projects managed by different teams within the organization.

To access Project Types, see Accessing the Project Tracking Module.

The following table provides details for each of the fields in the Project Types window.

Column Name	Details
Project Type	This column creates a code that represents the type of the project.
Description	Enter a description for the type.
No. of Projects	This column displays the no. of projects currently under this type. Drill down to view the project list.

Maintaining Funding Types

Use this section to define the different types of funding for projects. The type of funding can also drive the filters that are used when computing the budget values on the project card.

To access Funding Types, see Accessing the Project Tracking Module.

The following table provides details for each of the fields in the Funding Types window.

Column Name	Details
Code	This column creates a code that represents the funding type.
Description	Enter a description for the funding type.
Budget G/L Account Filter	Use this field to maintain the G/L Accounts that are included in the Budget Data on the Project Statistics. This is typically expense accounts only to avoid comingling the expense and revenue budgets if they both exist.
Budget G/L Account No.	Use this field to indicate the G/L Account to use when using the feature to “Create Budget Entries from Payment Schedule”. This is typically the account where revenue or cash is budgeted.
Actual G/L Account Filter	Use this field to select the budget accounts with actual amounts to be used for filtering on the project card. This is typically expense accounts only to avoid copying the expense and revenue budgets if they both exist.
Create Budget from Actual	Place a checkmark in this field if you want to create a project budget from actual amounts. This option should be used if you want to have the project budget derived automatically from amounts received in payments. NOTE: The field "Update Project Budget on Deposit Post" must be turned on for this feature to be enabled.
Budget Revenue G/L Account No.	Use this field to specify a G/L account No. for budget revenues. This is the account that will be monitored for deposit posting to create the budget details.
Budget Expense G/L Account No.	Use this field to specify a G/L account No. to which the budget entries will be attributed when using the Create Budget from Actual feature.
No. of Projects	This column displays the no. of projects currently under this funding type. Drill down to view the project list.

Maintaining Tasks and Deliverables

Use this section to define the different types of deliverable or tasks for the projects. These items can include financial reports, progress reports, or certifications or clearances that are required prior to beginning work on the project.

To access the Tasks and Deliverables page, see Accessing the Project Tracking Module.

The following table provides details for each of the fields in the Task & Deliverables (Project) window.

Column Name	Details
Code	This column creates a code that represents the tasks or deliverable for the project.
Description	Enter a description for the tasks or deliverable.
Due Date Calculation	Enter a default date calculation. NOTE: Time units can be used in this formula are the following: D – Day, WD – Week Day, W – Week, M – Month, Q – Quarter and Y – year.
No. Required	This column displays the number of entries where this task or deliverable is specified as required. Drill down to view the project list.
No. Pending	This column displays the number of entries where this task is specified as required but still does not have the completed date filled out. Drill down to view the project list.

Managing Project Contact Types

Use this section to define the different types of contacts related to a project. Contacts can be either internal (linked to HR Employee records) or external (linked to Contacts).

To access the Project Contact Types page, see Accessing the Project Tracking Module.

The following table provides details for each of the fields in the Project Contact Types window.

Column Name	Details
Code	This column creates a code that represents project contact type.
Description	Enter a description for the type of contact
Internal/External	Choose either Internal (lookup to HR employee list) or External (lookup to contact management list, on the menu under Sales and Marketing. Note that this feature needs to be configured to be used). NOTE: Unless you have license to the payroll module you cannot use the Internal option, and will have to set-up employee project contacts in Contact Management

Attachments (6)

clipboard_e0....png
41.6 KB

2.png
50.2 KB

3.png
39.4 KB

4.png
56.7 KB

5.png
51.6 KB

6.png
41 KB