IF (SELECT T0.[Price] FROM ITM1 T0 INNER JOIN OPLN T1 ON T0.PriceList = T1.ListNum WHERE T1.[ListName] = $[RDR1.U_SBO_PriceList] and T0.[ItemCode] = $[RDR1.ItemCode]) > $[RDR1.PriceBefDi] BEGIN (SELECT T0.[Price] FROM ITM1 T0 INNER JOIN OPLN T1 ON T0.PriceList = T1.ListNum WHERE T1.[ListName] = $[RDR1.U_SBO_PriceList] and T0.[ItemCode] = $[RDR1.ItemCode]) END
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Error converting data type nvarchar to numeric. '' (RDR1)
Sales
PriceList
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)