Page 1 of 2112345678910...20...Last »

What’s New in Microsoft Dynamics GP 2015

David Meego - Click for blog homepageAt the start of December 2014, Microsoft Dynamics GP 2015 was released to manufacturing and shortly after it was posted online:

Since its release, the Support and Services team have been putting together blog articles and videos providing details about the new features.

For a quick overview, I would suggest watching the great videos below:

Microsoft Dynamics GP 2015 System Wide New Features (direct link)


Microsoft Dynamics GP 2015 New Features- Applications (direct link)


For more information, check out the series of articles from the support team.  Click on the link below for the table of contents:

If you have not downloaded the installation files for Microsoft Dynamics GP, please use the link below:



This article was originally posted on

Filed under: 2015, Dynamics, GP, Microsoft Tagged: Application, Blogosphere, GP 2015

Read More:
What’s New in Microsoft Dynamics GP 2015

February 11, 2015 · WinthropDC · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 58

Opening Up a World of Possibilities with Microsoft Dynamics GP 2015 and Services

Alice Newsam - Click for blog homepageOn 13th August in Fargo the Microsoft Dynamics GP development team delivered a hands-on workshop to our Collaborative Development partners around the new Service Based Architecture (SBA) that will be available in Microsoft Dynamics GP 2015.  Throughout the day the team went over various pieces such as .NET Interop, changes to the current toolsets and implementation considerations.  They also provided hands-on learning time with the ISV Preview VM for the partners to work with the new code.  In this post I’d like to highlight Kevin from EthoTech, Inc. and his experience creating a service procedure with the new functionality. 

EthoTech, Inc. specializes in automated commission management systems. As such they have very close ties into Dynamics GP today.  However when looking at their future feature list many of them require some type of action to be taken within the system before the automated jobs can take over. After attending the workshop and getting some hands on time with the architecture Kevin had this to say “We’re excited about the service-based architecture, as it affords us the opportunity to provide some of the most-requested features of Commission Plan”.  Now when things like sales documents are created outside of the Dynamics GP user interface, the associated commissions can be automatically created.  They can also envision running tasks such as commission updates and reports as scheduled jobs now that they will have access to the system via the Service Based Architecture feature set.

After returning to the office from the workshop Kevin was able to create his own service procedures in his dictionary and successfully make an external service call to his new procedures and run the existing business logic that had been only accessible through the UI previously.  Below are some observations and recommendations around the process from him.

How easy was this process for you?

“This process was very straightforward. Within a short time, I was able to interact with the major Commission Plan calculation routines via a web service. We’re now reviewing all our products to determine which features to make available as web services. EthoTech’s Next Numeric Collection is an obvious choice – when master records are created outside the UI, calling the procedure will return the next master record number, with validation.”

What things did you like most about the feature set? 

“With a small amount of code refactoring (primarily logging error states rather than popping error messages), I am now able to expose my existing Dexterity procedures as web services. This provides tremendous benefit to our clients with no additional development overhead (i.e., I don’t have to rewrite my code outside of Dex).”

What recommendations would you have for others preparing to do the same thing?

  • Learn about REST services to gain base knowledge around things like REST verbs
  • Download the Service Based Architecture Developer Preview now available on PartnerSource
  • Walk through the examples and samples provided
  • Think about what abilities you would want exposed externally as a service to solve your customer’s problems or allow for even great functionality with Dynamics GP
  • Give thought to how you can leverage the creation of GP documents now in Sales Order Processing, Receivables, GL, Payables, etc. along with the actions around these documents such as transferring, posting, and so on. Especially consider the actions that don’t currently exist in eConnect like posting inventory transactions.

As a development team we are working to create more examples and build out the documentation surrounding these features.  We also have a series of blog posts coming that will reveal more about the various pieces that will be available to you and Service Based Architecture will be greatly featured in the upcoming reIMAGINE 2014 event planned for 10th to 12th November in Fargo, North Dakota, USA.  The powerful possibilities being enabled through the developer toolset via the tight .NET Interop integration and service based architecture coming in Microsoft Dynamics GP 2015 are vast.  What scenarios will you be able to light up for your customers? 

