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]

Sample Scripts

sample scripts for SmartConnectsample scripts for performing various data manipulations inside of SmartConnect.NOTE: Scripts are provided as is. Assistance with installation or modification of the scripts is available as a billable service from our professional services team.Following is a listing of what each script does:AccountSegments.txt – This scripts takes an unformatted account number and breaks…

[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]

RECENT POSTS


Tech Tuesday: Making sure GP is active for SmartPost
Throwback Thursday: Troubleshooting Scheduled Maps
Employee Spotlight: Sandy Westman, Senior Consultant
eOne Offices Closed for Labor Day - Monday, September 7th
eOne Presenting at DynamicsCon 2020 - Free Virtual Conference

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

ARCHIVES

open all | close all

TAGS

Business Central CRM 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 partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartView SOP SQL Support Tech Tuesday Templates training