Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Martin and Associates

Setting up EFT for Payables Management in Dynamics GP 2013 and Later – Part 3

Setting up EFT for Payables Management in Dynamics GP 2013 and Later – Part 3

This is Part 3 of 3 for Setting up Electronic Funds Transfer (EFT) for Accounts Payable/Payables Management in Dynamics GP 2013 and Later. Part 1 covers EFT Set up. Part 2 covers Word Template Remittance.

 

Processing an AP EFT Check Run

Purchasing Page | Transactions | Select Checks

An AP EFT check run starts just like a usual check run, except the batch is marked as EFT instead of Check.  I usually start from Select Checks and add the batch on the fly.

 

Once the batch is made, run through the check selection process as usual.  You will only be able to select vendors that have been setup for EFT; otherwise you will receive an error message when selecting vendors.

If you are building a batch using the selection criteria on the Select Checks window, I like to setup the EFT-enabled vendors with something in the Payment Priority field.  That is available on the Vendor Card | Options button.  I usually use a value like “EFT” in the Payment Priority field.

 

Once the checks are selected, you come to the Print Payables Checks window.  This looks like normal, except the Check Number is perhaps different (based on the settings specified earlier), and the Sort Checks By and Check Format fields are greyed out.  The Separate Remittance checkbox should be selected.

 

Once you hit the Process button the “print” the checks, the Process Remittance window will open.  Use this window to print the remittances, or email them, or both.

 

Clicking Process will Print and/or Email the remittances.  If the vendor has not been setup with email processing, the remittance will be printed.  Otherwise the remittance will be emailed to the vendor.

Sample Email:

Success!  Your vendors will be so happy!

FYI – this process works great for processing employee reimbursements as well.

Next on the Process Remittance window, select Post and then Process.  This will post the checks in GP.

One final step (in GP) – generating the ACH file.

Purchasing Page | Transactions | Generate EFT File

 

Select the batch just completed, and hit the Generate EFT File button.  This will create a date and time-stamped file in the location specified earlier.  Browse to this location in Windows Explorer to view the file.

Lastly upload this file to your bank using their website.

All setup!  You are now an AP EFT expert!

 

For basic set up, please review part 1.

For word template remittance, please review part 2.

 

 

 

Other Blog Posts

BI Event of the Season: BI360 Focus 2015

Time seems to fly by faster and faster.  We’re already halfway through 2015, and even though Microsoft Convergence, Intacct and Acumatica conferences and summits were just a bit ago, they seem

Streamline Your Entire Warehouse With Accuracy & Efficiency

Optimizing warehouse management processes to keep track of materials distribution and labor is no easy feat. Provide your salespeople accurate inventory information to improve customer service and increase productivity by

Sage 100 2022.0 is Released!

Sage 100 2022.0 was released on Monday, April 18. 2022. Highlights of the new version: Sage Production Management will continue to evolve as Sage makes product improvements. Future enhancements to

Data Warehouses for Non-Profits using Intacct

The business world of today is all about data – for all types of companies and industries, but maybe particularly for not-for-profit organizations.  Since data is informing the decisions you’re

WordPress Appliance - Powered by TurnKey Linux