HELP ARTICLES

Help Articles

  Thursday, December 8, 2011   /     Kevin
This article has been superseded by this article. Receiving an error when running a SmartConnect map that says "Could not retrieve next number in the sequence".  This may or may not be followed by a second error that says, "The execute permission denied on the E1_SC_GetNextNumber"This can be… [Read More]
  Tuesday, March 8, 2016   /     Brady Swenson
Recently I was working on a project that involved using the SmartConnect Excel 2013 Add-in to run a customized Map. After successfully installing the SmartConnect Excel Add-in, I found each time I would close Excel 2013 and re-open my spreadsheet the eOne Solutions Add-in ribbon (as you can see in… [Read More]
  Thursday, December 8, 2011   /     Kevin
When importing transactions with SmartConnect receiving an error that says "Violation of PRIMARY KEY constraint 'PKAAGx0000', cannot insert duplicate key in object 'AAGx0000'" where x is a number 1, 2 or 3This problem occurs because the next value in the AAG00102 table has already been used in the… [Read More]
  Tuesday, March 31, 2015   /     eOne Solutions
The Lifecycle PolicyThis policy states the standard support policies for all eOne products. This policy went into effect on August 1st, 2014. The standard policy allows for 5 years of Standard support and 5 years of Extended support for a total of 10 years of support for the products included, with… [Read More]
  Monday, June 18, 2018   /     Nicole Albertson
The SmartList Favorites SmartList Builder setup is designed to return a list of SmartList Favorites along with their save level. … [Read More]
  Thursday, November 8, 2012   /     David Youngquist
The SmartConnect scheduler service will not stay running.  When going into the Windows services, the service is stopped.  When the service is started, a message appears that says 'The eOne SmartConnect Service on Local Computer started and then stopped.  Some services stop automatically if they… [Read More]
  Wednesday, July 11, 2018   /     Patrick Roth
I have a Shopify REST connector set up in SmartConnect that has been working for some time.Now when I try to run a SmartConnect map using that Shopify REST connector as either a source or destination I get the error:Connection could not be validated.The underlying connection was closed: An… [Read More]
  Wednesday, January 18, 2017   /     Ethan Sorenson
When executing a map, we are getting this error. … [Read More]
  Thursday, December 8, 2011   /     Kevin
How to write a SmartConnect script that will return the current system date in a format that GP Dynamics will accept.return DateTime.Now.ToString("MM/dd/yyyy") [Read More]
  Friday, January 5, 2018   /     Nicole Albertson
The GL Trial Balance Summary by Year SmartList Builder setup is designed to return the Beginning Balance, Yearly Net Change, and Ending Balance for each account for each History and Open year.  This is data similar to the General Ledger Summary Trial Balance that can be printed in Microsoft… [Read More]
  Wednesday, April 10, 2019   /     Lorren Zemke
Using a Zip file as a SmartConnect Source … [Read More]
  Tuesday, March 5, 2019   /     Nicole Albertson
The RM Apply Detail SmartList Builder setup is designed to return the Receivables Apply Details for Microsoft Dynamics GP.  It will return the apply details for all posted RM transactions.  The script that is used in it is courtesy of Victoria Yudin via VictoriaYudin.com with only minor changes to… [Read More]
  Monday, February 25, 2019   /     Patrick Roth
The user is running a SmartConnect integration to Dynamics GP.On one machine, the integration fails with the error:Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or… [Read More]
  Friday, February 15, 2019   /     David Youngquist
I am attempting to write an after map script and use the GlobalFileName value to report the name of the source file with the error.  The GlobalFileName field does not appear to be populated.  GlobalFileName does not automatically populate, you would need to write your own script to insert a value… [Read More]
  Wednesday, February 13, 2019   /     Ethan Sorenson
If you have ever needed to pull a time field from Dynamics CRM, the chances are the time shown in SmartConnect does not match the value seen in the CRM web client. There is a reason for this discrepancy, and in this article we will discuss how to use a calculated column to convert the time to the… [Read More]
  Wednesday, February 13, 2019   /     Ethan Sorenson
I recently ran into a unique error when importing Sales Transactions into NAV 2017.Failed to create record. Unable to call service: Data object not provided.This error message is caused by bug in the web services in NAV 2017. The Odata web services link together parent and child data and creates the… [Read More]
  Tuesday, December 4, 2018   /     Ethan Sorenson
Recently I encountered a scenario where a client machine was returning the error, "The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception", when running a map that connects to SQL. The error message is a standard .NET Framework error, that is saying .NET can't create the… [Read More]
  Monday, November 26, 2018   /     Ethan Sorenson
What is FIPS?Windows has a setting that prevents applications on the machine from using encryption that are not compliant with Federal Information Processing Standards(FIPS). This setting is typically only needed for servers that contain government data. Here is a good article about FIPS and why it… [Read More]
  Tuesday, November 20, 2018   /     David Youngquist
 
Trying to setup the SalesForce connector and receiving the error, "INVALID_LOGIN: Invalid username, password, security token; or user locked out."First confirm that you can login to SalesForce manually using the same username, password, and security token.  If they are correct, and you can login… [Read More]
  Monday, November 19, 2018   /     Patrick Roth
I've installed the latest SmartView (Internal) on my GP 2013/2013 R2 system and it seems to work well.However when I try to use any of the GoTos for my SmartList Builder reports, SmartView gives the error:Unknown identifier 'GenerateTableTypes'.The destination GoTo window does not open. The GoTos… [Read More]

FILTER BY PRODUCT


ARCHIVES

open all | close all

TAGS

Business Central CRM 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 Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartView SOP SQL Support Tech Tuesday Templates training