# Any way to copy UD fields from quote to order without code?

**URL:** <https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257>\
**Category:** Epicor ERP 10\
**Created:** [September 7, 2017, 11:43pm UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257 "2017-09-07T23:43:08Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![mmahrle](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ed8c4c/32.png) [@mmahrle](https://www.epiusers.help/u/mmahrle)\
**Post date:** [September 7, 2017, 11:43pm UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/1 "2017-09-07T23:43:08Z")

</div>

I have a client that’s on a multi-tenant hosted environment. They have added a few fields to the quote entry form that they want to transfer to the order form if they create the order from the quote. I’ve created a simple pre-processing BPM on the Quote.CreateOrder method. All it does is grab the UD field values and place them in BPM data fields. The problem is, of course, that I don’t have access to the order head table via the set field action in the BPM designer, only quote tables.

I’m able to update the order head fields using code (I also have access to an on premise installation where I can verify things), but that’s not doable in their environment. So, the question is, does anyone know of a way to copy UD fields from a quote to an order via BPMs that doesn’t require code?

---

<div class="post-metadata">

**Author:** ![aidacra](https://www.epiusers.help/user_avatar/www.epiusers.help/aidacra/32/17997_2.png) [@aidacra](https://www.epiusers.help/u/aidacra)\
**Post date:** [September 7, 2017, 11:59pm UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/2 "2017-09-07T23:59:12Z")

</div>

In the Advanced BPM Embedded Education course there is a workshop that uses “Fill Table By Query” and “Invoke BO Method” which is what you’d want to use in an MT environment as they are purely wizard driven events.

 ![image](https://www.epiusers.help/uploads/default/original/2X/2/2bac8b64498452beebd10f8bff3995c1d98fe5ca.png)

EDIT: There is another post from last year that discusses update table by query with a couple of working examples:

> **[E10 BPM to invoke a BO Method to Update a different Table](https://www.epiusers.help/t/e10-bpm-to-invoke-a-bo-method-to-update-a-different-table/36547)**
>
> I am trying to create a BPM from Erp.CustCnt.Update method directive to apply data to a field in the CustCnt Table, I also want to update the PerCon table so have Inserted an “Invoke BO Method”, using “Update Table by Query” See layout below. ...

---

<div class="post-metadata">

**Author:** ![mmahrle](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ed8c4c/32.png) [@mmahrle](https://www.epiusers.help/u/mmahrle)\
**Post date:** [September 8, 2017, 3:35am UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/3 "2017-09-08T03:35:06Z")

</div>

Thanks for the response. I get the general idea, but I don't have access to the embedded education info (at least that I know of). Is there someplace I can see the workshop so I can get a better picture of how it works?

  

Sent from my Verizon ASUS tablet

---

<div class="post-metadata">

**Author:** ![danbedwards](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/9f8e36/32.png) [@danbedwards](https://www.epiusers.help/u/danbedwards)\
**Post date:** [September 8, 2017, 12:29pm UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/4 "2017-09-08T12:29:52Z")

</div>

The Ice Tools Guide has an example you can access.

[https://epicweb.epicor.com/doc/Docs/EpicorICETools\_UserGuide\_101500.pdf#search=Search...fill%20table%20by%20query](https://epicweb.epicor.com/doc/Docs/EpicorICETools_UserGuide_101500.pdf#search=Search%2E%2E%2Efill%20table%20by%20query)

---

<div class="post-metadata">

**Author:** ![mmahrle](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ed8c4c/32.png) [@mmahrle](https://www.epiusers.help/u/mmahrle)\
**Post date:** [September 8, 2017, 5:43pm UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/5 "2017-09-08T17:43:17Z")

</div>

Thanks. I’ll take a look.

---

<div class="post-metadata">

**Author:** ![mmahrle](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ed8c4c/32.png) [@mmahrle](https://www.epiusers.help/u/mmahrle)\
**Post date:** [September 8, 2017, 6:32pm UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/6 "2017-09-08T18:32:46Z")

</div>

Well, I took a look at the example and came up with a version that I think will do what I need but, when trying to save it I get the server side error that several types exist in more than one dll. I think I’m up the proverbial creek on this. Apparently this can be overcome using an external dll (according to Jose in another item) but I’m not sure how to go about that. Any pointers?

---

<div class="post-metadata">

**Author:** ![danbedwards](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/9f8e36/32.png) [@danbedwards](https://www.epiusers.help/u/danbedwards)\
**Post date:** [September 8, 2017, 6:55pm UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/7 "2017-09-08T18:55:58Z")

</div>

You are correct about having to use an external but you can also get around this using a data directive but that could take some work.

---

<div class="post-metadata">

**Author:** ![mmahrle](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ed8c4c/32.png) [@mmahrle](https://www.epiusers.help/u/mmahrle)\
**Post date:** [September 9, 2017, 12:34am UTC](https://www.epiusers.help/t/any-way-to-copy-ud-fields-from-quote-to-order-without-code/40257/8 "2017-09-09T00:34:14Z")

</div>

Ok, you’ve been very helpful so far so I’ll go for one more question. I’ve been trying to come up with an in-transaction data directive that will do what I need but haven’t had any luck getting one to fire when I need it.  
I’m trying on the OrderHed table, when OrderNum changes (actually, I’ve tried a number of conditions without much luck) but it fires multiple times before my pre-processing method directive but not after.  
So, any insight into how to configure a data directive that doesn’t fire until after the method directive on Quote.CreateOrder would be great. Or, if there’s some other approach that would be better?
