Finance | Project Operations, Human Resources, ...

Duplicity bank reconciliation when creating a supplier payment journal with a check payment method

(1) Share

Report

Posted on by fpinate

Hello everyone,
I'm currently experiencing an issue when creating a supplier payment journal using a check payment method.

The issue is that when the check is generated, a record is created in the bank reconciliation table, and when the supplier payment journal is recorded, another record is created in the bank reconciliation table, duplicating the check information.

This duplication only occurs in that table, as the accounting and accounts payable information is recorded correctly.

What could be duplicating the bank reconciliation information in the supplier payment journal using a check? I appreciate the community's help in identifying the cause of this duplication.

I've attached an image of the issue so you can get a graphical idea of the problem.

Categories:

Dynamics 365 Finance

EjemplodeChequeDu...

All responses (3)

Answers (0)

Frank Hamelly | MVP... 46,485 Super User 2025 Season 1 on at

Like (0)

Report

Duplicity bank reconciliation when creating a supplier payment journal with a check payment method

Could there be a customization involved that's causing the duplication? The document type of 'Other' doesn't make sense.
Jonas "Jones" Melgaard 3,435 Super User 2025 Season 1 on at

Like (0)

Report

Duplicity bank reconciliation when creating a supplier payment journal with a check payment method

Hi @PP-03122105-0,

Are you able to provide the screen shots in English? I don't immediately recognize the texts in the forms.
Suggested answer

Holly Huffman 5,510 on at

Like (1)

Report
Duplicity bank reconciliation when creating a supplier payment journal with a check payment method

Good morning, afternoon, or evening depending on your location!

Based on your description and the attached image, the duplication in the bank reconciliation table when using a check payment method could be caused by the following factors:

Duplicate Posting Logic:

The system might be configured to create a bank reconciliation record both when the check is generated and when the payment journal is posted. This could be due to overlapping triggers in the payment method setup or reconciliation process.

Payment Method Configuration:

Check the configuration of the check payment method in the Cash and Bank Management module. Ensure that the payment method isn’t set to generate reconciliation records twice.

Bank Reconciliation Setup:

Review the bank reconciliation setup to ensure that the reconciliation process isn’t duplicating records for checks. Look for any customizations or rules that might be causing this behavior.

Advanced Bank Reconciliation Feature:

If you’re using the Advanced Bank Reconciliation feature, verify that the matching rules and reconciliation settings are correctly configured. Misaligned rules can sometimes lead to duplicate entries.

Customizations or Extensions:

If your system has customizations or extensions related to payment journals or bank reconciliation, these might be introducing the duplication. Review any recent changes or updates to these areas.

To resolve the issue:

Start by reviewing the payment method and bank reconciliation setup.

Test the process with a different payment method to see if the duplication persists.

If the issue is specific to the check payment method, consider adjusting its configuration or consulting with your technical team to identify any custom logic causing the duplication.

Hope this is helpful :)

Community site session details

Duplicity bank reconciliation when creating a supplier payment journal with a check payment method

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Duplicity bank reconciliation when creating a supplier payment journal with a check payment method

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Jonas ”Jones” Melgaard – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates