Page 1 of 3512345678910...20253035...Last »

SQL Script To Copy Tax Setup To A New Company | azurecurve

Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant ( This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). …. MVP Profile azurecurve on the Dynamics Community Email azurecurve View azurecurve View Detailed RSS Feed View Ian Grieve’s View azurecurve’s Feed on Twitter View Ian Grieve’s profile on LinkedIn View …

SQL Script To Copy Tax Setup To A New Company | azurecurve

November 17, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 2

New Detailed RSS Feed | azurecurve

If you are using the current feed-full RSS feed, please change to using the new detailed RSS feed: The current one will be available for a few more weeks, but I will then be retiring it.

Originally posted here:
New Detailed RSS Feed | azurecurve

November 7, 2015 · Ian Grieve · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 22

Excel Copy/Paste feature not working on General Entry modified window

If you have grown used to the relatively new Excel Copy/Paste feature in the General Ledger Transaction Entry, you are probably enjoying the benefits of collecting journalized spreadsheets from around the company and simply integrating these into Microsoft Dynamics GP without too much effort.

Excel Copy/Paste in GL Transaction Entry window

The fact is, not having to run an integration from another tool for something apparently very simple, always seems to be the way to go.

Recently, however, I ran into a situation where this window had been customized with Modifier (but the same can be said for a third party alternate version of window) by a customer. The customer reorganized a few fields within the window and added a couple others with Modifier to address some specific business needs. As it turned out, the Excel Copy/Paste functionality no longer worked, even though the target fields remained the same. Reverting security to the original window rendered the feature usable once more.

If you must modify this window _and_ still require the Excel Copy/Paste feature, you will need to create an additional user with access to the original (core) window. This is very similar to what’s required for Integration Manager to function when a window has been modified with Modifier or changed by a third party product.

Well, now you know! Happy copy/pasting!

Until next post!

Mariano Gomez, MVP

See more here:
Excel Copy/Paste feature not working on General Entry modified window

October 23, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 44

Microsoft Windows 10 Devices Briefing

Today, Microsoft continue to show why it is at the forefront of the computing and technology world. A company that was once joined by the hip to the personal computer (PC) is now able to move with the times with a vision centered on mobile computing – to think, a few years ago the company was scrambling to catch up with Apple and Google.

Just 10 weeks ago, Microsoft begun rolling out Windows 10 and now boasts 110 million users and 8 million business PCs. Once more, Microsoft surprises the computing world with a host of new computing devices designed specifically for Windows 10.

Windows 10 Devices Briefing

Microsoft Devices: Do Great Things.

The New Microsoft Band

The New Microsoft Band: Live Healthier and Achieve More

The New Microsoft Surface Book

The New Microsoft Surface Pro 4

The New Microsoft Lumia 950 and 950 XL

Tell you the truth, I moved from a Windows phone (Samsung ATIV S Neo) on the Sprint network to a Samsung Galaxy S6 Edge on the same network, which runs Android. While I have been able to adapt to the Android platform, I still don’t quite get the fuzzy feeling I did with my Windows phone. Maybe if Sprint decides to take on the new Lumia phones, I will switch back in a heartbeat, but that’s wishfull thinking. At this point, I will sign up for a new Microsoft Band as today I have the first iteration of that device which has been quite surprising so far (less the barometer feature now available in the second iteration). I will also be looking to upgrade my Xbox One to Windows 10 as soon as release becomes available. And speaking of Xbox One, here’s one of the coolest commercials they have.

My son has been enjoying Forza 6, which I got when I went to Fargo for reIMAGINE 2015. This game has been awesome to play so far, but I find it challenging without a driving wheel. Maybe it’s time to consider that Logitech G920 Driving Force.

I will also be looking forward to jump on a Surface Pro 4 as soon as I can, but for now it’s all a matter of enjoying Windows 10 all around on my laptops.

Until next post!

Mariano Gomez, MVP

Continue Reading:
Microsoft Windows 10 Devices Briefing

October 7, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 47

Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites

