# Using CheckECORevApproved and ChangeECORevApproved

**URL:** <https://www.epiusers.help/t/using-checkecorevapproved-and-changeecorevapproved/58574>\
**Category:** Epicor ERP 10\
**Tags:** ubaq, bpm\
**Created:** [August 9, 2019, 1:17pm UTC](https://www.epiusers.help/t/using-checkecorevapproved-and-changeecorevapproved/58574 "2019-08-09T13:17:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![NateS](https://www.epiusers.help/user_avatar/www.epiusers.help/nates/32/18519_2.png) [@NateS](https://www.epiusers.help/u/NateS)\
**Post date:** [August 9, 2019, 1:17pm UTC](https://www.epiusers.help/t/using-checkecorevapproved-and-changeecorevapproved/58574/1 "2019-08-09T13:17:27Z")

</div>

Good morning,  
I am working on an updatable BAQ that will change Resource Group IDs for Parts. I already used a ton of help from this group to get this working for the open jobs. Now I am working in the Engineering Workbench, trying to update the master parts. See this related post for reference:

> [@Change Resource Group ID for Open Jobs](https://www.epiusers.help/t/change-resource-group-id-for-open-jobs/57999):
>
> Hi Everyone! I am working on a custom dashboard containing a rather simple BAQ. The goal is to update the Resource Group IDs for all open jobs. For example I want to change any instance of resource group ID = “12VA” to “4A”. To keep things flexible, my approach is to provide the user a small form requesting the old resource group ID, and the new resource group ID. After the user enters the old resource group ID, they will click a button, populating the grid with the jobs and operations that w…

Back to the task at hand. When I try to use the engineering workbench methods CheckECORevApproved, and ChangeECORevApproved, I get an error: “ECORev has not changed.”

Below I have clipped some of the variations that I have tried.

 ![Capture22](https://www.epiusers.help/uploads/default/original/3X/7/9/7981c03273a43848bf996d155bc5adfd5fa31dd0.jpeg)  
The UpdateTableByQuery does this:  
 ![Capture24](https://www.epiusers.help/uploads/default/original/3X/8/0/801423b8605e9d1f31a45cf8532f09dc77dab4ea.jpeg)

**Can anyone tell me what the proper way is to utilize these methods in a BPM?**

The traces I ran all seem to indicate only these methods:  
 ![Capture23](https://www.epiusers.help/uploads/default/original/3X/c/1/c132e0bfd647e897b2557c1e51e0fc5c4abf376a.jpeg)

My goal is to take a part/rev that has been checked out into my temporary group, unapprove the part/rev so that changes can be made, make the requested change\*, then reapprove the part and check it back in.  
\*I will be changing the ResourceGroupID for specific operations in the selected part/rev.

Thanks for your time!  
Nate

---

<div class="post-metadata">

**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\
**Post date:** [August 9, 2019, 4:54pm UTC](https://www.epiusers.help/t/using-checkecorevapproved-and-changeecorevapproved/58574/2 "2019-08-09T16:54:33Z")

</div>

As a very general idea, when you are modding those records, are you also setting RowMod = “U”?

---

<div class="post-metadata">

**Author:** ![NateS](https://www.epiusers.help/user_avatar/www.epiusers.help/nates/32/18519_2.png) [@NateS](https://www.epiusers.help/u/NateS)\
**Post date:** [August 9, 2019, 4:59pm UTC](https://www.epiusers.help/t/using-checkecorevapproved-and-changeecorevapproved/58574/3 "2019-08-09T16:59:06Z")

</div>

> [@Chris\_Conn](#):
>
> As a very general idea, when you are modding those records, are you also setting RowMod = “U”?

Yes, in the examples when I include the UpdateTableByQuery widget, the RowMod = “U” is part of it. The problem is that the execution never gets that far. Anytime I have a Check- or Change- ECORevApproved, I get the error.

In at least one case I put the updatetablebyquery widget before the problem methods. This didn’t help. The query worked by updating the values in the dataset, but updating the DS does not execute the check/change methods, so I really need to run those methods somehow.

Is there anyplace that details how to implement specific BO methods? I can’t find any way that those methods do not return an error. I am sure there is some underlying field that needs to be changed or something before I can execute those methods.

---

<div class="post-metadata">

**Author:** ![NateS](https://www.epiusers.help/user_avatar/www.epiusers.help/nates/32/18519_2.png) [@NateS](https://www.epiusers.help/u/NateS)\
**Post date:** [August 9, 2019, 5:09pm UTC](https://www.epiusers.help/t/using-checkecorevapproved-and-changeecorevapproved/58574/4 "2019-08-09T17:09:03Z")

</div>

> [@Chris\_Conn](#):
>
> RowMod = “U”?

So I set the rowmod first, then ran the methods. It worked! In the end this is all I did:

 ![Capture25](https://www.epiusers.help/uploads/default/original/3X/a/1/a1d2a775dbad0b1be51c09b50b71d44eb98b6130.jpeg)  
Thank you!!!

---

<div class="post-metadata">

**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\
**Post date:** [August 9, 2019, 5:34pm UTC](https://www.epiusers.help/t/using-checkecorevapproved-and-changeecorevapproved/58574/5 "2019-08-09T17:34:39Z")

</div>

Many methods requiring a RowMod, will actually clear the RowMod after they run. You have to watch Epicor, they’re sneaky
