An Error Occurred while Re-Registering 'Real Time Event'

I am running SmartConnect System Maintenance and am receiving the following error message.Error: Microsoft Dynamics Gp- An error occurred while Re-Registering ‘Real Time Event’ ‘Update’ for ‘Connector ‘SmartConnect Dynamics GP Connector”: Invalid object name ‘SC9400’.This is due not having run the Dynamics GP Resource Cache. To be able to do this, you need to make…

Read More

This application is not configured to run with this operating system

We just installed Excel 2016 and when we open a SmartConnect map that uses Excel as a Data Source we receive the error “This application is not configured to run with this operating system” This is due to running Office applications in compatibility mode or by a corrupted installation of Microsoft Office. Please refer to…

Read More

Integrating Dynamics GP PO Line ignores duplicate items

I am integrating Purchase Orders that contain the same Item Number multiple times but SmartConnect is ignoring the “duplicate” item number. Microsoft eConnect will assume the duplicate item number is an update to an existing line on the Purchase Order if the Purchase Order Line ORD (Sequence Number) is not included in the integration. The fix…

Read More

Tech Tuesday: Adding Script Namespaces to SmartConnect

SmartConnect has a feature that allows users to add scripting namespaces to enhance the scripting capabilities in any of the coding windows within SmartConnect (calculations, script tasks, restrictions, etc). SmartConnect has a few generic namespaces that include the majority of the classes and methods you would use in most scripts; this includes System.Windows.Forms, System.IO, System.Data.SqlClient,…

Read More

Troubleshooting ODBC Data Source Errors in SmartConnect

One of the most common methods of integrating data using SmartConnect are Microsoft Excel Files or flat files such as comma or tab delimited. To make connecting to these files quicker and easier, SmartConnect contains a list of Excel versions that can be selected or we can just pick Text File from the source list…

Read More