Open Vendor Ledger entries

MaW · 2018-02-08

Hi,
We have a customer running NAV 2017 with Continia Payment Management. They have a lot of open vendor entries, where the balance on vendor is 0. That mess things up when user wants to use PM. Is there any way to automatically close all entries without needing to manually match payments and invoices?

On customers they have same trouble, and would like to close entries without needing to manually match payments and invoices?

Thanks

eYe · 2018-02-09

Unfortunately, you'll have to add customization.
It is not something that the system can intuitively guess in order to match payments.
Usually it is a single payment for multiple invoices or vice versa.
Hopefully external Document Nos. for payments match so your code to do application can match it that way. If doc nos. and amounts match, easy enough.
When done with those, apply payments on a FIFO basis.
(Or just do the latter if it doesn't matter which payment applies to which invoice)

For future payments made, I would use Event Subscription to determine when the journal is posted and try to automatically apply to invoices.

eYe · 2018-02-09

Unfortunately, you'll have to add customization.
It is not something that the system can intuitively guess in order to match payments.
Usually it is a single payment for multiple invoices or vice versa.
Hopefully external Document Nos. for payments match so your code to do application can match it that way. If doc nos. and amounts match, easy enough.
When done with those, apply payments on a FIFO basis.
(Or just do the latter if it doesn't matter which payment applies to which invoice)

For future payments made, I would use Event Subscription to determine when the journal is posted and try to automatically apply to invoices.

MaW · 2018-02-09

Thanks for your input, we'll take a look at doing customization. If any one have a solution to build on, please do not hesitate to write to me.

eYe · 2018-02-09

MaW wrote: »

Thanks for your input, we'll take a look at doing customization. If any one have a solution to build on, please do not hesitate to write to me.

I have written similar functionality for sales

Open Vendor Ledger entries

Best Answer

Answers

Categories