Posts Tagged ‘Tech Tuesday’
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: 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: 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: 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: 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: 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: 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: 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: 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: 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]