Posts Tagged ‘Tech Tuesday’

Tech Tuesday: Fix Missing GP Accelerator Keys with Extender Enterprise

I’ve seen this question several times over the last few months and typically happens after a customer updates their GP from 2010 to a newer version.I’ll get a screenshot like this (boxes added by me for later clarification)Fig 1: GP 2010 with Accelerator keys visible for GP windowsand a message similar to this:I have just…

[Read More]

Tech Tuesday: Issues to be aware of when creating maps that use text ODBC drivers

I get a lot of calls from people saying that SmartConnect isn’t working right. It’s either not reading their data correctly, or it’s not reading all the columns from their source file, or it’s actually saying that the source file is completely blank, when in fact it does have data in it. Most of these…

[Read More]

Tech Tuesday: We want to hear from you!

Each Tuesday (and let’s be honest, sometimes Thursdays instead), we share tips and tricks around one of our products. The topics often come from common things we hear in our support queue or deal with on the services side of the house. Well, this week, we want to hear from you! Are there tips and tricks…

[Read More]

Tech Thursday: Referencing a SmartConnect Calculated Field

SmartConnect On-premise utilizes .NET scripting for creating data transformations that are more complex than can be used for the Translation Table, Date Translation or Rolling Column additional columns. However, while it is not capable of creating functions or methods to be used between integrations, calculated fields can be referenced and used within the same map.…

[Read More]

Tech Tuesday: Connecting to Sales 365 with Multi Factor Authentication

If your Office 365 account is using multi factor authentication and you want to use it to connect to Sales 365 with SmartConnect, you will need to do a few extra steps within your Office 365 account to make the connection.  Login to your Office 365 account – https://portal.office.com/account Navigate to Security & privacy>>Additional security…

[Read More]

Tech Tuesday: Conditionally Auto Opening an Extender Window with Extender Enterprise

The initial question was straightforward:I have an Extender window based on the Item Number in the Sales Transaction Entry scrolling window, is there a way to conditionally automatically open the Extender window based on that Item Number?We can start with the “easy” answer (ignoring the “conditionally” parameter).Extender can be configured to auto open an Extender…

[Read More]

Tech Tuesday: Unable to retrieve the next number in the sequence

SmartConnect makes use of stored procedures in each company database to retrieve default document numbers from GP. If these stored procedures are not present, you will receive errors saying, “Could not retrieve the next number in the sequence.” The stored procedures get created when you run the system maintenance in SmartConnect. Normally the solution to…

[Read More]

Tech Tuesday: Understanding SalesForce queries in SmartConnect

This week we are going to go over something that can be very challenging for someone that doesn’t come from a SalesForce background. We will go into detail about how to build a SOQL query using the developer console in SalesForce and how to join multiple SalesForce Objects. Where to build a SalesForce querySmartConnect on-premise has…

[Read More]

RECENT POSTS


Managing Posting Dates Across Multiple Companies/Locations in D365 Business Central
Free Samples (ie Sample Data!) with Popdock
The Pick Popdock Papers, Part III: Know Your Audience
Employee Spotlight: Jess Green, Partner Development Manager
Get Creative With Your Dynamics GP Data

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
New Releases of Extender and SmartList Builder
2017 SmartConnect Integration Bootcamps

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight Events Excel Excel Report Builder Extender Extender Enterprise Flexicoder GP GPUG integration integration manager Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk