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]
  Friday, September 6, 2019   /     David Youngquist
Using an Excel data source, and receiving an error that says "Connection could not be validated".  When clicking on Details, the message says "ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"This is caused by not having 32 Bit Excel/Office… [Read More]
  Wednesday, September 4, 2019   /     Ethan Sorenson
Cards in Nav/Business Central can have default dimensions assigned. These dimensions are not stored on the card, but rather in the Default Dimensions table. Therefore, after the card is created a second mapping will need to be used to add the dimensions.MappingA new web service will need to be… [Read More]
  Wednesday, August 28, 2019   /     Ethan Sorenson
When creating a Sales Order or Sales Invoice in Business Central, you will receive an error like the one shown above if trying to define a Ship-to Address.*Note that any code provided is for use as a point of reference and will not be supported by eOne Solutions. CauseWhen you change the… [Read More]
  Friday, August 23, 2019   /     Patrick Roth
I'm using the WinSCP application to connect to my SFTP server.I can connect and upload/download files successfully when using the WinSCP application included in the download, but when I try to connect via SmartConnect scripting per this blog article, it fails with the… [Read More]
  Friday, July 12, 2019   /     Ethan Sorenson
When importing a Sales Invoice or Sales Order to Business Central and receive the below error message.Type must be equal to 'Inventory' in Item: No.=XXXX. Current value is 'Service'.CauseThe line item has been setup as a Service type Item. This can be verified by checking the Item Card for the field… [Read More]
  Tuesday, July 9, 2019   /     David Youngquist
Attempting to start the "eOne SmartConnect Service" in Windows and receiving an error that says, "Error 1068: The dependency or group failed to start."Make sure that the user you have configured to start the "eOne SmartConnect Service" is an administrator in SmartConnect.  Also make sure that the… [Read More]
  Wednesday, June 12, 2019   /     Devon Binstock
One question that can come up in SmartConnect is, "How can we delete source files that have been moved into a folder, such as an archive folder"? … [Read More]
  Monday, June 10, 2019   /     Ethan Sorenson
If you are importing a Sales Transaction using the Business Central web services and receive this error, then a workaround will be required to import the record.The Sales Header does not exist. Identification fields and values: Document Type=’Quote’No.=’’ CauseThe cause for the error is… [Read More]
  Tuesday, June 4, 2019   /     Devon Binstock
One question that often comes up in SmartConnect is, "How do I exclude certain rows from my data source?" … [Read More]
  Thursday, May 30, 2019   /     Devon Binstock
Why does my map run show more records being processed than exist in the data source? … [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