Who is this article for?

Users who have ceased using RetainTime and are now using the Timesheets module.

IT Administrator permissions are required to resolve the issue.

After stopping the use of RetainTime and starting to use Ideagen Audit's Timesheets module, you might find that users' time is not aggregated into Audit Actual Time.

This article explains what causes the issue and how to resolve it.

1. Issue

Where RetainTime is used with Internal Audit:

• users enter timesheet data into RetainTime.
• the Robot collects that data and updates Actual Time in Audit Assignments.
• time is aggregated from Audit Assignments into the parent Audits.

If the organisation chooses to cease using RetainTime and switch to using the Timesheets module, the correct process for disabling RetainTime must be followed (i.e. the 'Disable RetainTime' customisation must be run at cutover), otherwise entered data does not correctly roll up into Audit Assignment and Audit summaries, and related calculated fields are not updated.

You can run the Disable RetainTime customisation after users have started entering time data into the Timesheets module, but existing Timesheet data will not roll up into Audit Assignments and Audits.

2. Solution

This script can be used to correct the situation. Typically the organisation will want to cut over after a particular Audit has been entered, so to implement:

1. Identify the ID of the final Audit to be maintained via RetainTime.
   To do this, use the following database query:

   SELECT ID, Name FROM AUDIT;

2. Edit the top line of the script so that the ID is specified.
3. Stop the Ideagen Internal Audit (Aura) robot service.
4. Stop the Pentana application pools.
5. Back up the Pentana database and verify.
6. Run this script - it should run without error.
7. Restart the Pentana app pools.
8. Restart the Ideagen Internal Audit (Aura) robot service.

Note that this script should not be used without modification if:

• The working week is not 5 days.
• The criteria for the last audit to be completed in RetainTime cannot be specified by ID.

If either of these is the case, the please contact Ideagen Support for further guidance.

This script should be run in UAT prior to running Live.