Developing for Microsoft Dynamics GP

March 2009 - Posts

• 0 Comments 1,359 Views

  April Fool's Post Hi everyone. To avoid any further confusion I have removed both the April Fool's joke post and the follow up post from the blog. For those who want to see them, the two posts in PDF format are attached to the bottom of this post. David Read More... Published: Tuesday, March 31, 2009, 08:00 PM Tags: Fun

• 0 Comments 1,512 Views

  Exclusive: Sneak Peak at Dexterity version 11.0 I have been working really closely with the Product Management and Marketing team for Microsoft Dynamics GP and have finally received permission to show off one of the biggest changes we will be seeing for Microsoft Dynamics GP version 11.0. This is an... Read More... Published: Tuesday, March 31, 2009, 05:00 PM Tags: Dexterity, Fun

• 0 Comments 1,472 Views

  Life Inside the Fargo Flood My friend Mariano Gomez has been in touch with our mutual friend in Fargo, Tom Irsfeld. You will remember Tom's name as one of the pioneers from the Translating Dexterity Applications Series of posts on this blog. Tom has provided a real insight into... Read More... Published: Monday, March 30, 2009, 05:00 PM Tags: General, Blogsphere, News

• 0 Comments 1,557 Views

  Using the Dexterity Three Trigger Technique Part 2 In the previous part of this post we discussed the theory of the Three Trigger Technique and the details of a problem that was solved using this technique. This post will cover the actual solution used and has the scripts used so you can see the techniques... Read More... Published: Sunday, March 29, 2009, 05:00 PM Tags: Dexterity, Cross Dictionary, Advanced Topic, Triggers, Best Practice

• 0 Comments 1,396 Views

  Fargo is Flooding My previous post on the situation in Fargo, North Dakota was a little tongue in cheek. However, the flooding has already exceeded the maximum levels from the 1997 floods and is now forecast to reach 43 feet (13 metres) and the situation is very serious... Read More... Published: Friday, March 27, 2009, 01:30 AM Tags: General, News

• 0 Comments 1,457 Views

  Using the Dexterity Three Trigger Technique Part 1 When working with Dexterity triggers, the hardest part of the process is working out where to place the triggers. There are times where it seems impossible to get the trigger you need in the correct location. This post explains the concept of what I call... Read More... Published: Thursday, March 26, 2009, 05:00 PM Tags: Dexterity, Cross Dictionary, Advanced Topic, Triggers, Best Practice

• 0 Comments 1,544 Views

  How to read your own config file with a VSTools Application This article is a result of a couple of recent support incidents where developers would like to read a config from from a Visual Studio Tools (VSTools) addin. VSTools is a special situation because for one, it is a dll, not an exe, and second it only... Read More... Published: Wednesday, March 25, 2009, 05:00 PM Tags: Visual Studio Tools

• 0 Comments 1,436 Views

  Who would live in Fargo in Winter Don't take this the wrong way. I love the people of Fargo (all year round), but I only love Fargo itself .... during Summer. Andy from the Inside Microsoft Dynamics GP blog has informed us that the twin cities of Fargo/Moorhead are facing flooding... Read More... Published: Tuesday, March 24, 2009, 05:00 PM Tags: General, Blogsphere, News

• 0 Comments 1,428 Views

  Unexpected Hidden Talents - A new cake added If you have not already seen my previous post on my hidden talent, now is an opportunity have have a look. Last week it was the birthday of my younger son, Rohan, and my wife, Jennifer, and I made a birthday cake for him. As he has been learning music... Read More... Published: Monday, March 23, 2009, 05:00 PM Tags: Hobbies, Fun, General, Cakes

• 0 Comments 1,548 Views

  Internet Explorer 8 has been released If you have not heard already, Microsoft has just released the final build of Internet Explorer 8.0. Internet Explorer 8.0 has been tested and is supported with Microsoft Dynamics GP 10.0 and all web applications with Microsoft Dynamics GP 10.0. The System... Read More... Published: Sunday, March 22, 2009, 05:00 PM Tags: Application, General, Blogsphere, News, System Requirements

• 0 Comments 1,443 Views

  Drag and drop into folders in the 10.0 Navigation/shortcut window A question was posted to the newsgroups recently that reminded me that I had also run into the same situation previously. I was trying to drag a shortcut into a folder that I had also created and it wouldn't drag & drop for me in my Dynamics GP... Read More... Published: Thursday, March 19, 2009, 12:00 PM Tags: Application, Dexterity

• 0 Comments 1,458 Views

  Microsoft Team Blogs and Free Software and Services If you are looking for blog resources for other Microsoft products, you can't go past the list on the BlogMS site. The page below provides a list of all the official blogs for various teams within Microsoft (including this blog): Official Microsoft... Read More... Published: Wednesday, March 18, 2009, 05:00 PM Tags: Blogsphere

