Posts by David Youngquist
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: 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: 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: 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: 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: 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 : 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]