In Clarity we don’t use the timesheet data to get the actuals as we sends the timesheet posted data into SAP and SAP convert time into pounds and project actual are send back to Clarity via an interface.
As per business requirement we should select the Entry type as ‘Imported’ on ‘Post to Wip’ page for processing however s ‘ALL’(Imported, PPM) accidentally was selected and posted into Clarity. Due to this the project actuals are almost doubled for every project on cost plan page and now projects are out of governance.
As per requirement ppa_wip table should have entry only for SAP actual (source module=50) however now we have data for timesheet actual (source module 51) as well as SAP actual (source module 50) and around 800K timesheet transactions have been committed so it’s not an easy job to do the ‘WIP Adjustment’ for all the timesheet transactions.
Please let me know if someone else has come across with same situation and what is the best way to fix this issue in order to correct the issues caused.
Much appreciate your suggestions and thanks for your help in advance.