Happy coding!


Original post:
Opening Up a World of Possibilities with Microsoft Dynamics GP 2015 and Services

September 22, 2014 · Alice Newsam Msft · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 109

New Microsoft Dynamics GP Videos

David Meego - Click for blog homepageLast week, the Microsoft Dynamics YouTube Channel released 3 new videos for Microsoft Dynamics GP.

Below are the videos for your watching pleasure.

If you want more information on Microsoft Dynamics GP, check out the overview page:


Microsoft Dynamics GP Keeps People Productive (Direct Link)

(Please visit the site to view this video)


Microsoft Dynamics GP Turn Data into Business Insight (Direct Link)

(Please visit the site to view this video)


Microsoft Dynamics GP Helps You Get Started Quickly (Direct Link)

(Please visit the site to view this video)




View article:
New Microsoft Dynamics GP Videos

September 18, 2014 · David Musgrave · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 191

VBA: DUOS data stored in the wrong database after switching companies

David Meego - Click for blog homepageA while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation. Everything worked fine until the users switched companies. After switching company the VBA customisation would still be connected to the DUOS table in the previous company’s database. If the user exited Microsoft Dynamics GP and logged back in, the DUOS in the correct database was used.

The DUOS table is in fact the SY_User_Object_Store (SY90000) table in the company database and is usually used by VBA to store additional data without needing to create new tables in the SQL Server databases.

When you switch companies, the connection to the DUOS table is closed so it can be re-opened once you have logged into the new company. If for some reason the DUOS table is not closed, the DUOS table will still point to the previous company database rather than the new company database.

We were able to identify the cause of the issue as the Support Debugging Tool (builds 17 or earlier). The SDT can use the SY_User_Object_Store to store temporary data when using helper functions to create parameters to pass data between scripts. When exiting Microsoft Dynamics GP or switching companies, it executed some code to remove any temporary records left in the table. It turns out that this code ran after the core code had closed the table and so re-opened the table causing the issue.

Build 18 (released in February 2014) or later of the Support Debugging Tool resolves this issue. 

Recently, I had another case with the same issue and the same cause.  So I decided to write a specific blog post to request the Dynamics GP community make sure they are running the latest Support Debugging Tool builds.

So, if you use VBA with the DUOS and have the Support Debugging Tool installed, please ensure you download the latest version and install it on your server and all workstations. Please go to the Support Debugging Tool Portal ( for links.

Note: Assuming you are using the “Recommended Configuration” with a shared Debugger setup file location, once you have installed a later build on one workstation and logged in, all other workstations will pop up a warning dialog on login until they are also updated.

Thanks for your support. 


See more here:
VBA: DUOS data stored in the wrong database after switching companies

September 1, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 80

Microsoft announces Developer Preview for Dynamics GP 2015

Kevin Racer - Click for blog homepageMicrosoft is pleased to announce the availability of the developer preview for Microsoft Dynamics GP 2015.  This partner only preview is available to any registered Microsoft Dynamics GP partner and can be downloaded from PartnerSource.  The preview itself is comprised of four parts that once downloaded can be extracted into a single virtual machine instance containing a fully functional installation of the Microsoft Dynamics GP Service Based Architecture (SBA).  Information on using the virtual machine can be found in the attached readme document (at bottom of article).
The preview is intended to promote the exploration and early adoption of the Microsoft Dynamics GP Service Based Architecture by partners and ISV developers and cannot be used for customer test or production environments.  The Service Based Architecture is a set of new component services as well as changes to the Dexterity IDE and runtime that enables the creation of REST based web service operations that leverage existing sanScript code based functionality.  The Dexterity IDE has also been significantly enhanced to interoperate with Microsoft’s .NET framework making it easier to use .NET classes and objects with in the sanScript language.  Users of the preview are encouraged to regularly check our blogs for updates and informational examples on this new architecture.


Part 1

File Name Dynamics_GPServiceISVDrop_Aug132014Parts.part1.rar
File Size 4193280 KB


Part 2

File Name Dynamics_GPServiceISVDrop_Aug132014Parts.part2.rar
File Size 4193280 KB


Part 3

File Name Dynamics_GPServiceISVDrop_Aug132014Parts.part3.rar
File Size 4193280 KB


Part 4

File Name Dynamics_GPServiceISVDrop_Aug132014Parts.part4.rar
File Size 1084807 KB


Don’t forget to download the Readme document attached to the bottom of this article.


Please post your feedback as comments on the blog. 

Until next time


See original article:
Microsoft announces Developer Preview for Dynamics GP 2015

August 29, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 143

Update: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions – RW_CoAddrIDInfo broken

David Meego - Click for blog homepageFollowing on from my post: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions, I have to admit that I made a mistake.

The Problem

The update to the RW_CoAddrIDInfo() report writer function has broken the code. It works when no Address ID is supplied to return the information from the default Address information stored on the Company Master table, but fails to return any results from the Location Master table when an Address ID is provided.

I looked at the code and identified the issue and have logged the proposed fix with the development team as TFS Bug 79342. Hopefully, we can get the fix into the next GP 2013 R2 release soon.

In the meantime, I have created a couple of workaround fixes which can be used until the code is fixed by development. They are attached to bottom of this article.


The Fixes 

Using Support Debugging Tool

The first fix uses the Support Debugging Tool ( to create a custom Report Writer function which can be called using the following syntax:

FUNCTION_SCRIPT( rw_TableHeaderString  5261  “RW_COADDRIDINFO”  “Address ID”  0  X )

where the Address ID can be specified as a string constant or from a variable and X is the data you want returned.

The Runtime Execute script and an example custom report are in the archive for you to use.

If you already have the SDT installed in the Recommended Configuration (with a shared setup file), you can deploy the fix by importing the configuration settings xml file once on any workstation and updating your reports to use the function call above.


Using Dexterity

The second fix is a small Dexterity chunk file which triggers a corrected version of the RW_CoAddrIDInfo() function after the original and so provides the correct results. It can be used without making changes to existing reports, however, the chunk will need to be deployed on all workstations that need the fix. The chunk file and its source code are provided in the archive for you to use.


Both fixes should be removed once the original code is fixed.

See I am human, and not the Alien that Mark Polino thinks I am. 


Original post:
Update: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions – RW_CoAddrIDInfo broken

August 22, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 89

How to pass parameters to custom SSRS reports activated to print from the Dynamics GP windows

Viswanathan Neelakantan - Click for blog homepageRecently there was a question on the forums regarding passing parameters to custom SSRS reports assigned to Dynamics GP windows.

In Dynamics GP 2013, SSRS reports can be printed directly from Forms. Each window will pass a default set of parameters to the assigned reports.

For an example from the Customer Master the ‘Customer Number’ will be passed as a parameter. When the assigned SSRS report is selected to print, Dexterity will build the URL for the report and assign the parameter value (Customer Number) passed from the window to the SSRS Report. In the case of custom SSRS reports to have the parameter values getting passed from the Dynamics GP windows, the Parameter(s) name should exactly match with the Parameter(s) name passed from the window.

For an example: if you have a custom SSRS report which accepts SOP Number and SOP Type as a parameter. The Parameter names in the SSRS report should be SOPNUMBE and SOPTYPE for SOP Number and SOP Type respectively.

Once you specify the Parameter Names correctly, the Dexterity code will build the URL and assign the parameter values from the window.

In the next post we will see how it can be customized if we want to pass custom parameters.

Until then


More here:
How to pass parameters to custom SSRS reports activated to print from the Dynamics GP windows

August 11, 2014 · Viswanathan Neelakantan · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 174