Skip to content
+1-888-319-3663

Tech Tuesday: SmartConnect Purchase Order Map Error

If you are running a purchase order map and receiving an error that says “370 /* Subtotal (SUBTOTAL) does not match the line item totals” we have an easy fix for you. The Microsoft eConnect SDK has this field marked as required, as it used to be required in older versions of eConnect. The SmartConnect…

[Read More]
Tech Tuesday

Tech Tuesday: Setting up the NetSuite Connector in SmartConnect.com

NOTE: SuiteSignOn is no longer supported by Netsuite and is not an available authentication type in SmartConnect. Token Based Authentication will be the only option, so any existing connections will need to be changed to Token Based Authentication.Setup for Token Based AuthenticationEnable Token Based AuthenticationIn NetSuite, Navigate to Setup>>Company>>Enable Features. Click the Suite Cloud tab…

[Read More]
Tech Tuesday

Tech Tuesday: Executing SmartConnect 2018 Maps from SQL

There are many ways to execute a SmartConnect map; through the interface, scheduled, called by the web service, etc. But one method that also works which isn’t talked about as much is executing a map directly from SQL. The SQL code below covers both the initial setup needed to run maps in this manner as…

[Read More]
Tech Tuesday

Tech Tuesday: SmartConnect 21 Import Process

The import process for SmartConnect 21 is a bit different than it was in SmartConnect 2018. This article will show how the import process works in SmartConnect 21.NOTE: You can NOT import exports of SmartConnect 2018 integrations into SmartConnect 21. Only exports from SmartConnect 21 can be imported.The first step to importing in SC 21…

[Read More]
Tech Tuesday

Tech Tuesday: New 1099 Type Nonemployee Compensation in Dynamics GP

Every once in a while you get a curveball that takes you by surprise.This year, that curveball came in the form of the Dynamics GP 2016 and GP 18.3 YE releases in which GP added in a new 1099 Type – Nonemployee Compensation.Since this release, several eOne customers have seen “issues” in reference to this…

[Read More]
Tech Tuesday

Tech Tuesday: Using SmartConnect to Integrate with Multi-Entity Management for Business Central

In the last week I had 3 separate conversations with customers implementing MEM and Binary Stream’s Multi-Entity Management (MEM) for Business Central and SmartConnect. There were some recurring questions and concerns in these discussions that I want to clarify for all our customers and partners. Note: SmartConnect has been compatible with Binary Stream’s Multi-Entity Management (MEM)…

[Read More]
Tech Tuesday

Tech Tuesday: SmartConnect.com Multi Data Sources

There are times when we need to leverage data from multiple connectors in one data source. When this need arises we can leverage the querying power of Popdock to pull data from an unlimited number of connectors. Table of Contents Popdock Connector List Types Compare Lists Join Lists Merge lists Create a Popdock Data Source…

[Read More]
Tech Tuesday

Tech Tuesday: SmartConnect Setup for Office 365 E-Mail with TLS

Recently we have encountered multiple customers who have TLS turned on for communication with their Office 365 Email system instead of SSL. This in turn prevents their SmartConnect system from sending emails on map tasks.Just in case you are not aware of the ability to send emails within SmartConnect, click here for a refresher on…

[Read More]
Tech Tuesday

Tech Tuesday: Using Variables in a Web Service Action Endpoint

Many web services require the use of a path parameter to complete a request. For example, the Teamwork Add Time Entry endpoint requires a project id to be able to add time an invoice: base_url/invoices/{id}/lineitems.json. If we entered the project id path parameter directly in the url, the endpoint will only work for one project.…

[Read More]
Tech Tuesday

Tech Tuesday: Business Central Item Image Web Service

Today we will look at how to use SmartConnect to import/export files with NAV/Business Central. These files can be several different types including JPG/PNG/PDF/MP3/MP4, you can find a full list of supported types here. The most common requirement we see is to import image files or attach invoices and receipts. I will show how I…

[Read More]

RECENT POSTS


eOne Announces Partnership with Akita Intelligent Solutions
Happy Thanksgiving! - eOne's US Offices Closed November 24 & 25
Recording Now Available! - 2022 Q4 Partner All Hands Call
The Query Builder: Queries for the Non-Developer in D365 Business Central - Recording Now Available!
2023 eOne SmartConnect & Popdock Bootcamps

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 Meet the Team 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