Formatted search on header level UDF

[former_member418241]

Hi All

How do you call a UDF at Warehouse header level into purchase order row level?

Thanks

SV Reddy

[former_member204969 · Accepted solution]

Try something like this:

Select w.U_udfname From OWHS w Where w.WhsCode=$[$38.24]

[former_member418241]

Hi Mr IstVan,

thanks for the reply. it is working exactly fine and the poblem is solved points assigned

thanks

SV Reddy

[former_member303406]

HI,

and what if the Warehouse code is located in a UDF at header level of the marketing document ?? I mean, how can we access a UDF value in a FMS ?

We tried the following, but it didn't work :

SELECT T0.OnHand
    FROM OITW T0
    WHERE T0.ItemCode=$[$38.1.0]
    AND T0.WhsCode=$[$U_Nwr_WH.0.1]

And it seems that the UDF do not have number assigned to it so we can't use the following syntax

$[$99.0.1]

...

thanks,

Luce

Edited by: Luce Veilleux on Nov 26, 2009 4:32 PM

[former_member204969]

Try this form for a SO::

SELECT T0.OnHand
FROM OITW T0
WHERE T0.ItemCode=$[$38.1.0]
AND T0.WhsCode=$[ORDR.U_Nwr_WH]

(And sending your code use the Click to display text as code icon to make it more readable.)

[former_member303406]

Thanks for your quick reply.

I knew that we could insert the table name in the query... But if I want this FMS to be "generic" for ALL marketing documents, is there a way where I can specify a unique ID as it is the cas for the card codes which are

$[$4.1.0]

?

I would like to avoid the creation of 8 different FMS, one for each document...

thanks,

Luce

[former_member370721]

How about something like

Select 'Fieldname' FROM 'Tablename' .... WHERE ....