News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Automate submitting ba...

Business Central forum

Suggested answer

Automate submitting batch payments in "Payment Journals"

(1) Share

Report

Report

Posted on by Community member

2

Hello,

Every week in Payment Journals we Ener the Vendor No. and then all the corresponding External Document No. 's that are due to create a batch payment for that Vendor. Process: (Enter Vendor Number -> /Process/ -> /Apply Entries/ -> /Set applies-to ID/ for every invoice due -> then repeat with the next vendor) I want to know if it is possible to automate this process with Powerautomate, and if so what are some of the necessary actions to do so. As of right now we export the invoices that are due into an excel sheet and manually input each ACH Batch and then MCHK

Categories:

Integration to Power BI, Power Apps, Power Automate and Dataverse

Financial Management

All responses Img

All responses (2)

Answers Img

Answers (0)

gdrenteria 8,762 Most Valuable Professional on at

Like (0)

Report

Automate submitting batch payments in "Payment Journals"

Hi

Maybe this can help you, and give you some hints

Rules for Automatic Application of Payments - Business Central | Microsoft Learn

Best regards

Gerardo
Suggested answer

Valentin Castravet 21,730 Super User 2024 Season 2 on at

Like (0)

Report

Automate submitting batch payments in "Payment Journals"

Have you looked at the Suggest Vendor Payments functionality in the Payment Journal? It does what you're trying to achieve with Power Automate, albeit in a much simpler way and the functionality is already there.

Suggest Vendor Payments - Business Central | Microsoft Learn

Valentin Castravet

Zander ERP Services

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2

Martin Dráb 228,137 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans