Apply entries for all vendors in one go

(1) Share

Report

Posted on by John35

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

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

CU11110703-0 5 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
John35 6 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Jun Wang 8,152 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

KasparsSemjonovs 4,511 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No