If you missed our Free Webinar on Electronic Bank Reconciliation and would like to view CLICK HERE

Find out what the advantages are to using Dynamics GP E-Reconcile.  How you can improve your business’s bank reconciliation method.  As well as, see how to setup and use E-Reconcile. 

Electronic Bank Reconciliation
Date: 7/27/2010 11:00-12:00 EST
Speaker: Abby Moore, Consultant
eReconcile advantages, setup and usage.

Dynamics GP 10 – Service Pack 4

An excerpt from MS Dynamics GP Partnersource published as of 07.01.2010…

IMPORTANT NOTICE: We have pulled our mid-year tax update.  We will be releasing a new MSP file the week of July 5th that will fix the following:
- Check Register employer FICA owed includes employer liability amount
- New Hire Act Report reduces by all deductions
- 941 incorrect for line 6e
If you have installed the msp please be aware of these issues.

An excerpt from MS Dynamics GP Partnersource published as of 06.25.2010…

CLICK HERE to view full article and downloads.

“The National Automated Clearing House Association (NACHA) and Office of Foreign Assets Control (OFAC) have published new specifications for International ACH Transactions (IAT). As of September 18, 2009 the new IAT code will need to be in place that requires participants to identify international transitions and to code these transactions as IAT transactions.
Additional information regarding the specification can be found at
http://www.nacha.org/IAT_Industry_Information/
�
Microsoft Dynamics GP 10 Service Pack 4 includes the new International ACH Transaction (IAT) ACH format changers.  

�
Note: The Royal Bank of Canada file format specification changes will also be included in Microsoft Dynamics GP 10 Service Pack 4.”

Microsoft Partnersource had a an article that posted this morning, “No Sorting Options for EFT Check Remittances in Microsoft Dynamics GP 10.0″

I know that many of you print Remittances after your EFT  run and you have noticed that it will only print by check number.  Well, here is one “How To” solution that will allow you to print by Vendor Name instead.

CLICK HERE for full article.

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? 

Read the rest of this entry »

Electronic Reconcile is part of the Electronic Banking series in Dynamics GP.  If you are not using it yet consider the time saving possiblities.  Instead of having to manually check off each cleared transaction in Bank Reconciliation you upload a file from your bank.  Easy.  With the exception of a BAI (Banking Administration Institute) type file Electronic Reconcile works with fixed field, comma delimited and tab delimited type files.  Here’s a senerio of how the functionality works…

Read the rest of this entry »

A few months ago there was this discussion revolving around  Dynamics GP EFT (Electronic Funds Transfer).  The conculsion of this discussion identified a need…a need to create a custom EFT template for Receivables, which unfortunatly is not available in Dynamics GP 10.   Well, readers here it is…but it’s in Dynamics GP 2010. 

(Finance>>Cards>>EFT File Format)

By now you  probably have heard of the Microsoft Dynamics GP Miscellaneous Check window.  A simple  to use window that  looks a little like it is from the QB (QuickBooks)family.  This window is easy to use and  quick for processing a check or multiple checks, however, there are some differences between using this window and using Payables Management to cut a check.  What you should know… Read the rest of this entry »

Have you ever seen Negative Amounts in your Bank Reconciliation window?  They would look something like this…

What may cause negative amounts in the Bank Reconciliation Window? Read the rest of this entry »

We were having an email discussion the other day around what Dynamics GP’s Electronic Bank Reconcile will or won’t reconcile. One of our consultants Amy Walsh had the most complete answer and it sure sounded like a nice blog post so here it is. Thanks Amy!

Electronic Bank Reconcile matches both checks and deposits.  Any other transactions have to be marked off manually.

See excerpt below for transaction type and action.

BAI (Bank Administration Institute) file formats have a number for the transaction code. For example, 100 may be a check. 200 & 300 may be some other type of withdrawal. 400, 500, 600 maybe different types of deposits. The problem with that is, when you go to enter a transaction code you can only enter 1 code for check and 1 code for deposits when in the BAI file their maybe many types of codes. The transaction code is required in the configurator.