Hi Experts,
I developed a report, but i am running it i am getting the error as shown in the above image."Cannot select a record in Customer transactions (CustTrans). Date: .
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type nvarchar to numeric.
SQL statement: SELECT T1.ACCOUNTNUM,T1.TRANSDATE,T1.VOUCHER,T1.INVOICE,T1.TXT,T1.AMOUNTCUR,T1.SETTLEAMOUNTCUR,T1.AMOUNTMST,T1.SETTLEAMOUNTMST,T1.CURRENCYCODE,T1.DUEDATE,T1.LASTSETTLEVOUCHER,T1.LASTSETTLEDATE,T1.LASTEXCHADJVOUCHER,T1.CLOSED,T1.TRANSTYPE,T1.APPROVED,T1.EXCHADJUSTMENT,T1.DOCUMENTNUM,T1.DOCUMENTDATE,T1.LASTEXCHADJRATE,T1.FIXEDEXCHRATE,T1.LASTEXCHADJ,T1.CORRECT,T1.SETTLEMENT,T1.INTEREST,T1.COLLECTIONLETTER,T1.DEFAULTDIMENSION,T1.POSTINGPROFILECLOSE,T1.EXCHRATESECOND,T1.BANKLCEXPORTLINE,T1.ACCOUNTINGEVENT,T1.EXCHRATE,T1.LASTSETTLEACCOUNTNUM,T1.COMPANYBANKACCOUNTID,T1.THIRDPARTYBANKACCOUNTID,T1.PAYMMODE,T1.PAYMREFERENCE,T1.PAYMMETHOD,T1.CASHPAYMENT,T1.CONTROLNUM,T1.DELIVERYMODE,T1.POSTINGPROFILE,T1.OFFSETRECID,T1.EUROTRIANGULATION,T1.ORDERACCOUNT,T1.CASHDISCCODE,T1.PREPAYMENT,T1.PAYMSPEC,T1.CUSTEXCHADJUSTMENTREALIZED,T1.CUSTEXCHADJUSTMENTUNREALIZED,T1.PAYMMANLACKDATE,T1.PAYMMANBATCH,T1.PAYMID,T1.BILLOFEXCHANGEID,T1.BILLOFEXCHANGESTATUS,T1.BILLOFEXCHANGESEQNUM,T1.BANKREMITTANCEFILEID,T1.COLLECTIONLETTERCODE,T1.INVOICEPROJECT,T1.LASTSETTLECOMPANY,T1.CANCELLEDPAYMENT,T1.REASONREFRECID,T1.REPORTINGCURRENCYAMOUNT,T1.REPORTINGEXCHADJUSTMENTREALIZED,T1.REPORTINGEXCHADJUSTMENTUNREALIZED,T1.LASTEXCHADJRATEREPORTING,T1.REPORTINGCURRENCYCROSSRATE,T1.EXCHADJUSTMENTREPORTING,T1.SETTLEAMOUNTREPORTING,T1.APPROVER,T1.CONCESSIONCONTRACTID,T1.CONCESSIONSETTLEMENTID,T1.RETAILCUSTTRANS,T1.RETAILSTOREID,T1.RETAILTERMINALID,T1.RETAILTRANSACTIONID,T1.CUSTBILLINGCLASSIFICATION,T1.MCRPAYMORDERID,T1.DIRECTDEBITMANDATE,T1.MODIFIEDDATETIME,T1.DEL_MODIFIEDTIME,T1.MODIFIEDBY,T1.MODIFIEDTRANSACTIONID,T1.CREATEDDATETIME,T1.DEL_CREATEDTIME,T1.CREATEDBY,T1.CREATEDTRANSACTIONID,T1.RECVERSION,T1.PARTITION,T1.RECID,T2.AMOUNTCUR,T2.RECID,T3.PAYMTERMID,T3.RECID FROM CUSTTRANS T1 CROSS JOIN CUSTTRANSOPEN T2 CROSS JOIN CUSTTABLE T3 WHERE ((T1.PARTITION=?) AND (T1.DATAAREAID=?)) AND (((T2.PARTITION=?) AND (T2.DATAAREAID=?)) AND (T1.RECID=T2.REFRECID)) AND (((T3.PARTITION=?) AND (T3.DATAAREAID=?)) AND ((T2.EXCHADJUNREALIZED=T3.ACCOUNTNUM) AND (T1.ACCOUNTNUM=T3.ACCOUNTNUM))) ORDER BY T1.INVOICE,T1.ACCOUNTNUM
Object Server 01:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type nvarchar to
numeric.
SELECT T1.ACCOUNTNUM,T1.TRANSDATE,T1.VOUCHER,T1.INVOICE,T1.TXT,T1.AMOUNTCUR,T1.SETTLEAMOUNTCUR,T1.AMOUNTMST,T1.SETTLEAMOUNTMST,T1.CURRENCYCODE,T1.DUEDATE,T1.LASTSETTLEVOUCHER,T1.LASTSETTLEDATE,T1.LASTEXCHADJVOUCHER,T1.CLOSED,T1.TRANSTYPE,T1.APPROVED,T1.EXCHADJUSTMENT,T1.DOCUMENTNUM,T1.DOCUMENTDATE,T1.LASTEXCHADJRATE,T1.FIXEDEXCHRATE,T1.LASTEXCHADJ,T1.CORRECT,T1.SETTLEMENT,T1.INTEREST,T1.COLLECTIONLETTER,T1.DEFAULTDIMENSION,T1.POSTINGPROFILECLOSE,T1.EXCHRATESECOND,T1.BANKLCEXPORTLINE,T1.ACCOUNTINGEVENT,T1.EXCHRATE,T1.LASTSETTLEACCOUNTNUM,T1.COMPANYBANKACCOUNTID,T1.THIRDPARTYBANKACCOUNTID,T1.PAYMMODE,T1.PAYMREFERENCE,T1.PAYMMETHOD,T1.CASHPAYMENT,T1.CONTROLNUM,T1.DELIVERYMODE,T1.POSTINGPROFILE,T1.OFFSETRECID,T1.EUROTRIANGULATION,T1.ORDERACCOUNT,T1.CASHDISCCODE,T1.PREPAYMENT,T1.PAYMSPEC,T1.CUSTEXCHADJUSTMENTREALIZED,T1.CUSTEXCHADJUSTMENTUNREALIZED,T1.PAYMMANLACKDATE,T1.PAYMMANBATCH,T1.PAYMID,T1.BILLOFEXCHANGEID,T1.BILLOFEXCHANGESTATUS,T1.BILLOFEXCHANGESEQNUM,T1.BANKREMITTANCEFILEID,T1.COLLECTIONLETTERCODE,T1.INVOICEPROJECT,T1.LASTSETTLECOMPANY,T1.CANCELLEDPAYMENT,T1.REASONREFRECID,T1.REPORTINGCURRENCYAMOUNT,T1.REPORTINGEXCHADJUSTMENTREALIZED,T1.REPORTINGEXCHADJUSTMENTUNREALIZED,T1.LASTEXCHADJRATEREPORTING,T1.REPORTINGCURRENCYCROSSRATE,T1.EXCHADJUSTMENTREPORTING,T1.SETTLEAMOUNTREPORTING,T1.APPROVER,T1.CONCESSIONCONTRACTID,T1.CONCESSIONSETTLEMENTID,T1.RETAILCUSTTRANS,T1.RETAILSTOREID,T1.RETAILTERMINALID,T1.RETAILTRANSACTIONID,T1.CUSTBILLINGCLASSIFICATION,T1.MCRPAYMORDERID,T1.DIRECTDEBITMANDATE,T1.MODIFIEDDATETIME,T1.DEL_MODIFIEDTIME,T1.MODIFIEDBY,T1.MODIFIEDTRANSACTIONID,T1.CREATEDDATETIME,T1.DEL_CREATEDTIME,T1.CREATEDBY,T1.CREATEDTRANSACTIONID,T1.RECVERSION,T1.PARTITION,T1.RECID,T2.AMOUNTCUR,T2.RECID,T3.PAYMTERMID,T3.RECID FROM CUSTTRANS T1 CROSS JOIN CUSTTRANSOPEN T2 CROSS JOIN CUSTTABLE T3 WHERE ((T1.PARTITION=?) AND (T1.DATAAREAID=?)) AND (((T2.PARTITION=?) AND (T2.DATAAREAID=?)) AND (T1.RECID=T2.REFRECID)) AND (((T3.PARTITION=?) AND (T3.DATAAREAID=?)) AND ((T2.EXCHADJUNREALIZED=T3.ACCOUNTNUM) AND (T1.ACCOUNTNUM=T3.ACCOUNTNUM))) ORDER BY T1.INVOICE,T1.ACCOUNTNUM
session 15 (Admin)
"
The customer resolved it by himself.
Amith Prasanna,
I fixed this issue the issue was in expression in visual studio fields, i make it correct now its working.
Best Regards,
Shabir Ahmad
Just check your report query it says Data conversion error " Error converting data type nvarchar to
numeric."
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156