Posts Tagged ‘scripting’

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

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]

Datetime field in SmartConnect different than in Dynamics 365 Sales/CRM

How to resolve the datetime field in SmartConnect displaying a different value than in the  Dynamics 365 Sales/CRM User Interface.CauseSmartConnect uses the D365 web services to pull your data source. The web services return datetime fields exactly as they are stored in the D365 SQL tables. There are four ways datetime fields are stored.User Local:…

[Read More]

SalesForce Date Field Imports

SalesForce will want “Date” and “Date Time” fields to be sent in the correct format.SalesForce “Date” acceptable formatyyyy-MM-ddyyyy-MM-ddThh:mm:ssSalesForce “Date Time” acceptable formatyyyy-MM-ddThh:mm:ssExample conversion scriptsreturn DateTime.Now.ToString(“yyyy-MM-dd”)return DateTime.Now.ToString(“yyyy-MM-ddThh:mm:ss”)return Convert.ToDateTime(_SOURCEFIELD).ToString(“yyyy-MM-dd”)return Convert.ToDateTime(_SOURCEFIELD).ToString(“yyyy-MM-ddThh:mm:ss”)

[Read More]

How to set a checkbox field using Extender Enterprise

I’m trying to check the “Allow SO Commitments” field in Purchase Order Entry using an Extender Enterprise Set Field Values action.  However I’ve tried setting the value to 1 or TRUE or “TRUE”, I always get the error:Type incompatibility ‘Allow SO Commitments’.How can I set this field to be checked?  From a Dexterity perspective, Checkboxes and…

[Read More]
Tech Tuesday

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]

SmartList Builder 2013 New Feature of the Day: SQL Scripting

SQL Scripting is a feature that will soon be available in SmartList Builder and Navigation List Builder with the next release.  You will no longer have to go to SQL Management Studio and create a SQL View to pull into SmartList Builder when you want to write SQL Scripts to get the data you need.The…

[Read More]

Extender 2013 Feature of the Day: Improved Scripting

What has changed in the scripting?The Enter Script window has been simplified and make to work similar to the way the Add Calculated Field window works.  Whether you are entering a Dynamics GP Script or a SQL Script, the window will look about the same.  The SQL Script window will ask you which company to…

[Read More]

Tech Tuesday – SmartConnect 2012 Scripting Updates

This Tuesday we’re taking a quick look at the scripting windows in SmartConnect. There are a couple of improvements that have made scripting much easier and more useful in SmartConnect in the latest 2012 versions.I am especially excited about these new features since a lot of my work in SmartConnect revolves around developing scripts and…

[Read More]

RECENT POSTS


SmartConnect Bootcamp in Houston, TX
Last Chance! Join the Partner All Hands Call Tomorrow!
Setting up a Basic Authentication Service in SmartConnect.com
SmartConnect Office Hours: Configuring a Netsuite Connector
Tech Tuesday: Adding Company ID to SmartList Builder Multicompany Summary Report

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 Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Office Relationships partners Popdock release Reporting SalesForce SalesForce.com scripting SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Office Hours SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk