Clarity: WIP Entry and Adjustment do not have a project/task combination check

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

Description:

When creating a new transaction entry or WIP adjustment on an existing transaction, the application allows users to enter wrong Investment id / Task combinations on the Transaction Details page.

After posting the new transaction to WIP or approving the WIP adjustment, the PPA_WIP table is updated. In the case of a new transaction entry (voucher), the wrong combination get recorded in the table without any error. In the case of a WIP adjustment, you can see that there are records in the table where the project code is different but the records have the same task_id. This should not be possible because these internal task id's should be unique (and can only appear on one project and not two or more).

When filtering on the Create WIP Adjustment page the transaction shows up when filtering under the project to which the task belongs; upon running the Import Financial Actuals job the corresponding actual units get posted to the project to which the task belongs and not the project whose ID got entered on the Transaction Details page.

Steps to Reproduce:

  1. Login to Clarity as a Financial user

  2. Home > Create WIP Adjustments > Search for a transaction that can be adjusted

  3. Click on the date to open the transaction

  4. Change the Investment ID by typing in the Investment ID (Code) -- DO NOT use the 'browse' button icon, DO NOT make any other changes

  5. Click 'Submit' button

  6. Navigate to Approve WIP Adjustments > select/check transaction > click 'Approve' button

    Expected Result: The application should check for validity of the Investment / Task combination on the transaction record and present the end-user with a message at the time the adjustment is created.

    Actual Result: The invalid configuration is accepted; no error message is displayed to prevent this configuration

Solution:

WORKAROUND:

The application should not allow the end-user to change the project or task on a WIP Adjustment by simply changing the Investment Id. The user should be using a WIP TRANSFER action. The WIP TRANSFER action is more appropriate because then the application will remove the transaction from the original (source) project and then create a new transaction for the target project and then when the Import Financial Actuals job executes, both projects will be updated appropriately. The invalid transaction can occur for new voucher transactions as there is no validation on that page too.

----------------------------------------------   
/*   
Use this query to identify records in the WIP table that have an invalid project / task relationship   
*/   
----------------------------------------------   
select   
w.investment_id wip_investment_id   
, i.name wip_investment_name   
, w.task_id wip_task_id   
, t.prname wip_task_name   
, t.prprojectid prtask_project_id   
, i2.name prtask_project_name   
from   
  ppa_wip w   
, inv_investments i   
, prtask t   
, inv_investments i2   
where 
  w.status = 0   
and w.investment_id = i.id   
and w.task_id = t.prid   
and t.prprojectid = i2.id   
and w.investment_id != t.prprojectid      
----------------------------------------------

After executing the above query to identify transactions that have been transferred incorrectly, use the following steps to correct the records.

Steps to Correct:

  1. Login to Clarity as a Financial user

  2. Home > Create WIP Adjustments > Search for incorrect transactions

  3. Click on the date to open the transaction(s)

  4. Change the Investment ID back to the original Investment ID by typing the Investment ID in the field -- DO NOT use the 'browse' button icon

  5. Click 'Submit' button

  6. Navigate to Approve WIP Adjustments page

  7. Select/check the transaction(s)

  8. Click 'Approve' button

  9. Create WIP Adjustments > Search for the updated transaction again

    It is very important to use the following fields in the Filter Section to locate transactions for the transfer action:

    Start Date
    End Date
    Project
    Task
    Resource

  10. Select/check the transaction(s)

  11. Click 'Transfer' button

  12. On the Transfer Page, fill in the new Project, Task and Resource values

  13. Click 'Submit' button > see the transfer action is successful

  14. Navigate to Approve WIP Adjustments page

  15. Select/check the transaction(s)

  16. Click 'Approve' button

  17. Execute 'Import Financial Actuals' job

  18. Repeat steps to correct other transactions

STATUS/RESOLUTION:

Resolved in Clarity 12.1.1 Generic Patch. Reference TEC553491.
Resolved in Clarity 12.1.3
Resolved in Clarity 13.0.1
Resolution implemented is to prevent the invalid Investment ID / Task combination.

Keywords: CLARITYKB, CLRT-62010, clarity12resolved, clarity1213resolved, clarity13resolved, clarity1301resolved, revmgr.