Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Apply entries for all vendors in one go

Posted on by 4
Hello experts,
 
I have got multiple vendors which I can see in my Vendor Ledger Entries that invoices and payments are posted although never been allocated to each other so they remain Open in the list.
 
I am aware of applying those entries if I go to each vendor and find it myself then apply entries to offset them however that will take me an important length (weeks!).
 
Is there a way to get for example all Vendor Ledger Entries which include both invoices and payments and automatically match all of them in one go through the list?
 
Any help is appreciated!
 
Many thanks,
John
  • John35 Profile Picture
    John35 4 on at
    Apply entries for all vendors in one go
    Would the Suggest vendor payment function be suitable to match the old invoices and payments now?
     
    Or would that be for the future processes?
     
    Just to know if this would mess up the reconcilitation.
     
     
    Thanks.
  • Jun Wang Profile Picture
    Jun Wang 6,881 Super User 2024 Season 2 on at
    Apply entries for all vendors in one go
    the issue is that user hasn't been properly trained on how to apply payments to vendor invoices. if user makes payments to vendor from payment journal without specifying what invoices are paid for via apply entries. This will happen.
     
    The recommended way is to use Suggest vendor payment feature as the suggested lines automatically link payments to the invoices.
     
     
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,660 Super User 2024 Season 2 on at
    Apply entries for all vendors in one go
    The only 'automated' application can be done, if You set Application method in Vendor card from manual to "Apply to Oldest".
    This way one the next transaction for the vendor is posted all of his entries will be re-applied to the oldest document. This is useful, if customer/vendor invoices are paid one after a other, but not really usefull if You have several open orders/contracts, and pay accordingly to specific order or contract.

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