# Updateable BAQ no error not updating **URL:** \ **Category:** Epicor ERP 10\ **Tags:** updatable-baq, e10\ **Created:** [May 24, 2022, 4:40pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764 "2022-05-24T16:40:35Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [May 24, 2022, 4:40pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/1 "2022-05-24T16:40:35Z")
I have and updateable BAQ that I am trying to update the purchase direct (buyit) column on jobmtl. There are no errors but it isn’t updating. I have jobhead jobasmbl and jobmtl tables and the update is written correctly because it doesn’t error out and can change the warehouse column. it just doesn’t update the buyit column. Any idea why this is happening? ---
**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\ **Post date:** [May 24, 2022, 4:41pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/2 "2022-05-24T16:41:57Z")
does the update work in the BAQ editor? ---
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [May 24, 2022, 4:45pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/3 "2022-05-24T16:45:15Z")
No it doesn’t. ---
**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:** [May 24, 2022, 4:49pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/4 "2022-05-24T16:49:28Z")
I think we will have to see the UBAQ. ---
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [May 24, 2022, 4:51pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/5 "2022-05-24T16:51:37Z")
is this what you want to see? ![image](https://www.epiusers.help/uploads/default/original/3X/8/3/837bf77e3fd0e2e80b88bb179f7d3cb36c7e5b4d.png) ---
**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:** [May 24, 2022, 4:54pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/6 "2022-05-24T16:54:05Z")
Yes, that looks ok, how about the tab Update \> General Properties? ---
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [May 24, 2022, 4:55pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/7 "2022-05-24T16:55:23Z")
Keep in mind it works on other fields just not the buyit field ![image](https://www.epiusers.help/uploads/default/original/3X/a/0/a0037b77dabee4ae25e192599e8384e3412821e2.png) ---
**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:** [May 24, 2022, 4:58pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/8 "2022-05-24T16:58:05Z")
I reproduced your issue on my end. I setup the simple UBAQ to update the buyit field. Although the BAQ editor returns no error, the field is not updated. ---
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [May 24, 2022, 5:07pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/9 "2022-05-24T17:07:35Z")
I’m confused as to why because I can update it on the Job no problem. ---
**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:** [May 24, 2022, 5:15pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/10 "2022-05-24T17:15:34Z")
Running a trace shows that the system executes these methods when updating the material buyit field: Erp.Proxy.BO.JobEntryImpl.CheckJobMtlBuyIt() Erp.Proxy.BO.JobEntryImpl.ChangeJobMtlBuyIt() Erp.Proxy.BO.JobEntryImpl.Update() I hate to direct you down this path if it is not warranted, but you may need to write a more advanced BPM for handling this update. ---
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [May 24, 2022, 5:17pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/11 "2022-05-24T17:17:10Z")
I was thinking that but wanted to see if I was missing something first. ---
**Author:** ![afabian](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/c67d28/32.png) [@afabian](https://www.epiusers.help/u/afabian)\ **Post date:** [May 24, 2022, 8:53pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/12 "2022-05-24T20:53:46Z")
Take a look at KB0107523 - Updatable BAQ - How to update JobMtl.BuyIt. [https://epicorcs.service-now.com/epiccare?id=epiccare\_kb\_article&sys\_id=KB0107523](https://epicorcs.service-now.com/epiccare?id=epiccare_kb_article&sys_id=KB0107523) ---
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [May 24, 2022, 9:16pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/13 "2022-05-24T21:16:35Z")
I do not have access to the epicare portal at this time. can you tell me what the solution is? ---
**Author:** ![afabian](https://www.epiusers.help/letter_avatar_proxy/v4/letter/a/c67d28/32.png) [@afabian](https://www.epiusers.help/u/afabian)\ **Post date:** [May 24, 2022, 9:18pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/14 "2022-05-24T21:18:10Z")
**Issue** In a Updatable BAQ cannot updating table JobMtl, field BuyIt is not saving. **Error** N/A **Resolution** 1. Add a bit calculated field to the Updatable BAQ named dspBuyIt and in the expression set it equal to JobMtl.BuyIt 2. Move to Update \> General Properties 3. For field Calculated\_dspBuyIt check Updatable. 4. Move to Update \> Update Processing tab. 5. In the Query To Object Column Mapping click Expression Editor. File \> New Table = JobMtl Field = dspBuyit Expression = ttResult.Calculated\_dspBuyIt 6. File \> Save 7. File \> Exit out of Expression Editor 8. Move to Object to Query Column Mapping tab and click Expression Editor. File \> New Table = ttResult Field = Calculated\_dspBuyIt Expression = JobMtl.dspBuyIt 9. File \> Save 10. File \> Exit out of Expression Editor 11. Move to Analyze tab. 12. Click Get List button. 13. Double click on a row to update and check dspBuyIt. 14. Click Update button 15. Click Clear Grid 16. Click Get List to confirm that the record was updated. ---
**Author:** ![MattSpotts](https://www.epiusers.help/user_avatar/www.epiusers.help/mattspotts/32/101155_2.png) [@MattSpotts](https://www.epiusers.help/u/MattSpotts)\ **Post date:** [August 1, 2022, 6:05pm UTC](https://www.epiusers.help/t/updateable-baq-no-error-not-updating/90764/15 "2022-08-01T18:05:41Z")
Excellent Thank you