Posts Tagged ‘scripting’

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

Scripting inside SmartConnect

For all of you out there that have been doing scripting inside of SmartConnect, we have an excellent (although belated) New Year’s gift for you. We have assembled a collection of the most requested scripts over the last year and have commented and formatted each script in detail. They are now all bundled together and…

[Read More]

RECENT POSTS


Join Us for Our Q4-2018 Partner All-Hands Call
Directions EMEA 2018 Recap
Tech Tuesday: How to manually activate and deactivate SalesForce Apex Triggers
Integrate to Dynamics GP with Excel Templates
Checklist – 7 Ways to Ensure Your Salesforce and Microsoft Dynamics Integration Exceeds Expectations

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

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