FMS

Hi All,

I have the following situation.

1. Inventory stock is taken in meter.

2. An item is of 2,...,6 mtr.

3. Made 2 UDFs

3.1 Length of an item in meter(drop down of 2,...,6)

3.2 Actual stock in piece.

4. I want to have a FMS so that when i give value in 3.1, 3.2 will be filled in as [Stock/3.1 UDF)

5. Wrote a query like

Select T0.[U_Stock_in_pcs] as T1.[OnHand]/T0.[U_meter_per_piece] from OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode

Regards,

Rupa