Open Vendor Ledger entries

MaW

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

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

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

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

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