Posts Tagged ‘Tech Tuesday’
Tech Tuesday: Extender Window Positioning
With the Extender 2018 release (18.00.0015) on April 6th, a new feature was added to change the window position of the Extender Windows.In previous releases and builds, the Extender windows would open on top of the current Microsoft Dynamics GP window. If you wanted to see the Extender window and the GP window at the…
[Read More]
Tech Tuesday : How to translate your data 5 different ways
There are many times when you are integrating data from multiple systems that you need to translate the values to what the new system expects. Today I will discuss five ways to handle this inside of SmartConnect.We will start with a set of Leads that exist in Excel and we need to bring them into…
[Read More]
Tech Tuesday : How to Handle Paging with Shopify in SmartConnect
If you have connected to Shopify using SmartConnect and have more than 250 records to query (Customers, Products, Orders, etc.) in your Shopify account you have likely run into the Shopify API limit. Shopify limits each call to 250 records and breaks them out into pages. To handle this, we need to run a map…
[Read More]
Tech Tuesday: Setting Up Dynamics NAV-Excel Template Connections
Setting up an Excel template can take less than 5 minutes or can take more than a day if you don’t know what you’re doing. After reading this article, I’m hoping to move a few more people into the 5 minutes or less crowd. The setup is the same for Microsoft D365 Financials Business edition,…
[Read More]
Tech Thursday : Extender Enterprise Pre Save Task
Have you ever needed the ability to stop a record from saving in Extender based on some criteria? You have, well so have we! We added the ability to Extender Enterprise 2016 (version 16.00.0030 and higher) and Extender Enterprise 2018.While we cannot stop the save process of every process, we have added the ability to…
[Read More]
Tech Tuesday : Getting more out of Flexicoder by using Extender Windows
Many people have saved thousands of dollars by using Flexicoder to have business rules automatically recode or change distributions in Dynamics GP but sometimes we hear that they would like additional areas that they can use to change the distributions. In this article, we will explore using the built-in functionality of making Extender fields available…
[Read More]
Tech Thursday: Making SmartView and Binary Stream work together
For those of you using Binary Stream, you know that there are SmartLists specially built to pull in the additional data. These are specifically built by Binary Stream to pull in their additional data as well as take into account the additional security that they add. Because these lists are built to specifically work with…
[Read More]
Tech Thursday : Query a Dynamics NAV Page using Excel Power Query
When creating a map sending data into Microsoft Dynamics NAV from Excel, it is often useful to be able to query existing NAV pages for lookups or populating data validation dropdowns in Excel. Fortunately, Excel Power Queries make it very easy to see the contents of a NAV page! To create the query, all we…
[Read More]
Tech Tuesday : Using Parameters to Enhance the REST Connector Setup
Hey everyone! Today we are looking at using different parameters within the REST Connector to either give additional options during running the map, pass through header information on any request, or to allow for bulk adjustments on the setup of the endpoints/methods themselves.This article is aimed at users who have worked with the REST Connector…
[Read More]
Tech Tuesday : Implement Extender Form Next Number for SmartConnect Import
With an Extender form, you can create standalone data within the Dynamics GP environment. With this standalone data, there are many times where the users should not enter their own ID/Key value so the numbering sequence stays consistent. In this case, we can set the ID field on the Extender Form to Auto Increment. The…
[Read More]