Dynamics Community Forum Thread Details

Currently we are trying to role out Advanced Bank reconciliation. And everything is starting to get working except "Settle customer invoices" and "generate customer payment journal" rule. And we can't figure out what we are doing wrong. If we perform these tasks manually frotm the worksheet, then it works perfect.

SELECT T1.ACCOUNTNUM,T1.AMOUNTCUR,T1.AMOUNTMST,T1.BANKDISCNOTICEDEADLINE,T1.BANKLCEXPORTLINE,T1.CASHDISCDATE,T1.CASHDISCOUNTLEDGERDIMENSION,T1.DUEDATE,T1.EXCHADJUNREALIZED,T1.EXCHADJUNREALIZEDREPORTING,T1.FINEAMOUNT_BR,T1.FINEAMOUNTPAYMCUR_BR,T1.FINECODE_BR,T1.INTERESTAMOUNT_BR,T1.INTERESTAMOUNTPAYMCUR_BR,T1.INTERESTCODE_BR,T1.LASTINTERESTDATE,T1.POSSIBLECASHDISC,T1.REFRECID,T1.REPORTINGCURRENCYAMOUNT,T1.SETTLEDLINEPERCENT_IN,T1.SETTLEDTOTALAMOUNT_IN,T1.SETTLEMENTPRIORITYCASHDISCDATE,T1.TAXWITHHOLDAMOUNTORIGIN_IN,T1.TCSAMOUNT_IN,T1.TDSAMOUNT_IN,T1.TRANSDATE,T1.USECASHDISC,T1.COLLECTIONLETTER,T1.COLLECTIONLETTERCODE,T1.COVSTATUS,T1.TAXDISTRIBUTION,T1.RECVERSION,T1.PARTITION,T1.SYSROWVERSION,T1.RECID,T2.SALESID,T2.ACCOUNTNUM,T2.INVOICE,T2.CURRENCYCODE,T2.CUSTTRANSRECID,T2.PAYMID,T2.PAYMREFERENCE,T2.AMOUNTCUR,T2.AMOUNTMST,T2.TXT,T2.TRANSDATE,T2.AMOUNTCREDITDEBITINDICATOR,T2.BALANCECUR,T2.BALANCEMST,T2.CUSTOMERNAME,T2.PACKINGSLIPID,T2.DUEDATE,T2.CASHDISCDATE,T2.PAYMMODE,T2.TRANSTYPE,T2.VOUCHER,T2.CUSTBILLINGSETTLEMENTPRIORITY,T2.CUSTSETTLEMENTTRANSPRIORITY,T2.PARTITION,T2.RECID FROM CUSTTRANSOPEN T1 CROSS JOIN CUSTINVOICEFORBANKRECONCILIATIONVIEW T2 WHERE (((T1.PARTITION=5637144576) AND (T1.DATAAREAID=N'001')) AND NOT ((T2.INVOICE=?))) AND (((((((((((((((((((T2.PARTITION=5637144576) AND (T2.DATAAREAID=N'001')) AND ((T2.PARTITION#2=5637144576) OR (T2.PARTITION#2 IS NULL))) AND ((T2.DATAAREAID#2=N'001') OR (T2.DATAAREAID#2 IS NULL))) AND ((T2.PARTITION#3=5637144576) OR (T2.PARTITION#3 IS NULL))) AND ((T2.DATAAREAID#3=N'001') OR (T2.DATAAREAID#3 IS NULL))) AND (T2.PARTITION#4=5637144576)) AND (T2.DATAAREAID#4=N'001')) AND ((T2.PARTITION#5=5637144576) OR (T2.PARTITION#5 IS NULL))) AND ((T2.PARTITION#6=5637144576) OR (T2.PARTITION#6 IS NULL))) AND ((T2.DATAAREAID#6=N'001') OR (T2.DATAAREAID#6 IS NULL))) AND ((T2.PARTITION#7=5637144576) OR (T2.PARTITION#7 IS NULL))) AND ((T2.DATAAREAID#7=N'001') OR (T2.DATAAREAID#7 IS NULL))) AND ((T2.PARTITION#8=5637144576) OR (T2.PARTITION#8 IS NULL))) AND ((T2.DATAAREAID#8=N'001') OR (T2.DATAAREAID#8 IS NULL))) AND ((T2.PARTITION#9=5637144576) OR (T2.PARTITION#9 IS NULL))) AND ((T2.PARTITION#10=5637144576) OR (T2.PARTITION#10 IS NULL))) AND ((T2.DATAAREAID#10=N'001') OR (T2.DATAAREAID#10 IS NULL))) AND (((T2.AMOUNTCREDITDEBITINDICATOR=?) AND (T1.REFRECID=T2.CUSTTRANSRECID)) AND (T1.ACCOUNTNUM=T2.ACCOUNTNUM))) ORDER BY T2.TRANSDATE

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'DATAAREAID#7'.

What we currently have: