Clarity: Cost Variance, Unit Variance and Revenue Variance incorrect in TSV of cost plans when fiscal time periods are not equal to the exact months or years (4-4-5 fiscal calendar or other)

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

Description:

In cost plans within the TSV the Cost Variance, Unit Variance and Revenue Variance are not calculated correctly when fiscal time periods are not equal to the exact calendar months or years by ISO* (4-4-5 fiscal calendar, annually periods not starting from January 1, or other types)

* Note : ISO refers to International Organization for Standardization, the standard uses the Gregorian calendar, in which months and years are equal to Gregorian ones (i.e. January will be 1-31, and 2012 will be 01-Jan-2012 to 31-Dec-2012)

Steps to Reproduce:

  1. Connect to Clarity: Administration : OBS

  2. Create two OBS for location and department

  3. Go to Finance: Setup and create a new entity based on those OBS

  4. Associate the location to the department

  5. Open the entity and add the fiscal periods as follows (European date format):
    p1 02/07/12 29/07/12
    p2 30/07/12 02/09/12
    p3 03/09/12 30/09/12
    p4 01/10/12 28/10/12
    p5 29/10/12 02/12/12
    p6 03/12/12 31/12/12
    p7 01/01/13 27/01/13
    p8 28/01/13 03/03/13
    p9 04/03/13 31/03/13
    p10 01/04/13 28/04/13
    p11 29/04/13 02/06/13
    p12 03/06/13 30/06/13

    or use 4-4-5 fiscal calendar (first monthly period is 4 weeks, second is 4 weeks, third is 5 weeks, fourth is 4 weeks, fifth is 4 weeks, sixth is 5 weeks... repeat for entire year)

  6. Create a Matrix based on this entity or make sure there is matrix covering the period.

  7. Create a project for the duration of the fiscal year.

  8. Enable it financially with the location/department as in step 4., add the matrix from 6. as labor cost/rate source, run Rate matrix extraction

  9. Add a task covering the whole period, assign a financially enabled resource (for same entity as in step 5.)

  10. Now go to Financial plans, create a New from Investment Team cost plan

  11. When the cost plan is created go to Detail : make sure Cost Variance, Revenue Variance and Units variance are added to the TSV view. Otherwise do Configure : List Column section : Fields: Unit, Cost and Revenue Details : properties and add Cost Variance, Revenue Variance, Units variance to the TSV of Cost plan Details layout, Save and Return

Expected Result: To have correct results in the Cost Variance, Revenue Variance and Units variance fields
Actual Result: Results values are incorrectly spread between fiscal periods

The following is an example from a cost plan using Annually periods that do NOT start on January 1 of the year. One of the specific numbers that are incorrect is: For the period "2013-2014" on the second line item the variance should be 2,000,000, but it is showing 1,753,425 instead:

Figure 1

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

Resolved in Clarity 13.0.1 Generic Patch. Reference TEC572268
Resolved in Clarity 13.1.0 Generic Patch. Reference TEC581256
Resolved in Clarity 13.2

Keywords: CLARITYKB, CLRT-69722, clarity13resolved, clarity1310resolved, clarity132resolved, time-scaled, benefit, budget, aggregate