Few days before I was having client requirement to unassigned around 50K + items from specific sites. There were several help available on web one of is from MVP Mohood ( . I followed his sql query to delete all those items from sites.

But recently I found new feature in Dynamics GP 2013. From Navigation–>Click on Inventory –> Click Items. You have option to add filters base on your requirements.  Check mark items you want to unassigned from sites.  Click on Unassigned Site icon. Select Site and click Unassigned.

You have option to to add site with same screen.

Thanks much
Sandip Jadhav

Continue Reading:
Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites

July 28, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 76

Microsoft Dynamics Bite Sized Webcasts – June 2015

This article contains the list of Microsoft Dynamics Bite Sized webinars which we have scheduled EXCLUSIVELY for partners for June 2015, so that partners can benefit from these workshops. If you are a partner of Microsoft, please feel free to register for these sessions and improve your readiness on Microsoft Dynamics products.  Customers can reach out to their partner for this information.  The details of these sessions are provided below. All times mentioned below are in Central Time Zone

Microsoft Dynamics Bite Sized Webcasts – June 2015

June 16, 2015 · Kelly Dettmann · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 175

DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

Hello all! It’s been quite a while since I’ve actually written anything of remote interest to anyone who follows my blog, but at the same time, you will be pleased to know that I’ve been quite busy in the consulting front, with upgrades, server migrations, complex multi-instance postings involving 10’s of thousands of transactions, wrapping up some Field Service Automation projects, and the list goes on and on.

This time around I want to bring to the forefront, an issue I encountered updating from Microsoft Dynamics GP 2013 SP2 to Microsoft Dynamics GP 2013 R2 plus the latest service pack.


My client requested a server migration to a new environment where they wanted to deploy Dynamics GP 2013 R2 web client (plus the latest service pack) and upgrade their relational database management system to Microsoft SQL Server 2014. This is something I’m absolutely comfortable with (for the most part) given also that my client was sitting at Microsoft Dynamics GP 2013 with Service Pack 2.

As it is customary with these types of request involving a server migration, I followed the very clear instructions outlined in KB article 878449How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server. I have walked through this article more times than I care to mention and can pretty much recite the steps by heart.

During the Dynamics GP Utilities process on the system database, I kept receiving the error message:

“Microsoft Dynamics Utilities Install/Upgrade failed”

This seemed to be a recurring problem on the sySrsReports table during the system database update. Upon further inspection, I noticed the temp table created for the sySrsReports (sySrsReport_T) was still present and that dropping this table would allow Dynamics GP Utilities to continue processing the system database update to completion.

However, the company database updates were failing with the following error messages:

“The stored procedure GetBD_UpgradeStatus() of form duSQL Pass Through SQL returned the following results: DBMS: 12, Microsoft Dynamics GP: 0.”

Upon clicking the OK button, the following error message would appear:

“The stored procedure UpdateDB_Upgrade() of form duSQL Pass Through SQL returned the following result: DMBS: 12, Microsoft Dynamics GP: 0.”

The above two errors would reiterate a few times (5 or 6 to be exact) to finally produce the following error:

“The stored procedure getCompanyID() of form duSQLInstall Pass Trough SQL returned the following results: DBMS: 12, Microsoft Dynamics GP: 0.”

And would come to rest with the error described at first. Now, I’ve done myriads of upgrades in my lifetime, but this one put me on a cliff for a while. The DEXSQL.LOG clearly did not show anything specific and the duinstall.log just showed execution messages (“Message encountered” messages) happening where the problem occurred.

In all fairness, the DEXSQL.LOG kept showing a “[Microsoft][SQL Server Native Client 10.0]Communication link failure” error which lead me to check the version of SQL Server Native Client I was running, which was version 10. I then upgraded to SQL Server Native Client 11.0 and nothing really changed.

I also realized the update was failing while attempting to create the table auto procedures for the wkPostingValidationState table. I then drop this table and its auto procedures and restarted the update in the hopes it would recreate the objects once more, but was not successful.

Suffice to say, I restored the system database and company databases in order to devise a different strategy.

The Solution

After tinkering with the installation, I decided to retrace my steps and realized that during the installation process, I chose to install Web Client Runtime Engine – after all this machine was the web server and would be running a Single Machine instance of Dynamics GP. I then decided to install the Dynamics GP client on the database server without the Web Client Runtime Engine and launch GP Utilities once more. The update process ran flawlessly without any errors!

I still cannot understand why the presence of Web Client Runtime Engine would have caused an error while updating a service pack, however I have to remind everyone of the official Microsoft stance: “the session host must only be used to perform very little administrative work”.

It was good to finally get pass these issues and complete the update process for my client.

Please take a look at my GPUG webinar on upgrades at:

Mariano’s Toolbox: Upgrading to Microsoft Dynamics GP 2015 for dummies 

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

See original article:
DBMS: 12 Microsoft Dynamics GP: 0 error when updating to Microsoft Dynamics GP 2013 R2

May 24, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 203