Whenever I try to update the purchase direct field on a job material in an updatable query it will switch back to it’s original state. I have another field on the same query that updates fine so I don’t think the update settings are wrong.
Has anyone else experienced this?
You basically need to set the field dspBuyIt in the updatable BAQ but there is not an easy way to do this. You can do this by directly changing the BPM code and setting dspBuyIt = to the same as BuyIt
– or –
The below assumes you already have an updatable BAQ setup and working with JobMtl
Add a calculated field to your BAQ named dspBuyIt (Calculated_dspBuyIt) and in the expression set it equal to JobMtl.BuyIt
Next, in the General Properties of the Update add the field Calculated_dspBuyit and flag it updatable
In the Update Processing tab
Query to Object Column Mapping ADD the following
MapTableName = JobMtl
MapFieldName = dspBuyit
Expression = ttResult.Calculated_dspBuyit
the other fields will default
Object to Query Column Mapping ADD the following
MapTableName = ttResult
MapFieldName = Calculated_dspBuyIt
Expression = JobMtl.dspBuyIt
the other fields will default
Thank you Dan, this works great! I used that second method you mentioned
Dan, I followed the second method as well but when I go to save/analyze I get the message
“Expression for JobMtl.dspBuyIt contains non-existent result column”
Epicor 10.1.600.8
Not sure what I am missing?