Skip to Content
0
Nov 20, 2012 at 05:45 PM

Help on FMS

49 Views

Hi gurus !

I want to display the warehouse location into a UDF (WTR1.U_EMP) defined at row level in the inventory transfer form (table WTR1).

Once the user selects the 'warehouse code in the field 'To Warehouse' (WTR1.WhsCode), the location should appear in the UDF.

Here is my query.

Select Location

From OLCT

Where OLCT.Code=Cast($[$23.5.0])

The query works but it displays the wrong location.

(i.e: Whse A code =01, locationA ; Whse B code =02, locationB. If I select 01, normally, the location displayed will be Location A, but here the result is LocationB)

What's the problem with my query?

Please help !

Thanks