Dynamics Community Forum Thread Details

Hi. all,

I am facing the issue that the system prompt the error: [SQL Server]Conversion failed when converting the nvarchar value 'Ǵ' to data type int. I have no idea what it happen. I am appreciate you can give me some hints. Thank you very much!

Object Server 02: The database reported (session 4 (chy)): [Microsoft][SQL Native Client][SQL Server]Conversion failed when converting the nvarchar value 'Ǵ' to data type int.. The SQL statement was: "
SELECT A.PURCHID,A.ORDERACCOUNT,A.INVOICEACCOUNT,A.PACKINGSLIPID,A.INTERCOMPANYPOSTED,A.DELIVERYDATE,A.DELIVERYNAME,A.DELIVERYADDRESS,A.QTY,A.VOLUME,
A.WEIGHT,A.PRINTED,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.DIMENSION5_,A.COUNTRYREGIONID,A.INTRASTATDISPATCH,A.DLVTERM,A.DLVMODE,
A.REQUISITIONER,A.DLVZIPCODE,A.DLVCOUNTY,A.DLVCOUNTRYREGIONID,A.DLVSTATE,A.LEDGERVOUCHER,A.DELIVERYTYPE,A.PURCHASETYPE,A.RETURNITEMNUM,A.FREIGHTSLIPNUM,
A.FREIGHTSLIPTYPE,A.PARMID,A.ITEMBUYERGROUPID,A.INTERNALPACKINGSLIPID,A.DELIVERYCITY,A.DELIVERYSTREET,A.REQATTENTION,A.NUMBERSEQUENCEGROUP,A.INTERCOMPANYCOMPANYID,
A.INTERCOMPANYSALESID,A.INTERCOMPANYLEDGERVOUCHER,A.LANGUAGEID,A.CURRENCYCODE,A.GAR_DLVNOTENUM,A.MODIFIEDDATETIME,A.MODIFIEDBY,A.CREATEDDATETIME,A.CREATEDBY,A.RECVERSION,
A.RECID,B.PACKINGSLIPID,B.DELIVERYDATE,B.LINENUM,B.INVENTTRANSID,B.DESTCOUNTRYREGIONID,B.ITEMID,B.EXTERNALITEMID,B.NAME,B.ORDERED,B.QTY,B.REMAIN,B.PURCHASER,B.PRICEUNIT,
B.DIMENSION,B.DIMENSION2_,B.DIMENSION3_,B.DIMENSION4_,B.DIMENSION5_,B.VALUEMST,B.PARTDELIVERY,B.INVENTREFID,B.INVENTREFTYPE,B.PURCHID,B.PURCHUNIT,B.TRANSACTIONCODE,
B.INVENTREFTRANSID,B.INTERCOMPANYINVENTTRANSID,B.DESTSTATE,B.ORIGPURCHID,B.RETURNACTIONID,B.TRANSPORT,B.INTERNALPACKINGSLIPID,B.INVENTDIMID,B.STATPROCID,B.PORT,
B.INVENTDATE,B.NUMBERSEQUENCEGROUP,B.DESTCOUNTY,B.INTRASTATDISPATCHID,B.INVENTQTY,B.TRANSORDFLAG,B.NHG_PACKINGREVERED,B.NHG_REQPAYMENTQTY,B.NHG_REQPAYREMAINQTY,
B.NHG_AMOUNTCUR,B.NHG_UNITPRICECUR,B.NHG_TRANSFERED,B.GAR_RETURNQTYREMARK,B.NHG_RTNQTY,B.NHG_RTNTTLQTY,B.LTS_SENDWEIGHT,B.LTS_REMARK,B.LTS_DATEACCOUNTCHECK,
B.LTS_ISFINISH,B.LTS_APPLEVELONE,B.LTS_APPLEVELONEBY,B.LTS_APPLEVELONEDATE,B.LTS_APPLEVELTWODATE,B.LTS_APPLEVELTWOBY,B.LTS_APPLEVELTWO,B.LTS_APPROVESTATUS,
B.GAR_PACKSLIPWEIGHT,B.PORETURNPACKSLIPID,B.LTS_INTERCOMPVPSTREFRECID,B.LTS_INTERCOMPCOMPANYID,B.QTYSEC,B.ORDEREDSEC,B.MODIFIEDDATETIME,B.MODIFIEDBY,B.CREATEDDATETIME,
B.CREATEDBY,B.RECVERSION,B.RECID,C.PURCHID,C.LINENUM,C.ITEMID,C.PURCHSTATUS,C.SHIPPINGDATEREQUESTED,C.LEDGERACCOUNT,C.DELIVERYDATE,C.NAME,C.TAXGROUP,C.QTYORDERED,
C.PURCHRECEIVEDNOW,C.REMAINPURCHPHYSICAL,C.REMAINPURCHFINANCIAL,C.PRICEUNIT,C.PURCHPRICE,C.CURRENCYCODE,C.LINEPERCENT,C.LINEDISC,C.LINEAMOUNT,C.EXTERNALITEMID,
C.PURCHUNIT,C.DIMENSION,C.DIMENSION2_,C.DIMENSION3_,C.DIMENSION4_,C.DIMENSION5_,C.CONFIRMEDDLV,C.ADDRESSREFRECID,C.INVENTTRANSID,C.VENDGROUP,C.VENDACCOUNT,
C.ADDRESSREFTABLEID,C.PURCHQTY,C.PURCHMARKUP,C.INVENTRECEIVEDNOW,C.MULTILNDISC,C.MULTILNPERCENT,C.PURCHASETYPE,C.COVREF,C.REMAININVENTPHYSICAL,C.TAXITEMGROUP,C.TRANSACTIONCODE,
C.SHIPPINGDATECONFIRMED,C.COUNTYORIGDEST,C.TAXAUTOGENERATED,C.UNDERDELIVERYPCT,C.OVERDELIVERYPCT,C.TAX1099BOX,C.TAX1099AMOUNT,C.BARCODE,C.BARCODETYPE,C.INVENTREFID,C.INVENTREFTRANSID,
C.ITEMREFTYPE,C.PROJTRANSID,C.BLOCKED,C.COMPLETE,C.REQPLANIDSCHED,C.REQPOID,C.ITEMROUTEID,C.ITEMBOMID,C.LINEHEADER,C.SCRAP,C.RETURNACTIONID,C.INTERCOMPANYORIGIN,C.PROJCATEGORYID,
C.PROJID,C.INVENTDIMID,C.TRANSPORT,C.STATPROCID,C.PORT,C.ASSETID,C.ASSETTRANSTYPEPURCH,C.ASSETBOOKID,C.PROJLINEPROPERTYID,C.PROJTAXITEMGROUPID,C.PROJTAXGROUPID,C.PROJSALESPRICE,
C.PROJSALESCURRENCYID,C.INTERCOMPANYINVENTTRANSID,C.PROJSALESUNITID,C.DELIVERYADDRESS,C.DELIVERYNAME,C.DELIVERYSTREET,C.DELIVERYZIPCODE,C.DELIVERYCITY,C.DELIVERYCOUNTY,
C.DELIVERYSTATE,C.DELIVERYCOUNTRYREGIONID,C.DELIVERYTYPE,C.CUSTOMERREF,C.CUSTPURCHASEORDERFORMNUM,C.BLANKETREFTRANSID,C.STATTRIANGULARDEAL,C.TAX1099STATE,C.TAX1099STATEAMOUNT,
C.ITEMTAGGING,C.CASETAGGING,C.PALLETTAGGING,C.REMAININVENTFINANCIAL,C.PURCHREQLINEREFID,C.DEPRECIATIONSTARTDATE,C.ACTIVITYNUMBER,C.RETURNSTATUS,C.RETURNDISPOSITIONCODEID,
C.CREATEFIXEDASSET,C.ASSETGROUP,C.REQUISITIONER,C.REQATTENTION,C.PURCHREQID,C.PURCHQTYSEC,C.QTYORDEREDSEC,C.PURCHRECEIVEDNOWSEC,C.REMAINPURCHPHYSICALSEC,C.REMAINPURCHFINANCIALSEC,
C.PURCHUNITSEC,C.TEX_REFSALESID,C.TEX_EXTERNALITEMID,C.TEX_REFPLANNEDPOQTY,C.TRANSFERDATE,C.LATESTPLANTRANDATE,C.LATESTPLANFTYDATE,C.LATESTREALPACKDATE,C.LATESTREALTRANDATE,
C.LATESTREALFTYDATE,C.SU_PURCHQTYSEC,C.SU_PURCHPRICESEC,C.TEX_REFPURCHASETYPE,C.NHG_STDUNITCONVERTID,C.GAR_SECUNITID,C.GAR_SECUNITQTY,C.GAR_VENDREPLYDATE,C.GAR_ALLRECEIVEFTYDATE,
C.GAR_LEAVEFTYDATE,C.GAR_RESERVEDFTYDATE,C.GAR_PLANARRIVEFTYDATE,C.GAR_PLANARRIVEHKDATE,C.GAR_LASTTRANSDATE,C.GAR_CUSTCOLORNAME,C.GAR_PURCHSAMPLEOK,C.GAR_REFPRICEDISCRECID,
C.TEX_SCRAPEST,C.TEX_SCRAPACTUAL,C.GAR_MINCHARGE,C.GAR_PRODPLANDATE,C.GAR_FABREADYDATE,C.GAR_PACKREADYDATE,C.TEX_SCRAPCONSTEST,C.TEX_SCRAPCONSTACTUAL,C.GAR_RETURNQTYREMARK,
C.GAR_ISARRIVAL,C.GAR_PURCHUNITRECEIVEDNOW,C.LTS_RECEIVEREMARK,C.LTS_RECEIVEVOUCHER,C.LTS_ISFINISH,C.GAR_WHITEMATERIAL,C.GAR_ITEMPRICEGROUPID,C.GAR_ADDITIONALQTY,C.GAR_ADDQTYRECEIVED,
C.GAR_SAMPLEPRICE,C.LTS_REMAINQTYPERCENT,C.LTS_FACTORYREQUESTSENDDATE,C.LTS_PREINVOICE,C.LTS_PLANCUTDATE,C.LTS_PROGRAMID_SUB,C.LTS_BATCHSHEETNUM,C.LTS_BATCHMOVEDATE,C.MODIFIEDDATETIME,
C.MODIFIEDBY,C.CREATEDDATETIME,C.DEL_CREATEDTIME,C.CREATEDBY,C.RECVERSION,C.RECID,C.TEX_REMARKNOTE
FROM VENDPACKINGSLIPJOUR A,VENDPACKINGSLIPTRANS B,PURCHLINE C
WHERE ((A.DATAAREAID=N'ABC') AND ((A.RECID=5637302633) AND (N'Ǵ'=500))) AND ((B.DATAAREAID=N'ABC') AND ((((A.PURCHID=B.PURCHID) AND (A.PACKINGSLIPID=B.PACKINGSLIPID))
AND (A.DELIVERYDATE=B.DELIVERYDATE)) AND (A.INTERNALPACKINGSLIPID=B.INTERNALPACKINGSLIPID))) AND ((C.DATAAREAID=N'ABC') AND (C.INVENTTRANSID=B.INVENTTRANSID))
AND EXISTS (SELECT 'x' FROM INVENTTRANS D WHERE ((D.DATAAREAID=N'ABC') AND (((D.INVENTTRANSID=C.INVENTTRANSID) AND (D.VOUCHERPHYSICAL=A.LEDGERVOUCHER)) AND (D.STATUSRECEIPT<>1))))"