Skip to Content
avatar image
Former Member

Conversion Failed when converting the nvarchar value '164465 164462' to data type int.

We have a query that is to show all open service calls with Deliveries but we are getting this error now. we are on SAP B1 9.2

This is the query

SELECT T0.[DocNum] as 'Service Call #', T0.[customer], T0.[custmrName], T0.[U_PRR] , T1.[DocNum] AS 'Delivery#', T1.[DocDueDate] as 'Ship Date', T1.[PickRmrk] as 'Return Label' FROM OSCL T0, ODLN T1 WHERE T0.[DocNum] = T1.[U_INVTRNSF] and T0.[status] ='-3'

nvar-error.png (4.3 kB)
SQL
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers