Skip to Content
0
Apr 24, 2014 at 02:38 PM

Sales order

84 Views

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