cancel
Showing results for 
Search instead for 
Did you mean: 

FMS

Former Member
0 Kudos
146

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member1269712
Active Contributor
0 Kudos

Hi Rupa,

Try any one ...

select T2.OnHand/T1.U_meter_per_piece from (select $[rdr1.Itemcode] Item,$[rdr1.whscode] whs) T0
inner join OITM T1 on T0.Item = T1.ItemCode INNER JOIN OITW T2 ON T0.Item = T2.ItemCode and T0.whs = T2.WhsCode

select T1.OnHand/T0.U_meter_per_piece as stock from OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode where 
T0.ItemCode =  $[rdr1.Itemcode] and T1.WhsCode =$[rdr1.whscode]

Thanks

Sachin

Answers (1)

Answers (1)

Former Member
0 Kudos

select T1.[OnHand]/T0.[U_meter_per_piece] as stock from OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode where T0.[ItemCode] = 'F100040' and T1.[WhsCode] ='03'