Merry Christmas 2011 and Happy New Year 2012 to you

It is that time of year again…. The silly season is upon us. It seems that the religious meaning of Christmas has taken a back seat to the commerical side and spending money shopping. Even if you are not interested in the religious meaning, this is a time to celebrate life with friends and family. Mike Tompkins is…

1

From the Blogsphere: Microsoft Dynamics GP 2010 R2 64-bit Hyper-V, Microsoft Dynamics GP 2010 Performance White Paper and Dynamics GP Blogster YouTube Channel

This is just a quick post to update you with some of the recent happenings around the blogsphere. On the Inside Dynamics GP Blog, Jay Manley (with help from Kelly Youells, Lyle Curry, Jason Siever, Ryan Sandness, Daniel Sly, Jon Studsrud, and John Dooley) has completed the first-ever 64-bit Hyper-V images for Microsoft Dynamics GP…

0

Quick Tip: Working with VBA, Extender and Sales Transaction Entry

I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server. The project involved…

1

Cool Videos: Nokia Lumia 800 UK Launch & Bing with Jay-Z’s Book – Decoded

Another week has gone without any posts.  That’s OK as I have a number of posts to publish with some GP related news, another Quick Tip and some fun videos. So starting with the fun Microsoft related videos.   Nokia Lumia Live ft deadmau5 lights up London with amazing 4D projection On Monday 28th November Nokia…

0

Quick Tip: Passing Date and Time Variables to SQL Server

As a follow on from yesterday’s post, Quick Tip: Passing Variables to SQL Server, I wanted to discuss the related topic about passing of date and time variables. There are two main issues we see with passing Dates and Times and both can cause SQL Server to throw the following exception: /*  Date: 12/15/2011  Time:…

4

Quick Tip: Passing Variables to SQL Server

Wow, the week is almost over and I am yet to post something. This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows passed through…

7

SQL Server Error: Cannot resolve the collation conflict

Today I have a post on the solution to a tricky SQL issue. When working with SQL Server and creating a join that links tables in two databases, all goes well when the two databases have the same collation. However, if the databases have different collations the query it will fail in a writhing blubbery gelatinous…

9

No Blog Post Today

Hey everyone, today there will be no blog post. This is because it is my 20th Wedding Anniversary and I have decided that I don’t have to post anything today. Not even a picture that shows how young, slim and clean shaven I looked back then, like the one below:    I am sure you…

10

Granting Access and Binding Defaults when recreating SQL Tables

Added to the Useful SQL Scripts Series. This is a follow on post from my previous article: Backing up and Restoring data when recreating SQL Tables which explains how to recreate tables (usually to fix table structure issues) while making sure that the data is preserved. In the previous post; it has a step 3 to recreate the…

3

Support Debugging Tool at Decisions Fall 2011 and more

Find the Support Debugging Tool Portal here: https://blogs.msdn.microsoft.com/developingfordynamicsgp/support-debugging-tool-portal/   The Decisions Fall 2011 virtual conference is almost here. The Microsoft Dynamics GP day is Tuesday, 6th December 2011 (US Time). There are a dozen great sessions for you from the Microsoft Dynamics GP MVPs and other community members. Have a look at the link below for the…

2

Microsoft Dynamics CRM Connector Blog, Video and Documentation

For those interested in integrating Microsoft Dynamics CRM with Microsoft Dynamics GP (or other Microsoft Dynamics ERP systems), here is some information and helpful links related to the Connector for you. The Connector is an important part of the CRM Attach strategy for including CRM into ERP opportunities (and vice versa) for creating a more holistic,…

2

Dynamics GP Developer Insights: GUI Independent Window Object Model

Hello, my name is Chris Rudolph.  I have been working as a software engineer on the Dynamics GP team here in Fargo since the summer of 2008.  I like to spend my time hanging out with my wife (we just started disc golf!) and playing the cello. So far at Microsoft I have worked on…

1

Dynamics GP Diagnostics

What are Diagnostics and why do we need them? Diagnostics are a CTS (Commercial Technical Support in Microsoft) initiative that has been around a few years. If you’ve logged a support incident for other Microsoft technologies such as Windows, Exchange, SQL and others – chances are you were asked to run some sort of “Diagnostic”…

3

Capturing Images from a Microsoft Word 2007/2010 Document

Here is a neat trick that I just used to copy images from a Microsoft Word 2007/2010 *.docx document. I was given a Word document of a blog article to be posted on the blog. To get the text into the blog post editor (without extra html) is easy…. Just cut & paste into Notepad.exe…

4

Convergence 2012 Houston Registration is now open

Registration for Convergence 2012 Houston is now open. The conference will be held at the George R. Brown Convention Center in downtown, Houston, Texas, USA on the 18th to 21st March 2012. There is a US$300 Early Bird discount if you register before 26th January 2012, so register now and save. Click on the image…

3

2011 US Payroll Year End Updates for GP 10 and GP 2010 are now available!

The English downloads for the 2011 US Payroll Year End Updates for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010 are now available. Thanks to all the development and support team members who worked on this. The following product have been update for GP 2010 and v10.0: Product  GP 2010  v10.0   Microsoft Dynamics GP …

1

Do not use the DEX_ROW_ID table column in your Customizations and Integrations

Today, I responded on a post on the Partner Forum asking “Can the DEX_ROW_ID change for a record over time?“. In this case the partner had seen the values for DEX_ROW_ID change on the GL20000 (GL_YTD_TRX_OPEN) and GL30000 (GL_Account_TRX_HIST) tables. This caused problems for an integration to an external system that used the DEX_ROW_ID as a…

11

Quick Tip: Using SQL to return the number of records in a Table

Now I am sure there are people out there that will be thinking that this is a silly topic for a blog article. Surely everyone knows how to get the number of records from a SQL table using the COUNT(*) function? Well, you would be correct that most people do know the COUNT(*) method as shown…

11

New TV Commercials showing Windows, Windows Phone and Cloud Services

There have been some new Microsoft TV Commercials released recently which show off how all the Microsoft products and services can work together from the PC to the phone and the cloud.  Check out the videos below. I like the “Keep Shopping” advert and example as that shows a real practical use.   TV Commercial…

1

The Microsoft Big Windows Phone

Here is a bit of Microsoft Windows Phone fun for you. On Monday (US Time) Microsoft celebrated the launch of 4 new Windows Phone models by building a 6 story Windows Phone (150 times bigger than an actual handset) in New York’s Herald Square. Once built there was a whole heap of live entertainment throughout…

2