---
title: "RDO reset"
id: "rdo-reset"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/rdo-reset"
updated: 2026-10-19T00:53:29Z
---

# RDO reset

Each year, you need to reset the RDOs taken to make sure employees receive the full RDO days allowance again in the new year.

To reset the RDOs taken, create:

* a user report menu item
* an SQL User Defined Report to run an SQL script that updates the register

To reset RDOs taken balances: ![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)

1. Create a user report menu item (via **Administration**&gt; **Add Menu Items** &gt; **Empower-HR User Reports**). See [create user report menu items](/articles/ehr-user-guide/menus/a/h2_1570217708) for instructions

[+] [Show example](javascript:void%280%29)
 [-] [Hide example](javascript:void%280%29)
 ![](/resources/Storage/ehr-user-guide/rdo-reset/RDO%20reset.png)

1. Create an SQL script with the same name as the report code (in the example in shown step 1, the report code is **xrdoregr**). Here's the SQL statement to include in the script.


Code

```
UPDATE hrtrprdo SET hr_days_amnt = 0;
```


1. Save the SQL script to the Reports Server in the directory defined by the **RP\_SQL\_PATH**reports environment variable.
2. Schedule the user defined report to run as required via the **Background Jobs**&gt; **User Reports** menu,

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | Alternatively, if you want, you can incorporate the RDO reset script into a single script to reset all registers - as suggested in [additional weeks reset](/articles/ehr-user-guide/additional-weeks-reset). |
| --- | --- |

| Next topic<br><br>[Search for requests by employee](/articles/ehr-user-guide/search-for-requests-by-employee) |
| --- |

© 2023 Fusion5. All rights reserved.