Configuring Microsoft Dynamics 365 Business Central: Electronic Payments (blog series)

-

One of the most desirable features of Microsoft Dynamics 365 Business Central is the ability to pay vendors via electronic payments. I've decided to make a blog series on configuration and processing electronic payments. Links will be updated below as the series gets posted online.

Blog Series Links

#1 - Configuring Microsoft Dynamics 365 Business Central: Electronic Payments

#2 - Microsoft Dynamics 365 Business Central: Processing Electronic Payments

#3 - Microsoft Dynamics 365 Business Central: Electronic Payment Issues I've Encountered

Configuring Dynamics 365 Business Central: Electronic Payments

Bank Account

Within the bank account card a few things need to be setup in order for the system to allow you to process electronic payments.
  1. Populate the following fields:
    1. General > Bank Account No.
    2. Posting > Last Remittance Advice No. - I like to use the format R000001 (R for remittance in this case.
    3. Transfer > Country Export Format
    4. Transfer > E-Pay Export File Name - I like to use the format C:\0000001.txt 
    5. Last E-Pay File Creation No. - 1
    6. Transit No.
    7. Payment Export Format - US EFT DEFAULT                                                                                      

Vendor Card

In order to pay a vendor electronically a few things need to happen within the vendor card. 
  1. Add the vendors bank account information within the Vendor Bank Account List. Open vendor card then navigate to Navigate > Bank Accounts. Select New and enter the vendors banking information into the Vendor Bank Account Card. Required fields:
      • General > Code
      • General > Bank Account No.
      • General > Transit No.
      • Transfer > Use for Electronic Pay                                                                                            


  2. Within the vendor card keep in mind that the address and email fields will be used by default. The email field on the vendor card only allows for one email address, if you need to send the payment remittance via email to more than just one email then look into using Document Layouts.
  3. The last setup piece with the vendor is to populate the Payments > Preferred Bank Account Code field. If the vendor only has one bank account setup then this is a good idea to populate this field so it doesn't slow you down when processing vendor payments.                                                           

You've now completed the configuration within Dynamics 365 Business Central for paying vendors electronically. Look for the second blog in this series to be posted soon. Subscribe to the blog to receive an email once posted.

Written by: Kristen Hosman, Microsoft MVP








Comments

Post a Comment

Popular posts from this blog

Applying posted credit memos to posted invoices in Microsoft Dynamics 365 Business Central

-
Image
Applying posted credit memos to posted invoices isn't a hard task to complete in Microsoft Dynamics 365 Business Central. The example I use below is for a vendor credit, but the same process applies to customers.  Version: US Business Central 20.0 Open up the vendors list. Search for vendor that you'd like to apply the credit memo to an invoice for.  Click on Balance field to open up Vendor Ledger Entries window. This will show all the 'open' documents on the vendor ledger. Select the line for the Credit Memo that you want to apply to a posted invoice. Click Process > Apply Entries Within the Edit - Apply Vendor Entries window select the line(s) that you'd like the credit memo applied to.  Click Process > Set Applies-to ID This will put the users name into the Applies-to ID field on the line selected. To post the application select Process > Post Application. Written by: Kristen Hosman, Microsoft MVP
Read more

Dimension Corrections in Microsoft Dynamics 365 Business Central

-
Image
If you've ever coded something to the wrong dimension and noticed after posting don't just assume a journal entry is the only way to fix it. Microsoft has included a Dimension Corrections tool within Business Central and it's pretty easy to use. Let's walk through the process of updating a posted entries dimension where the user forgot to add the dimensions in this case. Same process would apply if you needed to change a posted dimension as well. Within the General Ledger Entries page, select the line for the entry that needs to be corrected, then click on Entry > Correct Dimensions.  Within the Draft Dimension Correction window go ahead and update the description if needed and mark Update Analyses Views if you're using those.  Next section Dimension Correction Changes go ahead and add the updates. In my case my entry is missing two dimensions so I'm going to add each of those in there. Since my dimensions were missing the Dimension Value Code field is blank,...
Read more

Add field to page: all fields (Preview) Dynamics 365 Business Central v23

-
Image
Add field to page Have you ever needed to add a field to a page, and you couldn't without a developer? There was once a time where not all fields in the table were available to be placed on a page without a developer or using the Design tool.  Microsoft has fixed this inconvenience and in version 23 the feature "add existing table fields to optimize your pages" will be in preview. Learn more about this addition to Business Central here:  Add existing table fields to optimize your pages | Microsoft Learn Prior to this feature this is what the system displayed. Version 23 showing the new feature. What does this mean? You can now, without a developer add a field within a table to the page.  How does it work? It's really simple actually.  Navigate to the Profiles (Roles) list and choose Customize Pages from the Action Bar.  When the new browser tab loads, navigate to the page within Business Central that you'd like to add a field to. Expand the customization banne...
Read more