Skip to Content
0

Help in FMS to show passport number of a Row Owner in sales order

Jan 11 at 07:09 AM

30

avatar image
Former Member

I have a client who wants to see Passport Number for every Row Owner in the sales order. The owner is linked to the OHEM table and I have created an FMS query to bring out the passport number in a UDF i have created at Sales Order row level. But the problem I am facing is that the Owner column field is a Variable.

i have created this query; SELECT T0."passportNo" FROM OHEM T0 WHERE T0."lastName"=$[$38.260.0]. Its not working. The '260' I have put on $[$38.260.0] is the column.

Please help me

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jan 17 at 01:25 PM
0

Managed to find the solution

Share
10 |10000 characters needed characters left characters exceeded