Skip to Content
0
Dec 12, 2018 at 09:15 AM

Formatted Search

109 Views

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 :

SELECT t1.onhand-t2.u_EndB

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.

thanks

Attachments

capture.png (28.9 kB)