While trying to Print a Bank Transaction History Report using an Audit Trail code we ran into a bit of wall and began receiving the following error message:

Symptom: “An error occurred executing the SQL statements”
“GPS Error: 54″
“Violation of PRIMARY KEY constraint “PK##2100625′.  Cannot insert  duplicate key in object ‘dbo.##2100625′”
“ODBC Error: 23000″ Read the rest of this entry »

We’ve been asked a few times lately if Dynamics GP Electronic Banking can be setup for a CTX (Corporate Trade Exchange Records) file format.  Here is the scoop regarding the CTX file…

The Beta version Dynamics GP v10 had a CTX format; however, it conflicted with the other EFT formats so it was deceided to take it out Dynamics GP.  

You do have options.  Some businesses have used the ISO20022 format and worked with the bank to provide an acceptable format.  The other option is  NextTech that has an option for a CTX format within Dynamics GP.

Service Pack 5 for Microsoft Dynamics GP 10.0 Causes Performance Issues in Electronic Funds Transfer (EFT) for Receivables Management.

Click Here to go to Customer Source / Partner Source for full article and fix.

Discover the advantages of electronic reconciliation with Microsoft Dynamics® GP in this exclusive I.B.I.S. webinar.

Watch this educational webinar to learn about electronic reconciling, how it can benefit your business, what file formats are required, how to set-up electronic reconciliation and when to use it.

Title: Electronic Bank Reconciliation – Microsoft Dynamics® GP

Speaker: Abby Moore, I.B.I.S. Consultant

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)