When comparing the information which is used by our customer in an older AX version to the D365 advanced reconciliation ER configuration, I found that some fields are not transferred from the camt.053 files into the bank statement line, but are used by the customer to identify the correct customer or the correct vendor:

a) Identification of business partners in direct debit transactions by using the mandate ID and the creditor ID:

• Document\ BkToCstmrStmt\ Stmt\ Ntry\ NtryDtls\ TxDtls\ Refs\ MndtId
• Document\ BkToCstmrStmt\ Stmt\ Ntry\ NtryDtls\ TxDtls\ RltdPties\ Cdtr\ Id\ PrvtId\ Othr\ Id

b) Invoice numbers given in the end-to-end ID

• Document\ BkToCstmrStmt\ Stmt\ Ntry\ NtryDtls\ TxDtls\ Refs\ EndToEndId

c) Fees specified in the bank transaction details

• Document\ BkToCstmrStmt\ Stmt\ Ntry\ NtryDtls\ TxDtls\ Chrgs\ Rcrd (!!!)\ Tp\ Cd 

Fees in camt.053.001.08 have received a new structure, so that they are not transferred any more into the Advanced bank statement model. Additionally, from the Advanced bank statement model there is no link to the bank statement line table nor to the Advanced bank reconciliation rules.

The bank transaction code, which is saved in the field Proprietary Bank transaction code is not filled with the desirable value:

The banks always give the ISO fields Domn, Fmly and SubFmlyCd, but the proprietary codes of the banks are more granular than the ISO codes. In some cases different proprietary codes are given to the same entries in Domn, Fmly and SubFmlyCd depending on the CreditDebit indicator. The formula in the configuration first looks for the ISO codes and then for the proprietary codes. If the order were changed, so that the proprietary codes were favored over the ISO codes, then the rules would be much more useful for the users.

Example 1: Domn PMNT, Fmly RRCT SubFmlyCd ESCT may have the proprietary codes 161, 162, 163, 164, 165 and 168

Example 2: Domn PMET, Fmly SPOT SubFmlyCd OTHR has the proprietary code 423 for credit transactions and 424 for debit transactions

So the recognition rate could already be improved by specifying the proprietary bank transaction code instead of the ISO combination.