How to populate several item UDF fields into one header UDF field?

Question

I have created 5 UDF fields in item master using SAP Business One as you can see in the below picture:

Now I want to fetch those 5 UDF value in Bill of material (BOM)'s header level UDF field 'Drawing no' as you can see in the below picture:

As of now only one value is coming from list of 5 UDF fields i.e 'abc' as you can see in the second picture.

Could you please help me to populate all 5 UDF field in 'Drawing no' in picture 2?

How is the question related to [tag:flash-media-server]? – Sandra Rossi Mar 19 '23 at 10:40 — Sandra Rossi, Mar 19 '23 at 10:40
No - it is related to SAP Business One – anamika Singh Mar 21 '23 at 06:43 — anamika Singh, Mar 21 '23 at 06:43

score 1 · Answer 1 · answered Mar 22 '23 at 08:32

Using a User Defined Query you should be able to Concatenate your multiple fields

Choose " Search in Existing User-Defined Values According to Saved Query "

The Query Should look similar to this:

SELECT T0.[myUdf1] + T0.[myUdf2]  FROM OITM T0 WHERE T0.[ItemCode] = $[$4.0.0]

1 Answers1