Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 ...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Smartlist: Exports slowly to Excel - Part 2

    This is the 4 th 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 customers is...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 for you...
  • Blog Post: 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...
  • Blog Post: All about the Dexterity OLE Container

    Over the years, the question of how to interact with the Microsoft Dynamics GP OLE Notes from outside the application has been raised many times. I have responded to newsgroup posts with information that would hopefully lead the developers in the right direction. Well now, all I need to do point...
  • Blog Post: Are you using the Support Debugging Tool?

    You might say that I am biased. As the developer of the Support Debugging Tool for Microsoft Dynamics GP , I believe that every Microsoft Dynamics GP site (v8.0, v9.0 & v10.0) should have the tool installed. Even if you don't need it straight away, it is always there when you do. For example:...
  • Blog Post: Where is the DEX.INI file for version 10.0?

    Since the release of Microsoft Dynamics GP v10.0 I have seen this question asked many times over on the various newsgroups I monitor (see the Newsgroups Links on the left hand panel of the blog). The quick answer is.... it has moved into the Data subfolder. David -- End of Post -- OK, I am...
  • Blog Post: Finding Table and Field Information in Microsoft Dynamics GP

    This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community website. The links to the original article, as well as the associated Knowledge Base (KB) article are provided at the bottom of this post. The idea was to provide as many tools and techniques as possible...
  • Blog Post: Why does Microsoft Dynamics GP encrypt passwords?

    Why doesn't the password I use for Microsoft Dynamics GP work for me to access the data in SQL from <insert application name here>? Why does my password sometimes fail to work from one workstation when it works from another? Why does the password policy feature only allow one failed attempt...
Page 1 of 2 (27 items) 12