I have a couple of Kinetic dashboards containing updatable BAQs where I’ve tried updating the JobMtl.BuyIt column, and it seems like that column doesn’t want to save changes. The material parts exist in Epicor, so the field can be updated in Job Entry. I know there is logic around whether the material part is purchased or manufactured and stock or non-stock (in Part Entry) which affects whether a material defaults on a job as purchase direct, make direct, or as a warehouse item. Perhaps I’m running up against that logic in my dashboards?
There are 2 columns in the dataset you have to change.
1 Like
Hmmm… dspBuyIt isn’t in the JobMtl table, so the BAQ update won’t work for that field - at least with my skillset. But maybe the JobEntry dataset and JobMtl data table can be pulled into a dataview and updated that way. Or maybe I can figure out a way to fire a BPM.
Thanks for the response, Brandon. It explains a lot!
You need to add a field for mapping in the BAQ.
Try this and tell me if it works.
Go here, add a new row, find DSPBuyIt and set to the BuyIt field.
1 Like
Awesome - yes that worked! Thanks!
1 Like