D365 Vendor Payment Journal not consolidating invoices into one payment

(0) Share

Report

Posted on by Tracy Dobbs

I have an issue that started recently with vendor payment journals. Sometime the system does not consolidate the invoices for the same vendor into one line/payment. We have payment journals that have multiple entry lines for one vendor with multiple invoices. On that same journal for other vendors it has one entry line for multiple invoices. It does not happen all the time or even to the same vendor. It will work correctly for the vendor on one payment journal and not on another. The Method of payment is the same for all payment journals and invoices and has not been modified recently. Method of payment is set for Period = Total.

Any ideas?

Thanks,

Tracy

I have the same question (0)

All responses (6)

Answers (1)

Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

There have been similar discussions on the forums about similar issues before, you can refer to this old thread and check the settings according to the prompts: AP Payment Proposal not consolidating Prepay Invoices with other Invoices into a single payment - creates 2 payments (dynamics.com).

Best regards,

Kevin

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

There are other factors like currency differences can make the payment line separated.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,636 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

There are various fields to be controoled during merging. Like bank account, currency, vendor bank acconunt, payment method etc.

Please check if those have all the same information.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Tracy,
In addition to Billur's feedback, please check if vendor transaction have the same (Method of payment, Payment specification, Bank account, Currency)

Was this reply helpful? Yes No
Tracy Dobbs 56 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the feedback. Method of payment, Payment specification, Bank account, Currency are the same (no changes) for these transactions and vendor records. I also checked a couple of older threads but they recommended the same things.

Any other thoughts?

Tracy

Was this reply helpful? Yes No
Verified answer

Tracy Dobbs 56 on at

Like (0)

Report
Copy link

Link copied!

I found the answer to this problem. The Vendor payment journal is creating two payments lines for the same supplier because the Vendor bank record field (third-party bank field on invoice journal line) is populated on some of their invoices and not on others. We have added the field Vendor bank record to the Payment Proposal screen where you select invoices to be paid and made sure the field is populated. This solved the problem.

Was this reply helpful? Yes No