News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Automate submitting ba...

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

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

All responses Img

All responses (2)

Answers Img

Answers (0)

gdrenteria 12,183 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 24,824 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... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans