This is the portal page for the Support Debugging Tool for Microsoft Dynamics GP. 

Overv…

Many organizations need to prepare financial statements that report on multiple companies in a consolidated format. Management Reporter can help a company consolidate their data across one Microsoft Dynamics ERP, multiple Microsoft Dynamics ERPs, or across ERPs. Consolidations can also occur at different levels, based on a company’s needs. This series of blogs will help you determine which consolidation options in Management Reporter are right for your business and provide you with information on how to create consolidated financial statements on consolidating data in Management Reporter.

• Part 1 contains an overview of consolidating data across one or multiple Dynamics ERPs with the same chart of accounts and same fiscal periods.
• Part 2 describes consolidating across one or multiple Dynamics ERPs with different chart of accounts.
• Part 3 defines the process for consolidation across one or multiple Dynamics ERPs with different fiscal periods.
• Part 4 is focused on reporting with multiple Dynamics AX 2009 instances (AOS) and/or if currency translation and eliminations are required.
• Part 5 will show you…

It’s common that different companies may have different charts of accounts but still wish to produce consolidated financial statements.  In this situation, Management Reporter can still consolidate the data, allowing you to produce consolidated financial reports.  This blog (2^nd in a series of 7), will highlight how to create consolidated reports with varying chart of accounts.

• Part 1 contains an overview of consolidating data across one or multiple Dynamics ERPs with the same chart of accounts and same fiscal periods.
• Part 2 describes consolidating across one or multiple Dynamics ERPs with different chart of accounts
• Part 3 defines the process for consolidation across one or multiple Dynamics ERPs with different fiscal periods
• Part 4 is focused on reporting with multiple Dynamics AX 2009 instances (AOS) and/or if currency…

Sometimes, different companies will be using different fiscal calendars, but you may still want to create consolidated financial statements for these companies. This blog (3rd in a series of 7), will show you how to create consolidated reports with varying fiscal calendars. .

• Part 1 contains an overview of consolidating data across one or multiple Dynamics ERPs with the same chart of accounts and same fiscal periods.
• Part 2 describes consolidating across one or multiple Dynamics ERPs with different chart of accounts
• Part 3 defines the process for consolidation across one or multiple Dynamics ERPs with different fiscal periods.
• Part 4 is focused on reporting with multiple Dynamics AX 2009 instances (AOS) and/or if currency translation and…

Wondering what the hot topics are for the month of July? Worried you have to sift through volumes of…

This page contains links to blogs relating to Microsoft Dynamics GP:

NOTE: To search…

The Dynamics GP User Group (GPUG) is an association of companies sharing the common…

After a number of questions about translation recently, I have decided to focus on Dexterity's multi-lingual and translation capabilities for the next couple of weeks.

The posts in the series include:

• 11-Feb: Dexterity: Designed for Translation
   
• 13-Feb: Writing Translatable Dexterity…

A week into the New Year and no posts.... what's happening? Read on to understand where all my spare time has been going....

After over four months of development, testing and documentation, I am thrilled to announce that build 16 of the Support Debugging Tool is now available for download from PartnerSource. This build has over 50 changes and focuses on functionality for logging and debugging issues with Microsoft Dynamics GP, while still having some improvements for the database or application Administrator.

A quick hint about how much is included in this build is that the User Guide PDF has grown from 161 pages to 193 pages.

Highlights include:

• Macro Recording Logging
• SQL Profile Tracing Logging
• Improved Trigger functionality including a Trigger Administration window
• SQL Role Views from the Security Information window

Below is a summary of the changes made for releases 10.00.0016 and 11.00.0016, I have divided them into logical sections:

Fixes

