Microsoft Dynamics GP October 2022- Summary Display in Bank Reconciliation for EFT

Hello Microsoft Dynamics GP Community!  

I'm so excited to talk about some of these features for the October 2022 release, this feature especially as I think many customers will implement these changes.  Ironically, I was just asked this from another partner two weeks before we shipped:

Terry, 
We are starting to have more customers that need check batches to post to bank rec/GL by individual check but go into bank rec/GL as a total for the EFT batch because that is how they come through on the bank statement. Are there any plans to separate the post settings for checks and EFTs?

This is a new feature that will make EFT users happy and save lots of time on the Bank Reconciliation for EFT payments. Dynamics GP users would like to see an EFT batch summary in Bank Reconciliation, like the Payroll Direct Deposit Earnings Statement summary option. When an EFT file for payables is sent to the bank, they deduct the entire summary amount from your account on one line. However, GP posts the EFT payments as individual payments in Bank Reconciliation, so reconciling is difficult and time consuming. By posting the EFT payments in summary it aligns better with the lump sum amount of the EFT file listed on the bank statement.

When marked, if an EFT batch of vendor payments is posted, the Bank Reconciliation is updated with a single EFT payment that is also linked to a breakdown of the detail, like what we show for automatic deposit of Cash Receipts. You can zoom back on a document number from Checkbook Inquiry to see the payments that make up the consolidated transaction.

From the Purchasing Area page under Setup choose Payables

The Payables Batch Entry window will show the option Post Payment of Summary or Transaction when the Payment Method of EFT is selected:

The checkbook Posting Journal will show summary posting activity and you can also drill back to Payables Summary Posting Inquiry window to show detail of payment.

A few caveats to this feature, it does not apply to Manual checks in Microsoft Dynamics GP and this new field in Payables setup will not be enabled automatically at time of the upgrade of your system.

NOTE:  If you mark this box and use Dynamics GP SafePay, and you mark this box, the EFT amounts will populate the SafePay file which some customers may not want.
To get around this, indicate in the Transaction Types Entry window within Safe Pay Configurator to "Omit Checks with Alphas" for the Transaction Type Check.

There was a new column to store this setup information in table PM40100, column AllowSummaryPost.

Enjoy this highly requested GP feature.

Continue to check back to the Microsoft Dynamics GP October 2022 - Feature Blog Series to review upcoming blog posts related to our new features and other helpful resource links.

For detailed documentation on all the features: Microsoft Dynamics GP Detailed Documentation

Terry Heley
Microsoft