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.
DB synchronization should resolve this issue. Let us know if DB sync doesn't work.
Hi ccobasi,
Do you resolve your issue yet? In Dynamics 365 Finance and Operations > Click on Dynamics 365 Menu on Top > Click On Build Models > Click on Select All Option > Click Build. This will perform a full compilation.
Hi,
Ran a database synchronization and then try.
Thanks,
Girish S.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156