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

Using Named Printers with Terminal Server revisited

This is an update to the original Using Named Printers with Terminal Server post from August 2008. The original post takes you through the process of using Template Users on Terminal Server so that you only need to setup one user per physical location with user mode printers and then users from that physical location can inherit…


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

Purchase Order Returns Modification

This post is a public service announcement for those customers and partners using the free customization from Microsoft, Purchase Order Returns Modification (Product ID: 4159) for Microsoft Dynamics GP versions 9.0 and 10.0. Note: The functionality of this customization has been incorporated into the core Dynamics.dic dictionary for Microsoft Dynamics GP 2010 and so is no…

2

Workstation Level Settings Lost during Upgrade

When upgrading Microsoft Dynamics GP, it is quite common to get one client (often on the SQL Server) updated first and then update the system and company databases using Dynamics GP Utilities. The final step is then to go around the various workstations and upgrade the client application on those machines. The process of upgrading often…

5

Where has my Microsoft Dynamics GP window gone?

The technique I will discuss in this post is not specific for Microsoft Dynamics GP, but as this is a Microsoft Dynamics GP related blog, I will put a GP “spin” on it. Since the user interface change from MDI (Multiple Document Interface) to SDI (Single Document Interface) for version 10.0 of GP (see Version 10.0…

11

Great Posts from Leslie Vail - Tables, Security & Dex.ini settings

My great friend Leslie Vail has some fantastic posts on her Dynamics Confessor Blogspot blog.  If you wanted to know more about the way the tables are named in SQL Server, Leslie discusses the naming conventions on how the names are created.  Have a read of Leslie’s Dynamics GP Table Names post for more information.  Note,…

1

Why making the Dex.ini file read only is evil

Time and time again I have heard consultants say that the solution to stopping Microsoft Dynamics GP remembering the last user on a Terminal Server or Citrix installation is to make the Dex.ini file read-only.  There was even a Knowledge Base (KB) article that suggested clearing the SQLLastUser setting from the Dex.ini file and then…


Users (other than 'sa') unable to login after upgrade

A couple of nights ago, my friend Sivakumar Venkataraman (Siva) pinged me on Messenger about an issue he was having.  He was in the process of upgrading a customer’s site from Microsoft Business Solutions – Great Plains 8.0 to Microsoft Dynamics GP 10.0, and after the upgrade none of the users were able to log into…

3

Dynamics GP Lists: Exports slowly to Excel

Breaking with my recent series on Smartlist and specifically the Smartlist: Exports slowly to Excel – Part 1 post, a comment and followup question to that post was: This is great!  But is there a similar switch for the Dynamics GP lists such as the “All Sales Transactions” or “Accounts” list? Good question and honestly…

4

Smartlist: Exports slowly to Excel - Part 2

This is the 4th post in a series of Smartlist posts in the last weeks.  In these articles, I’ve given answers and solutions to common questions about Smartlist that are typically of the “Why doesn’t Smartlist..?” variety. Last week, the question we were looking at was: Why does Smartlist export to Excel so slowly? The answer…

4

Smartlist: Exports slowly to Excel - Part 1

In the last few weeks (here and here), I’ve enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups.  These questions are typically of the “Why doesn’t Smartlist..?” variety. In this post and a few planned future posts, I’ll look at each of these questions individually and give a…

32

Support Debugging Tool version error on GP 2010 RTM

With the availability of the Released To Manufacturing (RTM) build of Microsoft Dynamics GP 2010, an issue has been discovered with the version check code in the Support Debugging Tool build 12. The error is caused by the method used in build 12 (and earlier) to check the version of the Dexterity runtime engine. The GP…

1

Testing Date Driven Features in GP

Have you ever had a piece of functionality that is date driven that you wanted to automate a test for but couldn’t figure out the best way to control the dates in the system?  Then this post will be very helpful for you!  A common area I receive questions on when talking with partners and…

1

Dexterity Chunk file wouldn't merge

This blog post is about a Dexterity support incident that I recently had that ended up to be more difficult than I originally thought.  This one should have been easy, when a chunk doesn’t merge, it’s usually always easy.  Except this case.  The background is the following.  A Dexterity incident came in and the issue…

8

Copying Record Notes and OLE Attachments between Companies

Following on from last week’s post on OLE Attachments and Record Notes, I can now get to the reason for the interest in notes and OLE attachments. The partner was trying to copy master records for Vendors from one company to a new company.  They wanted to use SmartList to export the Vendor data out…

3

OLE Attachments and Record Notes

While working on a recent support case, I was asked again about how Notes work and in particular the OLE attachments.  In the previous post, Understanding Notes and the Note Index field, we discussed where the next Note Index value comes from. In this post, we will discuss how the record notes are created and…

4

Installing the Support Debugging Tool for Microsoft Dynamics GP FAQ

I have been asked a few times recently about installing the Support Debugging Tool for Microsoft Dynamics GP on a live system.  This post covers some of the Frequently Asked Questions about installing the tool.  Q: What is the Support Debugging Tool?  A: The Support Debugging Tool is a Dexterity built application which contains a collection of…

6

Any Font in the Dexterity Script Editor

Aren’t secrets fun?  And while having a secret is fun in and of itself, it is also fun to share them from time to time (and allowed to share them). The secret today is an undocumented feature that I believe was added to 10.0 SP2.  As an undocumented feature, this means: It might not work…

2

Dexterity: Creating custom ini files

One question that I’ve been asked a few times in the past has been – “Can I read/write to other sections of the Dex.ini other than the [General] section with Dexterity?”. Here I presume the questioner would like to have their own section of the dex.ini file to write their own application settings instead of…

0