Skip to content
+1-888-319-3663
Tech Tuesday

Tech Tuesday : Making an Extender Field Conditionally Required with Extender Enterprise

I’ve been asked a few variations of the questions below few times lately:Can I have a Field 2 on my Extender Window/Form be required conditionally depending on what Field 1 is set as?OrCan I set a field on my Extender Window to be required conditionally based on what a GP window field is set to?The…

[Read More]
Tech Tuesday

Tech Tuesday : Change SmartConnect AD User and Username

For today’s article, I thought I would touch on as many topics that I could think of that involved setting up users for SmartConnect Security as well as related topics that we get frequent questions on in support.One of the first things that trip users up is setting up their users in SmartConnect Security.The SmartConnect…

[Read More]
Tech Tuesday

Tech Tuesday : Error Trying to Import Translation Table in SmartConnect

Translation tables in SmartConnect are used to transform information from one value to another in SmartConnect if there is a change from what the input source file looks like and what the destination object requires.The SmartConnect documentation discusses the setup of Translation Tables here.In SmartConnect, a neat feature is being able to Import the translated…

[Read More]

Tech Tuesday: Changing the Column Names on an Excel File Destination

In a previous column, I had discussed how we could change the column names of the text output file that SmartConnect had created. The main reason that we would want to do this is if the output file required specific column names and SmartConnect was changing them due to source column naming conventions that SmartConnect…

[Read More]

Tech Tuesday: Restricting a SmartList Builder Report to the Previous Month

My user was creating a SmartList Builder report yesterday and asked me a question that had me initially stumped. The goal was to run the report and restrict the data to the previous month – not the current month. Figure 1: Simple SLB SmartList For this, we will just report on the Purchase Order Work…

[Read More]
Tech Tuesday

Tech Tuesday: Displaying SQL Data with Restrictions Using Extender Enterprise

My customer had interesting request the other day.He had a SQL Query that he wanted to run, filter the query by a column or two, and he wanted to do this using Extender Enterprise.That took me off-guard a bit since to me the “correct” tool would be to use SmartList Builder to create the report…

[Read More]
Tech Tuesday

Tech Tuesday : SmartConnect – Changing the Column Names on a Text File Destination

One feature that has been asked for by customers is the ability to specify column names when using the Export to File feature. By default, as of the latest SmartConnect 20.16.0.31, when exporting to a file is that the source file column names will be used as the output column names. This issue is potentially…

[Read More]

Creating a fixed length output file in SmartConnect

A question that I’ve gotten several times in the last few months is:I see that SmartConnect supports output to CSV or TAB delimited formats – but can’t it output to a fixed length file? Well on the face of it – the answer is no. If it could do that out-of-the-box, it would be listed…

[Read More]
Tech Tuesday

Tech Tuesday: Setting a specific RECV distribution account for a Sales Invoice

The reason for the recent support request was a bit unusual but the intent behind the goal wasn’t all that uncommon – “I to want to add additional functionality beyond what eConnect provides”.For specific reasons, the customer would like to change the RECV distribution account that defaulted with their Sales Invoice integration.My first though was…

[Read More]
Tech Tuesday

Tech Tuesday: Restricting the Modification of Existing SmartLists by SmartList Builder

One of the great features of SmartList Builder is that not only can you create new SmartLists from scratch, it also gives you the ability to modify existing Dynamics GP out-of-the-box SmartLists.Actually, SmartList Builder does not actually modify the GP SmartList. It runs an eOne created SmartList that copies the functionality of the original GP…

[Read More]

RECENT POSTS


2022 eOne SmartConnect & Popdock Bootcamps
2022 Q1 Promotions
January 2022 Pricing Updates for SmartList Builder, SmartView & Popdock are Live!
2022 Advanced SmartConnect Bootcamp: REST Web Services Integration
2022 Dynamics GP Bootcamp Schedule

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

TAGS

Business Central CRM D365 Business Central 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 SmartPost SmartView SQL Tech Tuesday Templates training