I added field 'CWTransId' to BankStmtISOReportEntry table, while trying to import Bank statement from Excel document. When I select Bank statement from Cash and Bank Management I got this error "session 5123 (Admin)"
SELECT T1.ACCOUNTSERVICERREFERENCE,
T1.ADDITIONALENTRYINFORMATION,
T1.AMOUNT,
T1.AMOUNTCREDITDEBITINDICATOR,
T1.BANKDOCUMENTNUMBER,
T1.BANKSTATEMENTCOUNTERCURRENCY,
T1.BANKSTATEMENTCOUNTERCURRENCYAMOUNT,
T1.BANKSTATEMENTCOUNTEREXCHANGERATE,
T1.BANKSTATEMENTLINESTATUS,
T1.BANKSTMTISOACCOUNTSTATEMENT,
T1.BOOKINGDATETIME,
T1.BOOKINGDATETIMETZID,
T1.CHARGERATE,
T1.ENTRYREFERENCE,
T1.INTERESTRATE,
T1.ISNEWBANKDOCUMENT,
T1.PARENTBANKSTMTISOREPORTENTRY,
T1.PROPRIETARYBANKTRANSACTIONCODE,
T1.RECONCILED,
T1.REFERENCENUMBER,
T1.RELATEDBANKACCOUNT,
T1.RELATEDBANKNAME,
T1.REVERSALINDICATOR,
T1.SOURCEDOCUMENTLINE,
T1.TAXAMOUNT,
T1.TAXID,
T1.TAXRATE,
T1.TRADINGPARTY,
T1.BANKSTATEMENTINSTRUCTEDCURRENCY,
T1.BANKSTATEMENTINSTRUCTEDCURRENCYAMT,
T1.BANKSTATEMENTINSTRUCTEDEXCHANGERATE,
T1.CREDITORREFERENCEINFORMATION,
T1.CWTRANSID,
T1.CWTRANSACTIONDETAILS,
T1.DATAAREAID,
T1.RECVERSION,
T1.PARTITION,
T1.RECID FROM BANKSTMTISOREPORTENTRY T1 WHERE ((PARTITION=5637144576) AND (SOURCEDOCUMENTLINE=?))
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'CWTRANSID'.
Object Server Azure:
Cannot select a record in Bank statement report entry (BankStmtISOReportEntry). Reference: 0. The SQL database has issued an error.
