Good Day Experts.
I was create UDT for Sales Qutation, my formula is "Stock on hand" - "ending bal" = Quantity
Now i created fms for quantity :
FROM OITM T0 INNER JOIN OITW T1 ON T0.[ItemCode] = T1.[ItemCode]
left join qut1 T2 on t1.itemcode=t2.itemcode left join oqut t3 on t2.docentry=t3.docentry
WHERE T1.[WhsCode]='FGResale' and T1.Onhand>0 and T1.ItemCode=$[$38.1.0]
When I put it to UDV and run the output was 0 quantity.