Updateable BAQ no error not updating

Epicor ERP 10
,
1

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?

2

does the update work in the BAQ editor?

3

No it doesn’t.

4

I think we will have to see the UBAQ.

5

is this what you want to see?

image
image1569×823 39.6 KB

6

Yes, that looks ok, how about the tab Update > General Properties?

7

Keep in mind it works on other fields just not the buyit field

image
image877×395 9.28 KB

8

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.

9

I’m confused as to why because I can update it on the Job no problem.

10

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.

11

I was thinking that but wanted to see if I was missing something first.

12

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

13

I do not have access to the epicare portal at this time. can you tell me what the solution is?

14

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.
2 Likes
15

Excellent Thank you