Populating cost plan does not recognize mid-month dates in the rate matrix

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

The cost plan is not showing the correct cost (or shows no cost) for a certain period.  

This occurs when dates in the rate matrix do not start on the first of the month. 

Here is an example:

A rate in the Rate Matrix is set for a resource from 04/12/2017 to 05/31/2017. When the cost plan is created where the fiscal period begins on April 1st, it picks up the rate that starts on or before 04/1/2017, instead of the rate starting at 04/12/2017. 
The correct rate (based on 4/12/2017) will show for May.

This normally happens when a resource is hired mid-month and their From Date in the Matrix is their hire date.
However it can also happen if their rate changes mid-month.

Example:

 

  • Matrix is defined with the Resource column and Role column 
  • Resource = Fred with a primary role = Analyst
  • Matrix row 1:  Resource = Fred ; Date range = Jan. 1, 2017 thru April 11, 2017 ; cost rate = $50
  • Matrix row 2:  Resource = Fred; Date range = April 12, 2017 thru September 30, 2017 ; cost rate = $100
  • When the cost plan is populated, Fred will get the $50 rate for April 1-30 and get the $100 rate from May on.
 

 

Cause:
The cost plan uses the first of the fiscal period (month) to determine the rates in the cost plan.

Financial transactions however will use the correct rate.
Resolution:

The current design of the application is to pick up the appropriate cost rate at the beginning of the period and use the cost rate to the end of the period or to the end of the matrix row date range.  

The only work around would be make the matrix From Date start on the 1st of the month.  This may or may not be viable.