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:
- Administration, Finance: Setup, Defaults
Project Transaction Entry Defaults, Source Location = Employee (Resource)
- Administration, Finance: Setup, Entity = Corporate
Labor Rate and Cost Defaults > Source Location = Resource
- Administration, Locations
Set up 2 locations for Entity = Corporate
Project Location A
Resource Location B
- Home, Departments
Set up 2 departments for Entity = Corporate and link to appropriate Locations
Project Department A
Resource Department B
- 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
- Create a new Project
Set Financial Properties to use the Project Department A / Location A
- Allocate the new Resource to the project
- Assign the new Resource to tasks on the project
- 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
- Create a Voucher Transaction, follow process to post into WIP
- Review details of both project financial plans
The actuals are posted using the Project Department A / Location A values
- 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
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.
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.
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.
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?