Insert Calculated field in BAQ to UD field

Kinetic ERP
1

Hi,

I am trying to have all the lines in APTran description for each HeadNum to come out as 1 line and have this inserted into the Checkhed table.

I have a calculated BAQ field that combines 3 lines in APTran description table into 1 line. When I tested with UBAQ I can see that I can update my Description UD field in the CheckHed table.

However, using BPM thought I could do the same with the Query setter fields but found that they don’t have calculated field settings.

Does this mean I have to code it? Any advice as the combine string is using string_agg() and I’m not sure how to do the equavalent in code. My other solution is to figure out how to get the BAQ calculated field value and insert that in filter by the headnum field.

2

Are you sure you can’t set the UD field? I know for a fact that I’ve set UD fields using a UBAQ. I can’t remember if I’ve ever tried to set a UD field = a calculated value using the field setters. If that doesn’t work, you may have to add a pre-processing BPM on Update to set the value of the UD field = the calculated field value. Are you using Classic or Kinetic BAQ Designer? I’ll put some screenshots together.

3

I can set the fields in UBAQ but I’m not sure how to use the BPM with the Setter category to update it. Its fine already, I use the Execute code to do the exact same things already.

1 Like