Finance | Project Operations, Human Resources, ...

Modern Bank Reconciliation

(4) Share

Report

Posted on by Dixita

296

Hello,

I am trying to post customer payment journal through IBAN, I have setup as below,

1. I have mapped IBAN and bank account number on customer master

2. Getting the IBAN in payment reference field of bank statement lines

3. Enabled 'Automatic customer account matching' toggle on Generate customer payment matching rule

But while running the matching rule, it's posting the customer payment journal for different customer. Have anybody tried this feature yet?

Thanks

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Sort by

André Arnaud de Cal... 305,424 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Dixita,

Can you share some screenshots of the current behavior? Have you checked if the same IBAN is linked to another bank account from the other customer?

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi Dixita,

Thanks for sharing your setup. It looks like you're using Modern Bank Reconciliation in Dynamics 365 Finance and encountering issues with customer payment journal posting to the wrong customer despite having IBAN mapping and automatic matching enabled.

Here are a few things to check:

IBAN Uniqueness:

Ensure that the IBAN is unique across all customer records. If multiple customers share the same IBAN or if there are formatting inconsistencies, the matching rule may select the wrong customer.

Matching Rule Configuration:

Review the Generate Customer Payment Matching Rule setup. Confirm that the rule prioritizes IBAN over other fields like name or reference.

You may need to adjust the matching priority or add conditions to narrow down the match.

Bank Statement Format:

Check if the IBAN format in the bank statement exactly matches the format stored in the customer master (e.g., spacing, country code, etc.).

Test with a Sample Statement:

Try running the matching rule with a simplified bank statement containing only one known IBAN to verify if the rule behaves correctly.

Custom Matching Logic:

If the built-in rule doesn’t meet your needs, consider creating a custom matching rule using X++ or Power Automate to enforce stricter logic.

Let me know if you'd like help reviewing your rule setup or designing a custom match!

Best regards,
Daniele

Was this reply helpful? Yes No