# \[SOLVED\]-Update-able BAQ for Labor Approval/Activity **URL:** \ **Category:** Epicor ERP 10\ **Tags:** baq, e10\ **Created:** [May 17, 2017, 3:57pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482 "2017-05-17T15:57:15Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Joe\_Tahan](https://www.epiusers.help/user_avatar/www.epiusers.help/joe_tahan/32/17546_2.png) [@Joe\_Tahan](https://www.epiusers.help/u/Joe_Tahan)\ **Post date:** [May 17, 2017, 3:57pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/1 "2017-05-17T15:57:15Z")
“A Labor Detail Record is either active or has not been approved”- Epicor 10.0.700.2 i know this is an old issue and i have tried looking for the BAQ that helps me get around this 10.0.700.2 bug. I created an updateable BAQ using LaborDtl (maybe that’s my problem) while following countless videos on how to make a BAQ updateable. On my BAQ i have the active trans checkbox which can be changed in my dashboard but, like every other updateable field, i cant save the change. I am trying to change the TimeStatus on jobs that i am unable to close due to the error mentioned in the beginning of this post. i have taken some screenshots hoping someone can point out my mistakes. My BAQ main screen: ![](https://epiusers.help/uploads/default/original/2X/0/0c71821389238c0abf3c0afcb398895611000f86.JPG) My selected Table: ![](https://epiusers.help/uploads/default/original/2X/c/c4f8652ae5a837464a5f9c4a4e22bf41122b95b5.JPG) The fields in my BAQ: ![](https://epiusers.help/uploads/default/original/2X/0/0946f388db5decccee30ac7d4c215c551ef41a0d.JPG) The Updateable BAQ screen: ![](https://epiusers.help/uploads/default/original/2X/f/fdcf929ad0b4c6ad754483b045bde635d2820b07.JPG) Update Processing: ![](https://epiusers.help/uploads/default/original/2X/b/b7d30969f6a204611100151f1e23871540c40e32.JPG) After creating the dashboard (before deployment): ![](https://epiusers.help/uploads/default/original/2X/8/8a0cdcb762248232496ab182a29bd2035fe8f837.JPG) Do i need to do anything in the screen below?: ![](https://epiusers.help/uploads/default/original/2X/4/40ad439f7e3b0ec56e9a9e0236cb5bc872a21934.JPG) And then Whenever i try and save my changes i am faced with he following error: ![](https://epiusers.help/uploads/default/original/2X/d/d89125d3495a6c75fe564db222e9a1c94773a733.JPG) ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [May 17, 2017, 6:48pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/2 "2017-05-17T18:48:16Z")
If you call service, they will send you one already made to fix those records. The one they sent me uses the LaborDtlSearch instead of LaborDtl. I attached the BAQ they sent me, but we are on 10.0.700.4, I’m not sure if that will go backwards to .2 or not. [UBAQlaborUPDE10.baq](https://epiusers.help/uploads/default/original/2X/5/53bcf0d3bfc687a28cacdbea12c8c12608db5712.baq) (58.7 KB) ![](https://epiusers.help/uploads/default/original/2X/6/650c4905428882e3902cc03ab0ca710a7c581b0f.png) ---
**Author:** ![Joe\_Tahan](https://www.epiusers.help/user_avatar/www.epiusers.help/joe_tahan/32/17546_2.png) [@Joe\_Tahan](https://www.epiusers.help/u/Joe_Tahan)\ **Post date:** [May 25, 2017, 6:33pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/3 "2017-05-25T18:33:39Z")
it actually imported without an issue. I was able to change the time status of the jobs we needed to close. Thank you for your help ---
**Author:** ![itdeptCT](https://www.epiusers.help/letter_avatar_proxy/v4/letter/i/ba9def/32.png) [@itdeptCT](https://www.epiusers.help/u/itdeptCT)\ **Post date:** [April 3, 2018, 11:02am UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/4 "2018-04-03T11:02:10Z")
does anyone have the same baq but for version 9.05.607B? we just had an employee clock out for the day and not close out his job. Any help will be greatly appreciated? thanks. ---
**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\ **Post date:** [April 3, 2018, 3:14pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/5 "2018-04-03T15:14:00Z")
You can do it from the Epicor Admin Tools. I only made my UBAQ because it happened a lot and I wanted someone else to handle it. 8920 End Activity on Labor Detail Trans. 8930 would do the same for a LaborHed The E9 UBAQ is straightforward the screenshots above would work in 9 also. I would send you mine, but it is 905.702A. ---
**Author:** ![itdeptCT](https://www.epiusers.help/letter_avatar_proxy/v4/letter/i/ba9def/32.png) [@itdeptCT](https://www.epiusers.help/u/itdeptCT)\ **Post date:** [April 3, 2018, 3:45pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/6 "2018-04-03T15:45:05Z")
if you can send me it I could try to import it. Thanks. ---
**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\ **Post date:** [April 3, 2018, 3:52pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/7 "2018-04-03T15:52:23Z")
here is the baq and the screen shots to make it. [update labordtl.dbd.baq](https://epiusers.help/uploads/default/original/2X/a/afb5ee9a89af103c41b3bfb0591f1118aab21065.baq) (14.1 KB) ![image](https://epiusers.help/uploads/default/original/2X/8/83a7fef87d10df07adc4637d220daf11b24bc285.png) ![image](https://epiusers.help/uploads/default/original/2X/c/c681690795de1c6562e67d8d584c8fea60f888d0.png) ![image](https://epiusers.help/uploads/default/original/2X/e/e7f400c9eda29c56f97ecc7c89e2cf2d843b7cff.png) ![image](https://epiusers.help/uploads/default/original/2X/1/1810b5beae2e65089127d00408aced7ffd695191.png) ---
**Author:** ![itdeptCT](https://www.epiusers.help/letter_avatar_proxy/v4/letter/i/ba9def/32.png) [@itdeptCT](https://www.epiusers.help/u/itdeptCT)\ **Post date:** [April 3, 2018, 4:17pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/8 "2018-04-03T16:17:06Z")
how did you get that where to show up on the first image? ---
**Author:** ![itdeptCT](https://www.epiusers.help/letter_avatar_proxy/v4/letter/i/ba9def/32.png) [@itdeptCT](https://www.epiusers.help/u/itdeptCT)\ **Post date:** [April 3, 2018, 4:21pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/9 "2018-04-03T16:21:05Z")
nevermind lol filled out wrong area. long day so far lol ---
**Author:** ![itdeptCT](https://www.epiusers.help/letter_avatar_proxy/v4/letter/i/ba9def/32.png) [@itdeptCT](https://www.epiusers.help/u/itdeptCT)\ **Post date:** [April 3, 2018, 5:04pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/10 "2018-04-03T17:04:12Z")
Thanks very much for helping. It worked. It allowed me to make it not active to delete the transaction. ---
**Author:** ![gpayne](https://www.epiusers.help/user_avatar/www.epiusers.help/gpayne/32/55751_2.png) [@gpayne](https://www.epiusers.help/u/gpayne)\ **Post date:** [April 3, 2018, 5:56pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/11 "2018-04-03T17:56:53Z")
Your Welcome Greg ---
**Author:** ![danag](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@danag](https://www.epiusers.help/u/danag)\ **Post date:** [March 21, 2019, 5:13pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/12 "2019-03-21T17:13:55Z")
Am new to Epicor 10…I have downloaded the suggested updateable BAQ suggested in above string. However, all transactions are “A” and no “ActiveTrans” boxes are checked…so I am not sure for what to check on next to be able to successfully close several jobs. thanks ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [March 21, 2019, 5:29pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/13 "2019-03-21T17:29:26Z")
Do you have the exact same error message when you are trying to close the job? > [@](#): > > “A Labor Detail Record is either active or has not been approved” Or does it say something else? ---
**Author:** ![danag](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@danag](https://www.epiusers.help/u/danag)\ **Post date:** [March 21, 2019, 5:30pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/14 "2019-03-21T17:30:25Z")
yes ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [March 21, 2019, 5:33pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/15 "2019-03-21T17:33:17Z")
Without clicking around in your system I’m not sure. My hunch is that there is one that you just aren’t seeing. Did you add filters to the BAQ so that only ones that aren’t “A” are showing? How many rows returned when you ran the BAQ? ---
**Author:** ![danag](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@danag](https://www.epiusers.help/u/danag)\ **Post date:** [March 21, 2019, 5:41pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/16 "2019-03-21T17:41:48Z")
Ok, I just noticed the file/field for Status did not actually update from E to A. Received the Query Execution Message below. I had one row of 162 with Status = E Severity: Exception, Table: LaborDtl, Field: , RowID: 4847c7f6-f193-478c-b959-2e85c53405df, Text: This function is not allowed. Query returned 1 row(s). ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [March 21, 2019, 5:45pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/17 "2019-03-21T17:45:16Z")
Can you post a screen shot please. ---
**Author:** ![danag](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@danag](https://www.epiusers.help/u/danag)\ **Post date:** [March 21, 2019, 5:59pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/18 "2019-03-21T17:59:05Z")
if we are a ‘hosted-SAS’ site are updateable BAQ’s going to work? thanks ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [March 21, 2019, 6:00pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/19 "2019-03-21T18:00:07Z")
I think so. That would be a question for @Mark_Wonsil. But the UBAQ doesn’t run any custom code, so I don’t see it being a problem. ---
**Author:** ![Mark\_Wonsil](https://www.epiusers.help/user_avatar/www.epiusers.help/mark_wonsil/32/51594_2.png) [@Mark\_Wonsil](https://www.epiusers.help/u/Mark_Wonsil)\ **Post date:** [March 21, 2019, 6:16pm UTC](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482/20 "2019-03-21T18:16:09Z")
> [@danag](#): > > if we are a ‘hosted-SAS’ site are updateable BAQ’s going to work? Are you Multi-Tenant or Public Cloud/Dedicated Tenant @danag? [Next page](https://www.epiusers.help/t/solved-update-able-baq-for-labor-approval-activity/38482.md?page=2)