Vendor Electronic Payments in Dynamics 365 Business Central

by | Updated April 24, 2020 | Dynamics 365 Business Central

Dynamics 365 Business Central provides the tools for processing payables electronically. When you want to make payments to your vendors instead of handling manual or computer-generated checks, you can export a file to your bank to process the related money transfers which will eliminate the paper handling. This article will take you through the setup needed and how to process your payments.

Setup for Vendor Electronic Payments in Dynamics 365 Business Central

There are several one-time setups that need to be performed before being able to process electronic payments.

Payment Methods Go to Financial Management/Payables/Setup and create a code to assign to vendors for identifying those who will be paid by a Bank Transfer or Electronic Funds Transfer (EFT).

Payment Method

Company Information The Federal ID No. must be populated so the file has the proper ID for the bank to process the payments.

Company Information

Vendor Go to the Vendor card and Navigate to the Vendors’ Bank Account Card. Complete the information with Bank Account No., Transit No. and check the Use for Electronic Payment as shown below.

Vendor

On the Payments tab of the Vendor Card, select the Payment Method Code you want to assign to those vendors you want to pay by Bank Transfer. This will give you the ability to select only those vendors that are setup with electronic payments to be selected when suggesting Vendor Payments. In the Preferred Bank Account Code field, select the Vendors’ Bank Account setup with the Use for Electronic Payments. This will populate the value in the Payment Journal.

Payments

Bank Account On the General tab, make sure to complete the Bank Account No. On the Posting tab, enter the Last Remittance Advice No. (Example, EFT001 or EPMT001). On the Transfer tab, enter the Country Export Format, E-Pay Export File Name, Transit No., Payment Export Format.

Bank Account

General Journal Batch Go to Payment Journals and select the Batch Name you will be using to pay the vendors. Do a lookup in the Batch Name field and make sure the field Allow Payment Export is checked as shown below in the screenshot.

Payment Journals

Journal Batches

You are now ready to process your accounts payable electronically for those selected vendors.

Payables Check Processing In the Payment Journal, click Prepare/Suggest Vendor Payments in the ribbon.

On the Options tab, ensure the Bank Payment Type is set to Electronic Payment. You may need to select Show more fields in this section to display the information shown below.

Payables Check Processing

On the Vendor tab of this request form, filter on the Payment Method Code field for the code you assigned to the selected vendors.

Click OK.

Once the payment journal has been populated and you are satisfied with the invoices for payment, click Export in the ribbon.

Export

The Export Electronic Payment request page will appear:

Export Electronic Payment

Bank Account No.: Click the Assist Button to select the bank account from the Bank Account List from which these payments will be taken. This will be the same Bank Account that was used in the Suggest Vendor Payments.

Number of Copies: Enter the number of additional copies of the remittance advice which will be printed by this process. One document is always processed to provide it to the payee, but additional copies can be printed if you need to file one or for any other reason.

Print Company Address: Check this box if you want the company address printed on the remittance advice. Remove any check mark from this box if the remittance advice already has the company address pre-printed on it.

Output Method: Click the Assist Button to select how you want to generate the remittance advices.

Click OK.

Errors will be shown in the Payment File Errors FactBox. You can choose an error message to see the detail. The errors must be resolved before the payment file can be exported.

If you have no errors; the Browse for Folder window will appear. Choose a folder to put the remittance advices for the Vendor and generated file for the Bank and click Save.

Remittance Advice

You can now upload the file to your electronic bank account and make the actual payment.

Post the payment journal.

Related Posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

february

03feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 2 – Platform

10feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 3 – Implementation Partner

11feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Live Agents, Power Virtual Agents, Omnichannel – Oh My!

16feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 4 – Cost

24feb10:00 am11:00 am5 Campaigns Manufacturing Marketers Don’t Want to Miss

25feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Surfing Through the Dynamics 365 Wave 1 2021 Release

march

03mar10:00 am10:30 amThe Modern Manufacturer - MRP vs. MPS – What, When and How

03mar2:00 pm2:30 pmLot Management Best Practices for Batch Manufacturers

10mar10:00 am10:30 amEnhancing the Customer Experience and Driving More Business with Dynamics 365 Customer Service

10mar2:00 pm2:30 pmThe Five Steps to Managing Sales Tax for Manufacturers

11mar11:00 am12:00 pmConfab with Stoneridge - Livestream - Power Apps Component Framework Power Hour

17mar10:00 am10:30 amThe Modern Manufacturer: Pro Tips for your Finance Team

24mar10:00 am10:30 amUnlock the Potential of Digital Marketing with Dynamics 365 Marketing

25mar11:00 am12:00 pmConfab with Stoneridge - Livestream - The Four Keys to Choosing the Best ERP or CRM Solution

31mar10:00 am10:30 amThe Modern Manufacturer: Keys to Reporting Success

31mar01aprFinancial Reporting w/ Account Schedules for Dynamics 365 Business Central

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X