Dynamics GP – Electronic Banking with 2 Account Numbers for one Checkbook
By Amy Walsh in Banking, Dynamics GP on Monday, June 21st, 2010
One bank account with 2 different checking account numbers. ? Really. Technically, there aren’t 2 bank account numbers there is only 1, however, certain electronic banking files were not updated yet to reflect the new account number on the bank’s end. So outgoing transmission is using one account number while incoming bank transmission is using a different checking account number. How do you deal with Electronic Banking’s Safepay, Electronic Reconcile using 2 different checkbook account numbers?
First of all, we are using Mekorma for check processing. Since Mekorma (MICR) has its own setup window and fields to add the routing and account numbers there is no issue.
Electronic Reconcile uses the checking account number from the checkbook set up in Cards>>Financial>>Checkbook | Bank Account field. Here we used the account number indicated in the incoming file from the bank.
Safepay configuration also requires the Bank Account field from Cards>>Financial>>Checkbook. However, here is where it is a little tricky. The outgoing file for Safepay required a different bank account number from what is set in the Bank Account field in the Checkbook.
Resolution…In Safepay configuration we used one of the filler fields indicated in the bank’s specification and selected “Account Number” in the “Standard Fields.” See below. Then select the “Filler Type”. In this case we used spaces which actually will override the account number from pulling into the file Bank Account field in the Checkbook. In the rest of the Safepay configuration where we needed the correct bank account number to meet the bank’s specifications we set those fields to a constant.
Although this situation is a rarity it can happen as banks reorganize and merge.
About Amy Walsh
Amy Walsh is an Accountant and Senior Consultant with I.B.I.S., Inc. As well as, Microsoft Certified Business Management Solutions Professional - Dynamics GP
Tags: Dynamics GP 10 Bank Reconcilation, Dynamics GP Safepay setup
Posted in Banking, Dynamics GP
Need Expert Help With Dynamics GP?
Get the support you need to effectively manage your business.
Learn more about our Dynamics GP support options
[...] Walsh takes a look at an issue that we ran into recently. A client had two bank account numbers for a single account. Somewhere along the way the bank had merged or been acquired and the client’s account number [...]