22 May’17

Dynamics NAVAutomated Clearing House (ACH) payments to Vendor Bank Accounts in Microsoft Dynamics NAV


In my previous blog, I had mentioned the steps required to setup ACH payments to vendors in NAV.

For more details of my previous blog, click here.

After all the setups are done, the next step will be to Export and Transmit the ACH payment file. In this blog, I will be giving the procedure for the same.


Microsoft Dynamics NAV 2017 (North America NA version).


Step 1: Navigate to Payment Journal.

I have created a new payment general journal batch named ‘ACH’.

Step 2: Select ‘Suggest Vendor Payments’ which processes open vendor ledger entries and creates a payment suggestion as lines in the Payment Journal window.

Enter the Last Payment Date and the Posting Date.

Enable Find Payment Discounts, Summarize per Vendor to create one line per vendor for each currency in which the vendor has ledger entries.

Select the Bal. Account Type as ‘Bank Account’ and select the bank from which ACH payment has to be made in Bal. Account No. Select the Bank payment type as ‘Electronic Payment’.

Select a filter as payment method code is ‘ACH’ so that open vendor ledger entries with vendor payment method code as ACH are displayed.

Step 3: Export payments on journal lines to a file prior to transmitting the file to the bank. Select the ‘Export’ action.

Output method is basically for the Remittance advice. Select the output method to save it.

Step 4: The export file will be created automatically and saved in the Export folder.

Now logon to the bank, upload the file and once verification is given from the bank that everything is perfect then it can be transmitted.

Step 5: To transmit the payment, click on transmit.

After transmitting the payment, NAV will remove the notepad file from export folder and transfer it in the transmit folder.

Step 6: Last step is to post the payment.

Note: To edit the format of the export file as per the bank requirement, you need to edit format of the Codeunit 10090 – Export Payments (ACH).

Using the above procedure, it is possible to do ACH payments to vendors in Microsoft Dynamics NAV.


Written by

Team Member


Leave a Reply

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

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Managing mailbox through Email Archiving

    20 March’ 2018

    Introduction: Email can fill your Outlook Inbox quickly – new messages, replies, and forwards. Before you know it, yo...

    Read more
  • Workaround to Report.SAVEASPDF in NAV 2018

    20 March’ 2018

    Objective: In NAV 2017 Emailing the PDF by running the report using Report.SAVEASPDF is now not allowed in NAV 2018. Th...

    Read more
  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more