Integrating Vendor EFT Information Into Dynamics GP | alldynamicsgp

Howard looks at Integrating Vendor EFT Information Into Dynamics GP Another option is to use Table Import for just the EFT pieces.

How to modify a field value in a line when generating the EFT file? - Developing for Dynamics GP - Site Home - MSDN Blogs

Writing at Developing for Dynamics GP, Viswanathan Neelakantan shows How to modify a field value in a line when generating the EFT file?

Feature of the Day: EFT Format Enhancements

In a new Feature of the Day Microsoft shows off EFT Format Enhancements

Quick Step Guide to E-mail PM EFT Remittances in Microsoft Dynamics GP 2010

The GP Support and Services blog has a Quick Step Guide to E-mail PM EFT Remittances in Microsoft Dynamics GP 2010

Dynamics GP Land: Problem with Dynamics GP 2010 EFT Payables CCD+ CTX File Format

Steve Endow encounters a Problem with Dynamics GP 2010 EFT Payables CCD+ CTX File Format

Common questions for PM EFT in Microsoft Dynamics GP - Dynamics GP Support and Services Blog

From the Dynamics GP Support and Services Blog, Cheryl W. answers Common questions for PM EFT in Microsoft Dynamics GP

Enabling Email Cheque Remittances For All Suppliers | azurecurve

Ian Grieve digs into Enabling Email Cheque Remittances For All Suppliers. For Bob in Tampa, Ian knows how to spell “Check” he’s from England and they prefer “Q” to “C”. It keeps out the riff raff.

EFT computer batches going to Batch Recovery in Payables Management - Dynamics GP Support and Services Blog

From the Dynamics GP Support and Services Blog comes help with EFT computer batches going to Batch Recovery in Payables Management

Mohammad R. Daoud: Vendor Notifications on EFT Bank Transfer

Mohammad Daoud was kind enough to build some SQL for Vendor Notifications on EFT Bank Transfer.

SQL Script for Vendor EFT Information | Interesting Findings & Knowledge Sharing

From Sivakumar comes a SQL Script for Vendor EFT Information

Mohammad R. Daoud: Empty “Table Name” when doing Import/Export for EFT File Format

Mohammad Daoud resolves an Empty “Table Name” when doing Import/Export for EFT File Format.

Weekly Review: Reconcile ACH Batches

Mariano Gomez had a great piece of advice on the Newsgroup regarding ACH batches and Bank Rec so I decided to formalize it and turn this into a Weekly Dynamic.
Many companies submit an ACH file to their bank to pay vendors. The bank will often process the transaction as a lump sum debited from the bank account rather than as individual transactions. This makes reconciling difficult because you need the ACH batch info to match back to the individual transactions that were sent to the Bank Reconciliation module but the bank statement will only show one amount

Well, here is a fix. Use the ACH file that you sent to the bank as your source file for the Electronic Reconcile module. Let Electronic Reconcile check off the ACH transactions for you. This also provides a better level of consistency for your auditors.
If you are on the Advanced Management tier of Business Ready Licensing you already own Electronic Reconcile to go along with EFT for Payables so there is nothing else to buy to make this happen.

Posted by Mark at 12/08/2008 09:00:00 AM

Adopting new GP2010 features - Kuntz Consulting

Kuntz Consulting has a new post up looking at Adopting new GP2010 features . Specifically they deal with new EFT remittance feature but the principals are also discussed more broadly.

Dynamics GP – Electronic Banking- EFT (CTX file)

Amy Walsh of I.B.I.S. has a great look at options for using a CTX file for EFT in Dynamics GP.

Weekly Review: EFT for AP in GP 10

Today we're looking at EFT for Payables in GP 10. So what's new?

•Well the setup has moved to the checkbook and the vendor card! Click the EFT Setup button on a checkbook to access (Cards-Financial-Checkbook) and the EFT Bank button on the Address window portion of the vendor card.

•More options are available for more countries which is a big plus

•You now have an option to use EFT numbers and plain paper for your remittances instead of check numbers and check stock. We ran into problems when check stock remittances cleared the bank despite big, red, non-negotiable stamps, not to mention the expense. This is good news!

•EFT for Payables now supports CCD, CCD+ and PPD+ in addition to others. That should stop some whining. (It won't)

•There are 4 options for EFT formats for a single bank account, business, corporate, individual and foreign and you can control which of the 4 is used by vendor. So expense reports could use the Individual format and be formatted as PPD's and supplies could use the corporate format and transfer as CCD's. I'm not sure I'm being clear. If you set one up you'll understand.

•Prenotes are optional

Also, v10 offers an import/export option for settings.
 
Originally Posted by Mark 12/17/07

How to Sort EFT Check Remittance by Vendor Name

Over at at DynamicsCare, Amy Walsh has a nice look at How to Sort EFT Check Remittance by Vendor Name. You don’t necessarily need them in order to mail them but if you keep a copy for filing this is important.

Weekly Dynamic: Reconcile ACH Batches

Mariano Gomez had a great piece of advice on the Newsgroup regarding ACH batches and Bank Rec so I decided to formalize it and turn this into a Weekly Dynamic.

Many companies submit an ACH file to their bank to pay vendors. The bank will often process the transaction as a lump sum debited from the bank account rather than as individual transactions. This makes reconciling difficult because you need the ACH batch info to match back to the individual transactions that were sent to the Bank Reconciliation module but the bank statement will only show one amount.

Well, here is a fix. Use the ACH file that you sent to the bank as your source file for the Electronic Reconcile module. Let Electronic Reconcile check off the ACH transactions for you. This also provides a better level of consistency for your auditors.

If you are on the Advanced Management tier of Business Ready Licensing you already own Electronic Reconcile to go along with EFT for Payables so there is nothing else to buy to make this happen.

Fusing GP and PayPal with EFT for AP

Mariano Gomez has a great post on using EFT for Payables to push payment information to PayPal. I love creative ideas like this that demonstrate the flexibility of Dynamics GP. By using EFT, instead of a Smartlist or report, Mariano maintains the AP controls that help prevent duplicate payments and fraud. Very nice job Mariano!

Weekly Dynamic: EFT for AP in GP 10

Yeah, I know, these things aren't always weekly. Send me a written request and I'll send you a refund.

Today we're looking at EFT for Payables in GP 10. So what's new?

• Well the setup has moved to the checkbook and the vendor card! Click the EFT Setup button on a checkbook to access (Cards-Financial-Checkbook) and the EFT Bank button on the Address window portion of the vendor card.
  
• More options are available for more countries which is a big plus
• You now have an option to use EFT numbers and plain paper for your remittances instead of check numbers and check stock. We ran into problems when check stock remittances cleared the bank despite big, red, non-negotiable stamps, not to mention the expense. This is good news!
• EFT for Payables now supports CCD, CCD+ and PPD+ in addition to others. That should stop some whining. (It won't)
• There are 4 options for EFT formats for a single bank account, business, corporate, individual and foreign and you can control which of the 4 is used by vendor. So expense reports could use the Individual format and be formatted as PPD's and supplies could use the corporate format and transfer as CCD's. I'm not sure I'm being clear. If you set one up you'll understand.
• Prenotes are optional

Two last things. I'm hearing that settings are not transferring well with upgrades. This means you should print screen your settings before upgrading. It shouldn't take much to reenter them if you have to.

Secondly, v10 offers an import/export option for settings. I don't think that this is in 9.0 but I'll look tomorrow.

I don't have enough experience with the 10 version yet to highlight any quirks but it certainly appears more flexible than it's 9.0 counterpart.