Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Vendor Ledger Entries for One Payment of multiple invoices

Posted on by

When paying multiple invoices with one check, there is a payment line for every invoice applied to said payment?

 

Payment process: Payment Journal- Suggest Vendor Payment- Summarized by Vendor (ON)- Print Checks- Post Batch OR Payment Journal- Payment Journal- Suggest Vendor Payment (OFF)- Summarized by Vendor- Print Checks- One Check per Document Number (ON)- Post Batch

Expectation: One Ledger entry per check number. Select applied entries to see all invoices applied to the one payment

Currently: There is a payment ledger entry for every invoice and to see the invoice for which it is applied, we have to select applied entries on every single payment line. HOWEVER, if I do not apply payment to an invoice in the payment journal, but apply the payment on the ledger entries screen for each vendor, it performs as expected.

 

How can I get the payment journal to apply all the invoices to a payment and create one payment line per check in the vendor ledger entries?

Categories:
  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,476 Super User 2024 Season 2 on at
    Vendor Ledger Entries for One Payment of multiple invoices
    When running the "Suggest Vendor Payments" process, you can choose to "Summarize per Vendor" or not.  The summary view will be similar to how the Check Ledger will look.  The non-summary view should still apply the same Document No to each Vendor.
     
    Example of a non-summary view, notice the same Document No. for each Vendor:
     
    Since the above process creates the lines with the same Document No. for each Vendor, when using the "Print Checks" process you need to select "One Check per Vendor per Document No."
     
    This ensures you are printing a single Check (check ledger) per Vendor, and would use Applied Entries to see the list of Invoices paid.
     
    If you are getting a different result, I would suggest you raise the issue to your partner so they can help you troubleshoot with your data.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans