Cannot get tick box to update on a UBAQ

Epicor ERP 10
1

I’m very new to creating BAQs and have created one for updating jobs and marking them as “purchase direct”, however even though everything else is working, it will not update the checkbox on the jobs and no errors are given. I found the below on another thread but it is a few years old and likely not relevant to our version and I cannot make sense of it. I found the calculated field editor but no real idea what I am doing. Does someone have a more up to date guide?

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

Have you tried it as a base update using the JobEntry BO?

1 Like
3

The issue is that the dataset for Job has another field, DspBuyit, and the database only has one field field, BuyIt. So while you are trying to change the database field, the BO is expecting a field of a different name as well.

I don’t know what version you are on, but I’m 99% sure that those instructions should work fine. The piece you probably don’t understand is the this section of the updateable tab. You need to set this in step 8. This tells the Business object what the tableset field dspBuyit is supposed to be.

image
image1078×765 45.8 KB

(note that this screen shot is just to show you were the button is, not how to set up your fields, so don’t use that as reference)

2 Likes
4
2 Likes
5

Thanks, I managed to figure it out. now all working using the above.

1 Like