Skip to Content
0
Former Member
May 26, 2016 at 06:37 AM

Query in Inventory Transfer

101 Views

Hi,

I have created a line UDF(U_UnitPrice) in Inventory Transfer.

This UDF draws the value according to rules:

- If the IT is copied from ITR, it draws the value of U_UnitPrice of ITR.

- If the IT is standalone, it draws the value from a price list.

The query I used is:

case when (ISNULL($[$38.43.0], -1) > -1)

then select $[$38.U_UnitPrice.0]

else

select T0.[Price] FROM ITM1 T0

where T0.[ItemCode] = $[WTR1.itemcode] and T0.[PriceList] = 24

end

The value cannot be drawn.The error message is "Incorrect syntax near the keyword 'case'.

Please help!