Posts by Patrick Roth
Tech Tuesday: New 1099 Type Nonemployee Compensation in Dynamics GP
Every once in a while you get a curveball that takes you by surprise.This year, that curveball came in the form of the Dynamics GP 2016 and GP 18.3 YE releases in which GP added in a new 1099 Type – Nonemployee Compensation.Since this release, several eOne customers have seen “issues” in reference to this…
[Read More]
Tech Tuesday: Using CDATA tag in SmartConnect to avoid leading spaces from being removed
A common error that we see when doing any kind of GP documents that have an account number is:The Account Number (ACTNUMST) does not exist in the Account Index Master Table. When eConnect does account validation, it takes the Account Number that you give it and query the GL00105 table – GL00105.ACTNUMSTR – to find the…
[Read More]
Tech Tuesday: Adding Company ID to SmartList Builder Multicompany Summary Report
I recently ran into a scenario that I’ve seen a few times before that I thought I’d document in today’s blog article.We’ll document the problem we’re trying to solve, the troubleshooting steps, the underlying issue, and then the solution.The scenario is this:Customer has created a summary report in SmartList Builder that does <something> and they…
[Read More]
Tech Tuesday: Integrating Record Notes in Dynamics GP with SmartConnect
Notes! Who doesn’t love record level notes in Dynamics GP? What’s not to love about having a freeform text field to enter 32k of information into?Long time GP users know that the (almost) universal field for a note is the NOTEINDX field in the table for that GP record. For a RM Sales Transaction, the…
[Read More]
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: 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]
Tech Tuesday: Could not retrieve the next number in the sequence
I ran across something interesting the other day that I can’t say that I’ve heard of happening in about 15 years of experience. While I don’t know that we’ll see this again for another 15 years, the troubleshooting process was interesting, and I thought would be worthwhile to look at. To set the stage: The…
[Read More]
Tech Thursday: SmartConnect and Windows Platform FIPS Encryption Policy
We haven’t seen it a lot, but more often lately and interesting enough a problem that I thought I’d write a blog article on this issue. In this blog article, we’ll define what the Windows Platform FIPS Encryption Policy is and then how we can make SmartConnect work with this policy enabled. So, the easy…
[Read More]
Tech Thursday: Source File Name from Excel Folder Data Source
In my last blog post, we discussed the problem of a folder data source and not knowing the source file name was that each row of data in the map came from.In that post, the source file type was a text file, so it wasn’t terribly difficult to use .NET to read the folder file…
[Read More]
Tech Tuesday: Source File Name from Folder Data Source
A very common question that the Support Team will get is:“I’m using a SmartConnect map using a folder data source with csv files. Is there any way to get the filename that each document came from?”The answer is, surprisingly, no.Unfortunately, there isn’t a built-in variable that SmartConnect uses that has this information that we could just…
[Read More]