Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: New Error Codes for GP 2013 R2


This week’s Tech Tuesday is from our support guru, David Youngquist, who with the latest upgrade process has recognized the need for new error codes when using SmartConnect below:

After updating from Microsoft Dynamics GP 2013 to Microsoft Dynamics GP 2013 R2, you may be receiving an error when running a Payables import that used to work. The error says:

 “Error codes were not found in table DYNAMICS..taErrorCode. Please insure that the table taErrorCode is up to update“. The error number given is either 11991, 11992, 11993, or 11994

Microsoft added some new fields to eConnect in Microsoft Dynamics GP 2013 R2, but did not update their error code table. You can download a script from here that will update your taErrorCode table. This will add the error codes, and also will update the SmartConnect database to add the new fields that Microsoft has added. 

After you run the script it will add 4 new fields to the taPMDistribution mapping in SmartConnect. You then need to go into your map, and add the mappings for those fields.

The first new field is named “Payment Type”. You need to either map a field to it, or use the drop down list to select the payment type. If the payment was made by cash you put a 1, if the payment was made by check you put a 2, if the payment was made by credit card you map a 3.

Depending on the payment type you need to map one of three additional fields. If it’s a cash payment, you need to map the cash checkbook ID (or set it to a constant) in the “Cash Amount Checkbook ID” field, if it’s a check payment, you need to map the check checkbook ID in the “Check Amount Checkbook ID” field, and if it’s a credit card payment, you need to map the credit card name to the “Credit Card Name” field.   


Have any questions regarding the new error codes or SmartConnect? Leave a comment or email us at info@eonesolutions.com!

2 Comments

  1. John Ondusko on August 18, 2015 at 5:20 pm

    Greetings – we have upgraded to GP2015 and when trying to integrate item data into the extender table we are getting the above error for code 25053. Is there an updated error list?

    Thanks
    John.

  2. Patrick Wellnitz on October 9, 2015 at 2:59 pm

    Hi John.

    We are receiving the same error under the same circumstances. wondering if you ever got it sorted.

    thanks!

Leave a Comment





RECENT POSTS


Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
Popdock's Top 10 New Features
New Webinar: Getting Started with Matrix Reporting in Popdock
Tech Tuesday: Popdock User Security in D365 Business Central
Popdock Data Lake Upload Tool for Dynamics NAV Data - FREE TRAINING

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.