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

All responses (6)

Answers (1)

Verified answer

Tracy Dobbs 56 on at

Like (0)

Report

D365 Vendor Payment Journal not consolidating invoices into one payment

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.
Tracy Dobbs 56 on at

Like (0)

Report

D365 Vendor Payment Journal not consolidating invoices into one payment

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
Suggested answer

Alireza Eshaghzadeh 13,062 Super User 2024 Season 2 on at

Like (0)

Report

D365 Vendor Payment Journal not consolidating invoices into one payment

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

BillurSamdancioglu 15,811 Most Valuable Professional on at

Like (1)

Report

D365 Vendor Payment Journal not consolidating invoices into one payment

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.
Suggested answer

Ramit Paul 22,293 Most Valuable Professional on at

Like (0)

Report

D365 Vendor Payment Journal not consolidating invoices into one payment

There are other factors like currency differences can make the payment line separated.
Kevin Xia Microsoft Employee on at

Like (0)

Report

D365 Vendor Payment Journal not consolidating invoices into one payment

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

D365 Vendor Payment Journal not consolidating invoices into one payment

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Meet the Top 10 leaders for December!

Get Started Blogging in the Community

Leaderboard

Featured topics

Product updates

D365 Vendor Payment Journal not consolidating invoices into one payment

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Meet the Top 10 leaders for December!

Get Started Blogging in the Community

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates