Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Apply entries for all vendors in one go

(1) ShareShare
ReportReport
Posted on by 6
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
  • CU11110703-0 Profile Picture
    CU11110703-0 5 on at
    Apply entries for all vendors in one go
    @KasparsSemjonovs Has the perfect solution for this! Saved me form doing crazy code for this! 
     
    Tried on my end and the system will performe some "FIFO"method on Payments <> Invoices and apply all it can.
    The remaining entries that might still be there either have remaining about or the system couldn't apply anything against it.  Usually not enout payments registred for the open invoices.
  • John35 Profile Picture
    John35 6 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 7,440 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.
     
     
  • Verified answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,973 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans