Clarity PPM - Cost Plan Actuals incorrectly grouped
search cancel

Clarity PPM - Cost Plan Actuals incorrectly grouped

book

Article ID: 20735

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Symptoms

The configuration of the Entity Defaults for Source Location is set to use Employee / Resource values.

Project Financial Cost Plans show Actuals grouped into the Project Department / Location and not Resource Department/Location as expected

 

Steps to Reproduce:

  1. Administration, Finance: Setup, Defaults
    Project Transaction Entry Defaults, Source Location = Employee (Resource)
  2. Administration, Finance: Setup, Entity = Corporate
    Labor Rate and Cost Defaults > Source Location = Resource
  3. Administration, Locations
    Set up 2 locations for Entity = Corporate
    Project Location A
    Resource Location B
  4. Home, Departments
    Set up 2 departments for Entity = Corporate and link to appropriate Locations
    Project Department A
    Resource Department B
  5. Create a new Resource
    Set Financial Properties to use the Resource Department B / Location B
    Set all other required attributes to use timesheets and financially active
  6. Create a new Project
    Set Financial Properties to use the Project Department A / Location A
  7. Allocate the new Resource to the project
  8. Assign the new Resource to tasks on the project
  9. Create 2 financial plans
    Plan 1 : Allocations
    New from Investment Team, Group by Department, Location
    Plan 2 : Assignments
    New from Task Assignments, Group by Department, Location
    Review Details of both plans --- see the row created is for the Resource Department B / Location B as expected
  10. Create a Voucher Transaction, follow process to post into WIP
  11. Review details of both project financial plans
    The actuals are posted using the Project Department A / Location A values
  12. Create a Timesheet Entry for the resource on the project, follow process to post into WIP
    > The actuals are posted using the Project Department A / Location A values

Expected Result: The actuals should be posted using the Resource Department B / Location B values
Actual Result: The actuals are posted using the Project Department A / Location A values

 

 
 

Environment

Release:All supported releases
Component:

Cause

This issue is due to an incorrect configuration.  When 'Actuals' appear on a Cost Plan, it uses the data from the Posted WIP transactions.  

Resolution

For existing transactions, the data cannot be changed.  For new, transactions you can change the system setting to have the posting into WIP use the Resource source fields instead of the Project source fields.

Go to the Administration, Financial Management WIP Settings page.
By default, all new implementations will have default values set to use 'Project' values.

 

If you change all 3 fields to use the 'Resource' values for Entity, Location and Department, when new financial transactions are Posted to WIP, the application will use the current setting.  Then all new transactions posted into WIP will show up on the Cost Plan, grouped by the Resource Department/Location. 
NOTE: Changing this setting will not affect existing transactions already posted into WIP.