Patrick Roth: Heading in a new direction

Wow – time flies and as they say, it seems to go faster the older you get. It seems only a few years ago that I was a graduating senior at NDSU. It was late in the last week of finals and I was working with my team to finish my senior project for one of…

10

Import and Export for Office in GP 2013

A customer ran across an interesting issue with Excel Based Budgeting after they upgraded to GP 2013. They had been using Excel Based Budgeting in GP 2010 successfully – mostly to import/update existing budgets based on their existing spreadsheets.  What was successful in GP 2010, wasn’t working in GP 2013 – specifically cells that were based…

4

Display Specific Line in Sales Order Processing

This will be a 2-for-1 post today as the example given solves a frequently asked question and was used to solve a customer issue. The question I’ve seen a number of times before and been meaning to write about is: “How can I fill the Sales Order Processing scrolling window to a specific line?”.  With Dexterity…

1

Dynamics GP Crashes After Installing Addin

One thing we’ve noticed recently is an uptick of cases involving Visual Studio Tools assemblies causing Dynamics GP to crash after being installed. While I don’t think this has anything to do with GP 2013, it does seem to happen on that version.  Perhaps everyone is just going to the new version and thus coincidental….

10

eConnect transaction not rolling back

I ran across an interesting case the other day with eConnect.  I had a similar type of case I wrote about previously, but this one is for a completely different reason. The ISV was moving his working customization from GP 10.0 to GP 2010/2013. The Problem Essentially the customization would use eConnect to create a…

3

All About Listbox, Button Drop Lists, and Drop Down Lists

It seems like a trivial subject for our dedicated readers but we had a new customer who is just learning Dexterity and he was having trouble recently trying to select items out of a ListBox.  And just today the issue came up about Drop Down Lists (DDL) and getting the value selected using VBA in…

1

Running Dynamics GP 2010, AX 2012, and SL 2011 on the same machine

I ran across an issue a while back that a developer was running into after installing Dynamics SL 2011 on a machine with Dynamics GP 2010 (and Dynamics GP 10).  Then in the next few days we had two more cases of the same issue (and again here, here, and here).  But I’m getting ahead…

10

Workflow does not show up on Dexterity Alternate Window

We had a case where the workflow functionality for the Purchase Order Processing PO Entry window would show when the original window was used, but would not appear when the developer’s Dexterity alternate version of the window was used. The Dynamics.exe.config is what can control the .NET wrapper that goes around each GP window.  This…

1

Window Scrollbar Is Too Wide and Obscures Data

A customer recently ran across an oddity on several (but not all) of their new Windows 7 machines.  The previous Windows XP machines being replaced were OK. The issue was that on windows with scrolling windows, they noticed that the rightmost fields were partially obscured by the scrolling window scrollbar. The screenshot below shows the issue in…

4

Quick Tip: Dexterity SQL error invalid cursor state

In a recent case of mine, the ISV was running into a common issue that I’ve run into before more than a few times.  Actually something I’ve done a few times myself. The ISV was attempting to use pass through sanScript to populate a SQL temp table. What he found was that the first SQL_Execute() statement was OK…

2

Drilling back to Project Accounting Inventory Transfer Inquiry Zoom

A few days ago, a user posted a question on the Dynamics GP forums. What he ran across was when drilling back to the source document from the (GL) Transaction Entry Zoom window for a Project Accounting Inventory Transfer document, the document didn’t display correctly.  If the journal entry is in the Open status or…

2

eConnect error – The stored procedure doesn’t exist

I ran across an odd eConnect issue a while back that I thought I’d share today. In this case, the customer had recently updated to GP 2010 and updated their application to eConnect 2010 from the previous version that worked fine. But now under GP 2010, when trying to run their eConnect integration it would…

3

Failed eConnect document leaves orphaned records

I assisted on an eConnect incident today that was quite interesting and I thought I’d share the case and the solution. The issue: The ISV was integrating a Payables Invoice using eConnect 10.0. The XML document had 2 distributions and the invoice data. What the ISV found was that there was an issue in the…

3

Dynamics GP Diagnostics

What are Diagnostics and why do we need them? Diagnostics are a CTS (Commercial Technical Support in Microsoft) initiative that has been around a few years. If you’ve logged a support incident for other Microsoft technologies such as Windows, Exchange, SQL and others – chances are you were asked to run some sort of “Diagnostic”…

4

2011 Year-End What and When is Microsoft Dynamics GP Releasing?

Wow – it really has been a long time since I’ve posted to the blog.  I’ve just been somewhat busy and time sure does fly. Looks like I need to get back into the swing of things again but I have a number of ideas on topics that you’ll be seeing in the near future…

1

Making Word Template Documents Read Only When Sent To Customers

I was recently talking with one of our fine Distribution Support engineers discussing Word Template issues. One topic that came up was their team has apparently been asked quite a number of times by customers: If we send out our invoices as Word documents, our customers can edit them to be for less money and then…

8

Dynamics GP VSTools Addins Not Loading

Last September I picked up a Visual Studio Tools 9.0 case that was pretty interesting that I will share today. The ISV had a custom addin they had developed and worked fine on their test servers (doesn’t it always?).  Now when deploying the addin at the customer site; they found that their Extras menu item…

5

Edits To Dynamics Launch File Won’t Save

My blog post today isn’t anything earth shattering but something a partner ran into that was unexpected.  Logical – but unexpected nonetheless. A recent forum post detailed how the user was trying to set forms & reports dictionary paths using the Edit Launch File window.  What they found was that after editing the launch file…

3

Quick Tip: Account Number Not Fully Displayed In Custom Window

Depending on your customization, you might need to use Account Number fields. The field works OK but you notice that the account segments don’t seem to fit correctly and are cut off. This could be an issue with the Account Format Setup in Dynamics GP to allow for “wide” account segment values such as “W”…

3

Dynamics GP Slow Login on Terminal Server

This summer I was contacted by one of my associates in our LATAM office.  He noted that their office was running into more and more cases as described below. Dynamics GP freezes during 2-3 minutes just after the login window appears (you cannot even enter the password). This only happens when the Terminal server does…

11