Skip to content
+1-888-319-3663

Tech Tuesday: SmartConnect Purchase Order Map Error

If you are running a purchase order map and receiving an error that says “370 /* Subtotal (SUBTOTAL) does not match the line item totals” we have an easy fix for you. The Microsoft eConnect SDK has this field marked as required, as it used to be required in older versions of eConnect. The SmartConnect…

[Read More]

Tech Thursday: Working with Flexicoder Modules

This week’s article is all about modules Fleixcoder works with. I get quite a few questions about the capabilities of Flexicoder and what modules it works with, and exactly what some of the recording options are for Flexicoder Modules. This article will try and explain all the modules and options that Flexicoder offers.Flexicoder is designed…

[Read More]

Importing Federal Filing Status with SmartConnect into Dynamics GP

In the latest payroll tax updates available from Microsoft, there are 5 new federal filing statuses that were added for the new 2020 federal tax laws.  Originally there were 4 statues which were:ExemptSingleMarriedNon-Resident AlienThe 5 new filing statuses that were added for the 2020 tax year are:Head of HouseholdHead of Household Higher WHMarried Higher WHNon-Resident Alien…

[Read More]
Tech Tuesday

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

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

Tech Tuesday: Why Extender Security is Company Specific

I talk to many people who have issues setting up security for Extender windows. The main thing that people must remember when setting up security for Extender is that Extender security is always company specific. Therefore, you need to setup a security task per company and not globally. Standard GP security is global, the same…

[Read More]
Tech Tuesday

Tech Tuesday: How to manually activate and deactivate SalesForce Apex Triggers

Real time SalesForce data sources make use of what are called Apex Triggers. When you register the map, it creates an Apex Trigger, when you unregister the map, it removes the Apex Trigger. However, on occasion, you might want to activate and deactivate these triggers manually instead of going into SmartConnect and registering and unregistering…

[Read More]

Tech Thursday: Resetting the web client password in SmartConnect

One question I’ve seen come in a few times recently is “how do I reset the web client password in SmartConnect?” It’s easy. Simply follow my steps below and you’ll be well on your way.  Open SmartConnect, hit the “Setup” tab, and then click on the “Security” button. Highlight the user you want to change the password…

[Read More]
Tech Tuesday

Tech Tuesday: Automatically set the 1099 amount on a payables transaction

I often run into people importing payables transactions using SmartConnect where some of the vendors are 1099 vendors and some are not.  When you import a transaction for the 1099 vendor, the 1099 amount needs to be the same as the transaction amount.  However, people don’t typically know which vendors are 1099 vendors before they…

[Read More]
Tech Tuesday

Tech Tuesday : Using Binary Stream eConnect procedures with SmartConnect

I quite often talk to customers using Multi-Entity Management from Binary Stream.  They have written some eConnect procedures that you can utilize from within SmartConnect.  Typically there are 2 steps to getting these nodes installed. You first need to get the installer from Binary Stream.  They have an installer that creates their eConnect procedures in all…

[Read More]

RECENT POSTS


Join eOne Solutions for the Q3 Partner All Hands Call!
SmartList Trek: SmartList Builder, Popdock & Your Future - New Popdock Trainings, August 2022
See eOne's Winning Virtual Integration for Salesforce
2022 Q3 Promotions
New Features & Updates in SmartConnect 21 - Recording Now Available!

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 Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training