Time Phase Data Configuration Support

What's New?

 The Financial Planning feature has been enhanced with configuration support for Time Phases.  

 You can add Validation Rules, Workflow Rules and Scheduled Workflow Rules on Time Phases.

 

 Special Custom Field support has also been added, more information about custom fields in this article.

 

FP_config.PNG

 

 

Validation Rule Example

Use Case: Month End Financial Close Governance.

Prevent modification of plan and actual data after close of previous months financial period.

 

Step 1

Create a date field on Organization: "Current Reporting Period Start"

Custom_Date_Field_Organization.png

 

Step 2

Create a validation rule on Non-Labor Resource Time Phase to be triggered when Budget Cost ("Planned Budget") or Actual Cost is modified for a date before the current reporting period by a non-Admin user.

 

Not CurrentUser().Admin &&
((ischanged($PlannedBudget) || ischanged($ActualCost) || isNew()) &&
$Date < Organization.C_CurrentReportingPeriodStart)

 

Validation_Evaluation_Criteria2.pngValidation_Message.png 

Step 3: Result

Validation_Triggered.png

 

 

 

Workflow Rule Example

Use Case: Non-Labor Pricing Calculator

Set a unit cost of a Non-Labor resource for a project. Then varied quantities per month to have the Budget Cost calculated according to unit cost * quantity

 

Step 1

Create 2 Custom Fields

Field #1: Unit Cost, a Currency field on Non-Labor Resource Link 

NLR_link_unit_cost.png

 

Field #2: Quantity, a Numeric field on Non-Labor Resource time phase data 

Custom_Field_On_NLR_Time_Phase.png

 

Step 2

Create a Workflow Rule on Non-Labor Resource time phase data

Workflow_Set_Budget_Cost.pngWorkflow_Set_Eval_Criteria.pngWorkflow_Action.png

Step 3 

Set the Unit Cost on the Project's Non-Labor Resource, from the Project detail page

Set_Unit_Cost.png

 

 

Step 4 

Add the Quantity field to the time phase columns in the Financial Planning view

Add_Field_to_Time_Phases.png

 

Step 5: Result

Budget Cost is calculated

Calculate_Budget_Cost.png

 

Have more questions? Submit a request

Comments