Hello ,
In SAP B1 rdr1 table 'free text' field hold the original value of price , even if I change the value of price free text field holds the old value, I need to compare these two fields as not equal like
SELECT T0.[DocNum] FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[Price] <> T1.[FreeTxt]
to get all the sales order numbers where there was a price change.
But this gives me error as 'error converting nvarchar to numeric.
So pls help me to resolve this .
Rgds
Suman