Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

FMS not running in sap b1 hanna

Dear All,

I create a UDF on Inventory Transfer screen and make a FMS Query but a error occurred. please see below mention query and advice.

IF $[OWTR."U_grn"] > 0

SELECT T1.["Quantity"] FROM OPDN T0  INNER JOIN PDN1 T1 ON T0.["DocEntry"] = T1.["DocEntry"]

WHERE T1.["ItemCode"] = $[WTR1."ItemCode"] and  T0.["DocNum"] = $[OWTR."U_grn"]

else if

$[OWTR."U_RFPN"] > 0

SELECT T1.["Quantity"] FROM OIGN T0  INNER JOIN "VISIONTEST"."IGN1" T1 ON T0.["DocEntry"] = T1.["DocEntry"]

WHERE T0.["DocNum"] = $[OWTR."U_RFPN"] and T1.["ItemCode"] = $[WTR1."ItemCode"]

Former Member
Not what you were looking for? View more on this topic or Ask a question