Merry Christmas 2013 and Happy New Year 2014

It is amazing how quick the time goes. A whole year has passed and the holiday season is here again. I have been enjoying relaxing while on leave. It is nice to just spend time at home and doing things you don’t normally get to do. For me, I have been playing some Xbox games. I…

0

Where is David in December?

Well that’s easy. I am were I always am. At home in Perth, Western Australia … However, I wanted to let you know that I will be taking some Annual Leave from the 9th December through to the 5th January.  I will still write the odd blog post as there are some ideas I have waiting…

2

TCP Chimney Setting and SQL Server Error: TCP Provider: An existing connection was forcibly closed by the remote host

You might have heard me discuss the TCP Chimney settings before. If not, don’t worry as this post is here to make sure you know about the setting and make sure it is disabled for all your Microsoft Dynamics GP installs. My earlier post which mentions the TCP Chimney settings, discusses an issue with a…

2

Xbox One has arrived – In Stores Now

Six months after the Xbox One was revealed, Launch Day, November 22nd 2014, has arrived. Welcome to a new era of gaming and entertainment. For all the latest information check out the Xbox website and Major Nelson’s Blog: Xbox.com  MajorNelson.com . Here is your invitation to jump ahead: Xbox One: Invitation (direct link) [View:https://www.youtube.com/watch?v=_1mfIg1I3zE]  …

1

Utility Script for CRM Connector Integrating with Dynamics GP Sample Company

This is an interesting script which I have decided to post in this article. When we configure CRM Connector with Dynamics GP for the sample company (Fabricam, Inc.,), there is a known issue in the way the sample company data is structured. As many of you would be aware of, the sample company data has…

1

Recursive Querying in SQL Server

In this post we will discuss about the use of recursive querying in SQL Server. Recently, I got a request from a Partner to develop a SSRS report for the Indented Bill of Materials in the Inventory module. I was going through the Dexterity Indented Bill of Materials report and found out that the report…


Identifying Microsoft Dynamics GP version information

I had a case recently where the customer’s auditors were asking the customer to prove the version and build of Microsoft Dynamics GP was the same as the version they claimed it was. Basically, the auditor said “provide me proof that you are running GP X SP Y”. So during this case, I discussed a…

8

Identifying where SmartList Column Data comes from

Recently, I had a support case which asked the following: “When I go to Add the Sales Account Number to the Sales Line Items SmartList, there are three Sales Account Number Columns available. What is the difference between them?” So, I wanted to work out a method to make it fairly easy for customers and…

2

Microsoft Dynamics GP 2013 Service Pack 2 New Feature Videos

A while ago, Microsoft Dynamics GP 2013 Service Pack 2 was released. This Service Pack contained a number of new features as well as the usual fixes for issues. The Microsoft Dynamics GP support team have released a series of articles and videos demonstrating and explaining these new features. I am posting them below for your reference.   Here…

1

Microsoft Dynamics GP 2013 Service Pack 2 Features of the Day

After the release of Microsoft Dynamics GP 2013 Service Pack 2, the Inside Dynamics GP team have released a Feature of The Day series. In case you missed them, here is a summary post with links to all the articles: Get functionality sooner: Microsoft Dynamics GP 2013 Service Pack 2 Now Available with New Functionality …

0

Quick Tip: Unusual behaviour when working with SQL Server from Dexterity

Today, I came across an issue where a feature in Microsoft Dynamics GP would work when the workstation had its regional settings set to United States, but would fail to produce any data when the workstation had its regional setting set to Australia, New Zealand, United Kingdom, etc. We have seen related issues where code…

1

eConnect transaction not rolling back

I ran across an interesting case the other day with eConnect.  I had a similar type of case I wrote about previously, but this one is for a completely different reason. The ISV was moving his working customization from GP 10.0 to GP 2010/2013. The Problem Essentially the customization would use eConnect to create a…

3

All About Listbox, Button Drop Lists, and Drop Down Lists

It seems like a trivial subject for our dedicated readers but we had a new customer who is just learning Dexterity and he was having trouble recently trying to select items out of a ListBox.  And just today the issue came up about Drop Down Lists (DDL) and getting the value selected using VBA in…

1

Surface 2 and Surface 2 Pro videos

Last month, I wrote an article about the Surface 2, Surface Pro 2 and accessories being announced. As a follow up I thought I would post links to some new videos and to the launch event, in case you missed it. The event can still be viewed on the original link, but is also available…

0

Windows Comparisons Videos

You might have already seen some of this adverts comparing Windows devices with a certain other popular brand. These fun adverts demonstrate how you can get more for less.   Windows 8: Less talking, more doing (direct link) [View:https://www.youtube.com/watch?v=86JMcy5OqZA]    Comparison: iPad vs. Windows 8 Tablet (direct link) [View:https://www.youtube.com/watch?v=zgu9uo2UpPg]    Dell Tablet vs. iPad (direct…

0

Windows Everywhere Videos

With the release of Windows 8.1, Microsoft has a new Windows Everywhere campaign to promote Windows to provide one experience on every device for everything in your life. The first video is an Australian version of the second video. It definitely works better to have a local accent when running adverts on TV.    Windows 8.1 Everywhere…

2

Quick Tip: Where does that customisation come from?

I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots. The answer to the question is that the method to change the URL depends on what…

1

Windows 8.1 released and available for download

Today signals another milestone in computing history with the release of Microsoft Windows 8.1. If you go to http://www.windows.com/buy, the site will detect your current operating system and provide you with the steps to upgrade. If already running Windows 8.0, you can just start the free upgrade process.   Check out this video showing Windows 8.1…

0

Friday Funny: Every Tech Commercial

My eldest son spends too much time on the internet. He loves looking at internet memes and also subscribes to a number of youtube channels. While I do hassle him to stop wasting time, every now and then he finds something very funny. He showed me this College Humor video recently and I thought it was…

0