Payment Reconciliation Journal

(2) Share

Report

Posted on by MH-06060002-0

Hello all,

We would like to use payment reconciliation journal, however we are coming up with a limitation that i was hoping someone has a solution to.

It seems that you can only post the journal if ALL the transactions in the entire journal have been MATCHED / ACCEPTED.

Is there a way to only post only the matching ones, and leave the remainder in the journal? I tried filtering for only the accepted ones and posting but i get the same error.

Thanks

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (1)

Suggested answer

Khushbu Rajvi. Super User 2025 Season 1 on at

Like (1)

Report

Payment Reconciliation Journal

Hope this helps as well: https://learn.microsoft.com/en-us/training/modules/use-journals-dynamics-365-business-central/
Suggested answer

YUN ZHU 83,822 Super User 2025 Season 1 on at

Like (0)

Report

Payment Reconciliation Journal

Hi, You can delete unmatched lines, or match them first, post them, and reverse them if there are any problems.

More details:

Reverse payment reconciliation journal entries

https://learn.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/reverse-payment-reconciliation-journal-entries?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU
Suggested answer

Kntx 11 on at

Like (0)

Report

Payment Reconciliation Journal

Hello,

it is not possible without developing a customization, this is actually one of the requests that we also often receive from our customers.

I would suggest to vote the following idea about this topic to increase the chances that it is picked up by Microsoft:

https://experience.dynamics.com/ideas/idea/?ideaid=868cdafc-348f-ec11-b820-0003ff45e08b

We also have this feature in our app BankLink that you can find on AppSource:

https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.mementosrls1588695843705%7CAID.banklink%7CPAPPID.f0da59ce-30db-42fb-9540-232efd6a52b2?tab=Overview

The app provides provides functionality to connect to banking institutions and download bank transactions directly into Business Central, without the need to manually download files or login to bank portals every day. If you don't need the import functionalities of the app, of course it would not make sense to purchase it just for this feature.

Best.
Verified answer

Valentin Castravet 28,272 Super User 2025 Season 1 on at

Like (0)

Report

Payment Reconciliation Journal

As far as I know, it's not possible. The reason being that in the journal, you either match the lines from your bank with existing transactions in the system, or, if no corresponding transaction exists, you create and post them.

You can delete the unmatched lines and post only the matched ones, but I'm not sure if this is a viable solution, as the next time you import, you'll need to import the same lines again which will be a mix of matched and unmatched entries.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/