# Move workorders from one client to another

**URL:** <https://forum.ayanova.com/t/move-workorders-from-one-client-to-another/2267>\
**Category:** Workorders, Quotes & PM's\
**Created:** [February 11, 2015, 2:10am UTC](https://forum.ayanova.com/t/move-workorders-from-one-client-to-another/2267 "2015-02-11T02:10:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://forum.ayanova.com/letter_avatar_proxy/v4/letter/s/bcef8e/32.png) [@system](https://forum.ayanova.com/u/system)\
**Post date:** [February 11, 2015, 2:10am UTC](https://forum.ayanova.com/t/move-workorders-from-one-client-to-another/2267/1 "2015-02-11T02:10:15Z")

</div>

We have this situation in our AyaNova database in which some clients have duplicates and their workorders need to be merged into a single client. For example:  
Client “Jeffrey” has two workorders: 150 and 151  
Another different Client named also “Jeffrey” has some additional workorders: 200 and 201

```
We would like to obtain only one client "Jeffrey" having all the above workorders associated with him: 150, 151 and also 200 and 201.

Is there an easy, automated way of achieving this?
```

---

<div class="post-metadata">

**Author:** ![AyaNovaSupport](https://forum.ayanova.com/user_avatar/forum.ayanova.com/ayanovasupport/32/229_2.png) [@AyaNovaSupport](https://forum.ayanova.com/u/AyaNovaSupport)\
**Post date:** [February 11, 2015, 9:51am UTC](https://forum.ayanova.com/t/move-workorders-from-one-client-to-another/2267/2 "2015-02-11T09:51:54Z")

</div>

> [@striverJohn](#):
>
> We have this situation in our AyaNova database in which some clients have duplicates and their workorders need to be merged into a single client. For example:  
> Client “Jeffrey” has two workorders: 150 and 151  
> Another different Client named also “Jeffrey” has some additional workorders: 200 and 201
> 
> ```
> We would like to obtain only one client "Jeffrey" having all the above workorders associated with him: 150, 151 and also 200 and 201.
> 
> Is there an easy, automated way of achieving this?
> 
> ```

Hello

Yes, the Client Merger utility can be used to merge records of two existing clients together - transfer workorders, quotes, etc from one client to another.  
I will point you towards [Optional Add-ons \> Client Merger](http://www.ayanova.com/AyaNova7webHelp/client_merger.htm) for details and how to use.  
As outlined, the client you want all records moved TO would be selected under TO:

- Joyce

---

<div class="post-metadata">

**Author:** ![system](https://forum.ayanova.com/letter_avatar_proxy/v4/letter/s/bcef8e/32.png) [@system](https://forum.ayanova.com/u/system)\
**Post date:** [February 11, 2015, 11:53pm UTC](https://forum.ayanova.com/t/move-workorders-from-one-client-to-another/2267/3 "2015-02-11T23:53:45Z")

</div>

Thank you for your quick answer. We tested the Merger tool and it works neatly. 🙂