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

september

01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV

october

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

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