Project Financial Cost Plans show Actuals grouped into the Project Department / Location instead of the Resource Department / Location

Document ID : KB000020735
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms

Project Financial Cost Plans show Actuals grouped into the Project Department / Location instead of the Resource Department / Location. The configuration of the Entity Defaults for Source Location is set to use Employee / Resource values.

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

Figure 1

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.  The Department and Location values saved on the posted WIP transactions come from the System Setting for WIP Processing configuration.

Resolution: 

For existing transactions, the data cannot be changed.  For new, transactions that have not been created in the financial module, 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.

Figure 2

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.

Additional Information:

Reference TEC1883849 : Project Financial Location OBS Unit must be selected for the Cost Plan Population action to fill in Location OBS Unit data when using the Location as a Grouping attribute
Reference TEC438644 : Transactions do not show the correct rate. How do I know which labor rate source location is being used to determine the rates on my transactions?