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”…

4

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

Quick Tip: Making sure Activity Tracking is enabled for all users

This Quick Tip comes to you courtesy of an idea from my friend, Robert Cavill. On a Microsoft Dynamics GP system where Activity Tracking is being used, it needs to be activated for each User ID/Company ID that you want it enabled for. In most cases, you would want the Activity Tracking enabled for all…

3

Running the IV HITB Reset process after upgrading from Microsoft Dynamics GP 8

Hi Everyone, I recently worked on a case where the IV10201 table is not recording any transaction that sells the quantity. The IV10201 table is the Inventory Goods Received Detail (IV_Purchase_Receipts_DTL) table. This table was added on Microsoft Dynamics GP 9.0 and is used to record all the outflow transactions affecting the quantity of the item….

2

Language settings for Windows client must match SQL Server Language

A few weeks ago, I had a very interesting case with a Middle East customer based in the United Arab Emirates (UAE). The customer had reported that when the modified Computer Check Report was printed from one particular work station, it was blank. The same modified report printed fine on other workstations. We managed to…

4