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

Applying Vendor Payments to multiple Invoices through Vendor Ledger Entries configuration package

(0) Share

Report

Posted on by trademann

Our client receives an export file from their outside payables servicer and they upload a configuration package with all of the payment journal lines, however they can only apply one invoice to a payment when doing so. Is anyone aware of how this can be handled in BC? Is there another table that can be used? My other thought was using the vendor ledger entry configuration package, exporting, and adding the applies to doc type and no, as well as applies to ID and Amount to apply, however I have no success with this approach. Any guidance is greatly appreciated.

All responses (4)

Answers (0)

Suggested answer

Amit Baru 3,027 on at

Like (0)

Report

RE: Applying Vendor Payments to multiple Invoices through Vendor Ledger Entries configuration package

Hi,

Pls do manually one by one. Data is temporary fill while open the Applies Entry Page. As per my knowledge Configuration Package is not suitable option.

Can do customization for applying bulk entries in one go.

Regards

Amit Sharma

www.erpconsultors.com

Press Yes if info is suitable.
Suggested answer

Inge M. Bruvik 993 Super User 2024 Season 1 on at

Like (0)

Report

RE: Applying Vendor Payments to multiple Invoices through Vendor Ledger Entries configuration package

If the file your receive contains all the payment references involved in a payment. You could develop a specific import job for it instead of using the configuration packages. But it depends on how your data is formatted and what information you receive.

If you receive information both on the total amount paid to each vendor and the amount for each specific payment reference (invoice) you receive then you basically have all the information you need to build an import job that can do this automatically. But the config. packages may not be the best approach.
Suggested answer

YUN ZHU 75,848 Super User 2024 Season 2 on at

Like (0)

Report

RE: Applying Vendor Payments to multiple Invoices through Vendor Ledger Entries configuration package

Hi, Yes, only one-to-one if importing from Payment journal.

If you want one-to-many, you need to choose Apply Entries... on the page.

As far as I know, this is calculated when the page is opened and cannot be imported from the Configuration Package.

So I personally recommend that it is better to do it manually, otherwise it will require a lot of customization.

And maybe the link below can give you some hints.

Hope this helps as well.
Thanks.

ZHU
Nitin Verma 21,081 Super User 2024 Season 1 on at

Like (0)

Report

RE: Applying Vendor Payments to multiple Invoices through Vendor Ledger Entries configuration package

Hi trademann ,

I am not sure if you can achieve Payment application with invoice by using of Config. Package, If you want to do the automate this process, please ask your developer to do a customization for you to achieve this after you import all the payment journal lines and configure the automate process afterwards.

Thanks.