• 0 Comments 1,559 Views

  HR & Payroll Navigation Pane issue A while back, there were several posts in the public Dynamics GP newsgroup about that HR & Payroll Navigation button being 'messed up'. Finding that odd, I looked at mine on 10.0 SP1/SP2 - I don't recall which - and noticed the same thing... Read More... Published: Tuesday, March 17, 2009, 12:00 PM Tags: Application, Dexterity, Support Debugging Tool

• 0 Comments 1,539 Views

  Feedback and News from Convergence 2009 For those of you who were unable to attend Convergence 2009 in New Orleans, there are a number of posts on the blogsphere with feedback and news. Here is an overview for you: From the Inside Microsoft Dynamics GP Blog Just to re-confirm my belief that... Read More... Published: Monday, March 16, 2009, 05:00 PM Tags: Application, Blogsphere, News, Conference

• 0 Comments 1,807 Views

  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... Read More... Published: Sunday, March 15, 2009, 01:00 PM Tags: Dexterity, Dex.ini

• 0 Comments 1,637 Views

  Great Plains Historical Timeline A little while ago I was sent a document which has the release dates for every release of Great Plains/Microsoft Dynamics GP from version 1.0 to the current version 10.0. I thought it would be a fun exercise to post a summary of this timeline so you can... Read More... Published: Thursday, March 12, 2009, 05:00 PM Tags: Fun, General, History

• 0 Comments 1,558 Views

  WorldMaps Geographical Hit Counter A while ago I added a WorldMaps gadget to the blog to track where the visitors to the blog were coming from. This beta version of the tool was created by Brian Hitney (Microsoft Developer Evangelist) and was published on his http://www.structuretoobig... Read More... Published: Wednesday, March 11, 2009, 05:00 PM Tags: General, Blogsphere

• 0 Comments 1,660 Views

  Creating SQL Views of DUOS Data Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields. The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in... Read More... Published: Tuesday, March 10, 2009, 05:00 PM Tags: SQL, DUOS, VBA, Modifier, SmartList Builder, SQL Reporting Services, Crystal Reports

• 0 Comments 1,546 Views

  Reading Materials for Microsoft Dynamics GP Tom Brookes on the Microsoft Dynamics GP UK Blog has written a post about some of the books and reading materials available for Microsoft Dynamics GP. If you are looking for materials beyond the standard manuals and training guides have a look at his... Read More... Published: Monday, March 09, 2009, 05:00 PM Tags: Application, Blogsphere

• 0 Comments 1,812 Views

  Developing Outside of the Box Recently I responded to a question on a newsgroup asking how to minimise a window from VBA (Visual Basic for Applications). The short answer is that it is not possible. But just because a Microsoft Dynamics GP window VBA object does not expose any methods... Read More... Published: Sunday, March 08, 2009, 05:00 PM Tags: Dexterity, Hybrid, VBA, Blogsphere

• 0 Comments 1,541 Views

  Working with Unrestricted Database Triggers I recently responded on a Newsgroup posting where the developer was wanting to identify a table delete event from a particular form. However, the delete event was happening in a global script and did not use a form level table buffer on any form. This... Read More... Published: Thursday, March 05, 2009, 05:00 PM Tags: Dexterity, Triggers, Best Practice

• 0 Comments 1,494 Views

  The Official Microsoft Dynamics GP Blog is here Congratulations to the Microsoft Dynamics GP Product Management and Marketing team on the creation of the Official Blog for Microsoft Dynamics GP. For the inside scoop on events, promotions, features and releases as well as a mechanism to have a two way... Read More... Published: Wednesday, March 04, 2009, 06:00 PM Tags: General, Blogsphere

• 0 Comments 1,725 Views

  Searching on SQL Server using the LIKE command My friend Victoria Yudin has posted a great introductory article on her blog about how to use the LIKE command in where clauses when creating queries on SQL Server. Even if you know your Transact-SQL, it is always good to get a refresher. Have a look... Read More... Published: Wednesday, March 04, 2009, 05:00 PM Tags: SQL, Blogsphere

• 0 Comments 1,542 Views

  How to write Dexterity source which behaves differently for different versions As a developer there are often times when I need to write and maintain code which works for multiple versions of Microsoft Dynamics GP. A great example of this is the Support Debugging Tool for Microsoft Dynamics GP . This tool has been written for versions... Read More... Published: Tuesday, March 03, 2009, 05:00 PM Tags: Dexterity, Best Practice

• 0 Comments 1,560 Views

  Free Visual Basic for Applications Workshop Mariano Gomez aka The Dynamics GP Blogster is running an online (blog based) workshop to show how to use Modifier and VBA (Visual Basic for Applications). Have a look at the introductory post using the link below. It will explain the prerequisites and... Read More... Published: Monday, March 02, 2009, 05:00 PM Tags: VBA, Modifier, Blogsphere