• Fixed Security Information Show Resources not displaying when a Security Role not assigned to any users was selected.
• Fixed Logs, screenshots and table/record dumps being overwritten when new logs started in the same second by adding suffix to filename.
• Update Trigger handling to allow Restore Value option to work for Text Field datatypes.
• Fixed Security Privilege errors for non Dictionary Resource Security Objects not being logged when Security Profiler is running in the background.
• Fixed Manual stopping of non-logging triggers using MBS_Trigger_Stop helper function not working.
• Fixed Field Physical Name search in Resource Information window to handle Composite and Array fields correctly.
• Fixed Tables Containing Field Lookup in Resource Explorer to handle Composite and Array fields.
• Fixed Screenshot not being able to save image files to a UNC pathname. Files now saved to temp and moved to UNC Path.
• Added check to see if email system is in use when emailing Screenshots as part of processing a trigger.

Enhancements

• Updated Support Debugging Tool main window to move Logging Options to a sub window and just show current status.

• Added optional display of form details when Security Privileges error is displayed to Administrator Settings.

• Added Table restricted to Table Trigger Type to Automatic Debugger Mode to provide form restricted database triggers.
• Added Focus Event with Table Trigger Type to…

This page contains links to developer related articles and sites (not specific to a…

This page has GP  9, GP 10, GP 2010 product downloads and links to service packs, in…

Those of you who attended Microsoft Convergence 2011 Atlanta will know about the promised Build 15 of the Support Debugging Tool for Microsoft Dynamics GP. Well it is finally here with over 80 changes to the code. It includes lots of new functionality as well as many fixes and improvements. This build can be installed over the top of any existing installed build without needing to remove the old build first.

Below is a summary of the changes made for releases 10.00.0015 and 11.00.0015, I have divided them into logical sections:

Fixes

• Fixed Dictionary Control to not enable triggers for all products unless Dictionary Control is actually in use.
• Fixed Call Stacks in Use Error when using Reject Script option on the Automatic Debugger Mode Setup window.
• Fixed Tab Sequence and focus changes for Automatic Debugger Mode Setup window.
• Fixed error when Non-Logging Mode Triggers captured Table dumps and record dumps to xml files.
• Fixed Script Find and Replace to mark window as changed when text is replaced.
• Fixed Automatic Debugger Mode Setup window to change to Script tab when using Script menu commands.
• Fixed ScreenShot temporary files not being removed when emailing without using preview Send Email window.
• Fixed System Status to show number of products and correct product name for GP 2010 onwards.
• Fixed Series not showing correctly in Resource Explorer for resources with a series greater than System.
• Fixed Resource Explorer displaying folders for resources currently hidden from display.
• Fixed Drill back to Resource Information window from Security Profiler Window for non-resource Security Objects.
• Fixed Dictionary not changing when selecting Table from the Tables containing Field Lookup.
• Fixed handling of Maximized windows when remembering window state.
• Fixed issue with more than one User ID and/or Company ID prefix being added to Window Titles.
• Fixed Conversion of inline comments (--) on last line with no final carriage return on SQL Execute window.
• Fixed handling of Excel Report Builder Security Objects, which were added for v10.0 Service Pack 2 or later.
• Fixed handling of Extender Security Objects, which were added for v10.0 Service Pack 4 or later
• Fixed issue with Extender Enterprise by adding check for Microsoft Extender vs Extender Enterprise as internal resources are different.

Enhancements

• Added Logging Defaults to the Administrator Settings window.
• Added functionality to allow selection of which logging options are used with Manual Logging Mode. 
   
  
   
• Updated Automatic Debugger Mode Setup window to use tabs to allow additional actions and options.
• Added Menu Explorer lookup to the Automatic Debugger Mode Setup window.
• Changed Automatic Debugger Mode to allow Keep Focus and Restore Value options to work without Reject Script.
• Added Logging…

The Dynamics GP Team will be creating blog posts this year related to Year-End closing processes for Dynamics GP.  Below is the schedule of upcoming blog posts.

November 15, 2011 – Year-end Closing 2011 for Microsoft Dynamics GP: Install & Upgrade
November 17, 2011 – Year-end Closing 2011 for Microsoft Dynamics GP: US Payroll

November 22, 2011 – Year-end Closing 2011 for Microsoft Dynamics GP: Inventory
November 24, 2011 – Year-end Closing 2011 for Microsoft Dynamics GP: Receivables Management

November 29, 2011 – Year-end Closing 2011 for Microsoft Dynamics GP: Payables Management
December 01,…

During my time in the partner channel, I worked with a number of consultants who had a number of problems customising reports with Report Writer.

One of the problems was an inability to access desired data because a valid table relationship could not be established. This could be due to the source table not containing all the key fields needed, the target table's key using constant values not stored in the data, or data type mismatches for the key fields. 

Another issue with creating a table relationship that can occur is that a different table relationship between the two tables already exists. For example, from the Customer Master (RM_Customer_MSTR) table to the Customer Master Address (RM_Customer_MSTR_ADDR) table, there are 4 possible valid one to one relationships, using the Primary, Ship To, Bill To or Statement Address IDs as well as the one to many relationship.  Only one relationship can exist in the system between two tables and in this case it is the one to many relationship.

NOTE: If you are registered for Visual Basic for Applications (VBA) you can access any data as long as you can create a SQL query to retrieve it based…

It has been a while since we had a new build of the Support Debugging Tool for Microsoft Dynamics GP. So we have decided to release Build 14.  This is primarily a maintenance release with bug fixes, minor enhancements and a couple of new features.  This build can be installed over the top of any existing installed build without needing to remove the old build first.

Please note that this is the final release for version 9.00.

Below is a summary of the changes made for releases 9.00.0014, 10.00.0014 and 11.00.0014, I have divided them into logical sections:

Fixes

• Changes to Reject Script functionality in Advanced Debugging Mode to restore fields to their previous values.
• Changes to Reject Script and Reject Record functionality so it can be controlled by using the OUT_Condition variable.
• Fixed Non-logging triggers disabling Manual Logging Mode and Automatic Debugger Mode.
• Fixed Security Information Show Resources Window showing…

Today was the first "Official" day of the Convergence conference. After meeting Leslie and Sheila for breakfast, we went to the Open Keynote: Winning with Microsoft Dynamics. The session is now available from Virtual Convergence, please use this link: Winning with Microsoft Dynamics.

The session started with Microsoft Corporate VP and leader of the Microsoft Dynamics group, Kirill Tatarinov, giving us some of the statistics about the conference. This year there are 9,300 attendees from 36 countries, which makes this year's conference the 2^nd largest Convergence conference ever.

Kirill discussed the commitment that Microsoft has to the ERP space and how each of the product groups are delivering on that commitment.  Each of the products has new versions coming up in the near future. This includes the Microsoft Dynamics GP 2010 R2 release.

Kirill then introduced Microsoft CEO, Steve Ballmer, to the audience who responded with clapping and cheering.

Steve reminded us that the 10 year anniversary of Microsoft's acquisition of Great Plains had just passed. Ten years ago, Microsoft acquired 30,000 Great Plains customers and today Microsoft has over 350,000 Microsoft Dynamics customers with over 5 million individual users. Proof that the decision made 10 years ago to enter the ERP space was the right one.

We had some real great demonstrations of some of the upcoming functionality of the latest Dynamics AX and Dynamics CRM products, but two of the demos really stood out to me.

The first was Lachlan Cash demonstrating changing manufacturing schedules using an Xbox Kinect controller and just his hand motion to move a planned production from one day to the next. This shows how the Kinect controller can be used in more…

It seems that regardless of how much testing you do, something can still slip through the cracks. Well after v10.00 Service Pack 4 was released, an issue with the SmartList Builder/Excel Report Builder code was identified. A Hot Topic has been posted with a temporary workaround fix.

Here is an excerpt from the Hot Topic:

After installing Service Pack 4 for Microsoft Dynamics GP 10.0, you will receive the error Wrong…

For the next couple of weeks, I have decided to focus on Microsoft Dynamics GP application level security and methods for resolving security related issues.

Where possible I will also show how using the Support Debugging Tool for Microsoft Dynamics GP can make the process simpler and quicker.

The…

Back in 1998, when I was working with Sequel Technology (the Western Australian partner for Great Plains), we were implementing Great Plains Dynamics 4.0 for a couple of sites and were using add-on products for Service Management and Job Costing.

My business partner at the time (who did the sales) understood that Dexterity applications could be easily customised and so promised some changes to the customer.  What he (and I) did not understand at the time were the limitations Dexterity has for working across dictionaries. 

We did have some "with name" commands which could open forms, call procedures and run reports. We also had the execute() function which could be used to run Dexterity sanScript in the context of the 3rd party dictionary.  What we did not have was cross dictionary triggers.

Based on putting a number of ideas together I came up with a method of…

If you attended the Microsoft Dynamics GP Technical Conference 2009 in Fargo, North Dakota or Microsoft Dynamics Convergence Atlanta 2010, in Atlanta, Georgia you might have seen a demonstration by Mariano and myself of the Support Debugging Tool for Microsoft Dynamics GP.

One part of the demo was how to solve security privileges errors using the tool.  It is a perfect example of how the tool can make administration for a Microsoft Dynamics GP system so much simpler and this is why many partners are now installing the tool on all workstations of all their customer sites. 

This post is an update to the How to resolve Security privileges errors post which is part of the Microsoft Dynamics GP Application Level Security Series of posts, and is designed to highlight some of the features added since the original post was written.

The following is a real life scenario showing how the Support Debugging Tool for Microsoft Dynamics GP with the Security Profiler and Security Information features can quickly resolve Security Privileges errors on a live system.

In our scenario, the user is receiving a security error, but the window they were trying to open still opens, however, the window that opened does not include some fields added as a customisation.  We are assuming that the Support Debugging Tool is already deployed to all workstations on the system.

On the End User's Workstation 

When the user receives a Security…

Sunday started with a late breakfast at the hotel.  However, it was straight to work afterwards.  We commandeered a table in the Bar area and Mariano and I started working on fine tuning our presentations and demonstrations for the Technical Conference sessions.

What should have been a quick run through of the demo ended up as an entire day of frustration after I had some issues. We are currently experiencing Technical Difficulties and will return to our regular programming as soon as possible. 

Those Technical Difficulties ending up wasting about 5-6 hours of the day and had me grumpy and ready to do violence to my machine. Now as this is meant to be a technical blog I suppose I better explain what happened and why it was so hard to resolve.  You can read Mariano's version or Leslie's version, or read the truth what really happened below:

Here is the story....

Once upon a time, there was a man who was trying to create a demonstration of a Dexterity customisation, let's call this man, David.

Well, David noticed that a script he was attempting to compile failed because the DYNAMICS constant (value 0) was missing from the development dictionary he was working on.  Further investigation showed that there were only 5118 constants in the dictionary when a source code version of the same dictionary (GP 2010 SP1) had 7284. While it was possible to add the constants back by extracting them from the source code dictionary and importing them, this would probably cause issues as the resource IDs might change and there was no telling what other corruption there might be to the dictionary.

So, the first and simplest solution would be to re-install the Microsoft Dynamics GP 2010 client and get new DYNAMICS.DIC to use as a development dictionary. Simple, just un-install the current install and install again.  Except that any action to Remove, Repair or Add/Change the current installation resulted in the following error message:

"Object reference not set to an instance of an object"

So David thought ... my current GP installation works fine (except for the dictionary seeming to be missing constants), why not install another instance of Microsoft Dynamics GP 2010 to just grab a clean DYNAMICS.Dic dictionary.  So he went back to his room and grabbed his external hard drive, only to find that it did not have the GP 2010 install files on it.  Luckily his friend,…

The Microsoft Dynamics GP Technical Conference 2011 starts today.

The morning started with the Opening Keynote. Here are the team getting ready to present.

Chad Sogge, Brian Meier, Jeff Trosen, and Errol Schoenfish

We had some great information and demos about the upcoming Microsoft Dynamics GP 2010 R2 release. There are a huge number of new features planned, the slide below from the presentation shows a summary.  If you are finding this hard to read, don't worry, I have obtained permission to attach the slides from the presentation to the bottom of this blog post.

During the opening session, the latest Microsoft…