Robert Houdeshell's blog

Have you ever googled or bing'ed an error and notice that everyone is missing the boat? Well, that happened recently while doing a mail merge of CRM Contacts with Microsoft Word.

Here's the setup:
Using Microsoft Dynamics CRM Internet Facing Deployment with a view that was setup to e-mail newsletters
Using Microsoft Internet Explorer v 8.0
Using Microsoft Word 2010

The process:
Selected the records/view to mail merge to
Clicked on the mail merge button
Microsoft Word opened and when I went to step through the Wizard, it gave me the error: Error 52 Bad file name or number

The Rabbit Hole:
Upon searching for a solution, I kept finding articles about how it worked before but now it doesn't. Further, I found solutions that led a person to believe it was an authentication issue.

The REAL Solution:
It was very simple. It struck me that on my Windows 7 64 bit OS and IE v8.0 64 bit, that this might very well be the issue.
I launched IE v8.0 32 bit, performed the same steps and the process worked.
My presumption is that since the Mail Merge puts a text file out there for the Word doc to use, there was some confusion between the 32 and 64 bit filepath.

Hope this helps!

In this blog entry, I want to take on the financial case for moving your business to the Cloud. First, let's discuss what the Cloud is and what it isn't in the context of business applications. According to NIST (National Institute of Science and Technology) “Cloud computing is a model for enabling convenient, on-demand network access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction. This cloud model promotes availability and is composed of five essential characteristics, three service models, and four deployment models.”

NIST further defines that there are 5 Characteristics
1) On-Demand Self Service
2) Broad Network Access
3) Resource Pooling
4) Rapid Elasticity
5) Measured Service

The Cloud, for purposes of ERP and CRM applications, will be discussed in the context of Software as a Service (SaaS) and in a Hybrid Cloud model. This means that we won't discuss Platform as a Service or Infrastructure as a Service nor will we discuss community or public clouds.

Now, let's tackle the financial case for the Cloud. Having been in this industry since 1994, here are my observations about business applications. First, every business needs business applications. Typewriters are replaced with Microsoft Word and related applications. 13-column ledgers (yes, remember those big green sheets in the Accounting Department?) are replaced with Excel and accounting applications such as Dynamics GP (Great Plains) and SL (Solomon) or at the very least, off the shelf software like QuickBooks. Rolodexes are replaced by CRM systems of varying sophistication such as Act or Dynamics CRM. So the conclusion is that business applications are here to stay. Are you willing to give up your e-mail or your smart phone?

How did we get where we are at? In the 1980's, the microcomputer began replacing the mainframe and became prevalent in business. This grew into a multi-billion dollar industry over the course of the next few decades. Solutions grew up around the networked PC and then quickly transformed into individualized computing power. Every user now has the ability to create their own Word documents, enter accounting transactions and track sales. This functionality is available for every business that can pull out a laptop or desktop and setup a business. This disruptive change has lowered the barrier to entry for every individual and company. We need only to look at the music industry changing from powerful record labels to individual musicians publishing their music to iTunes.

Today, disruptive forces abound. I am not an economist but I see the effects of the economy on business. It affects almost every industry and every company. Businesses today are forced to watch every dollar they spend and tie it directly to revenue and profit. Therefore, businesses are very smart about their investments and therefore are spending on assets that directly improve their bottom line. Since 1994, I have said many times that accounting and CRM systems are necessary for every business whether in good times or bad. In good times, businesses need to capture more customers than their competitors. In bad times, businesses need to serve their existing customers so they don't leave and they need to control costs.

However, business applications that were bought just five years ago do not provide the critical functions needed in this economy. Further, what if this economy doesn't turn around for a few years? What is a business to do in order to either maintain their market share or ideally capture market share from the competition?

Investing in a new ERP (Accounting) or CRM (Sales) system has historically required a significant amount of capital to be used up front to buy software and an equal or greater amount of capital to implement the software. This is capital that most business advisers would recommend being used for new machines, labor or other revenue and profit initiatives.

The solution is to research and deploy cloud-based solutions such as Microsoft's Exchange Online, NjevityToGo ERP (Dynamics GP & SL) or NjevityToGo CRM (Dynamics CRM). These solutions have the same low barrier to entry that every business expects today. Most businesses pay $100 to $150 per user per month for a smart phone and service. For the same cost per month with a much smaller number of users in the business, you can deploy Microsoft Dynamics GP Accounting software to provide full financial, distribution, reporting and business intelligence functionality.

This is a great leveling in the playing field between you and much larger competitors. In fact, you as a small business, have the upper hand! You have an unprecedented opportunity to implement a new system whereas your larger competitors will still be spending money on their old system with old capabilities.

Our approach to implementation, the other major expenditure you have in a system change, is the key to a successful low cost solution. With our QuickStart and SmartStart implementations, we provide you with project plans, templates, online training and a host of additional resources to reduce the costs of implementation. This approach puts the majority of the data conversion, training and report writing work on your team. The result is that you do not need to pay consulting fees and your team learns the system much quicker. There is also an ownership of the new system that results from this approach.

In conclusion, the time to make a business application change is now. It is time to capture market share from your competition. It is time to streamline your business processes. It is time to finally be able to make informed business decisions. If you have further questions, contact me: Robert Houdeshell rhoudeshell@njevity.com for a custom presentation. I am willing to work with you to lay out a plan to improve your business and capture more of the revenue and profit your company deserves.

When you open multiple Microsoft Word documents, you are able to put one on your main monitor and one on your secondary monitor to compare, copy and paste from one document to another. However, if you open multiple spreadsheets from Excel, you can't do the same thing! This has annoyed me since 2007 when Microsoft introduced the functionality in Word but not in Excel.

Well, I found a way around it. Here is how.

1) Open your first Excel spreadsheet. Place it on the monitor you wish to work with it.
2) DO NOT open the second spreadsheet with the Excel program that is open. Instead, go to your Start Menu and open Excel from there. Then do a File >> Open and open your second spreadsheet.
3) Place the second spreadsheet on the monitor you wish to view the spreadsheet.

As far as I can tell, since you're opening a second instance of Excel, you can place it wherever you wish.

Early in the last century, manufacturers had electrical generators in their facilities and their ability to produce was tied directly to their ability to generate electricity. It was Edison and Tesla who ushered the creation of the electrical grid to the American society. Think about your usage of electricity today. You flip on a light switch, fully expecting the electricity to be there for you, on demand. You further pay for the usage of electricity that is consumed during the month.

Today’s transformation to The Cloud is not much different. Our customers enjoy on demand, monthly services that provide them with ERP (Enterprise Resource Planning) and CRM (Customer Relationship Management).

This lessens the impact on your bottom line, gives you predictable expenses and provides you with an application and IT infrastructure that doesn’t require having your own set of consultants or engineers to support your business.

Our Cloud Applications are priced from $5 per user per month for Microsoft Exchange and $44 per user per month for Microsoft CRM (Customer Relationship Management).

Take your business to the Cloud by requesting more information below! An Njevity Senior Consultant will contact you and help you understand the benefits so you can get started immediately!

Suppose that you have two servers (CRM and GP) that are physically different servers with named instances. You have data in your CRM server that you want to expose through the GP server. In order to do this, I did some research that I found very interesting and very successful.

My goal in this process was to pull into a view, specific information from the Orders in CRM. The information, however, is stored in the Extension of Orders (meaning customized fields).

*** WARNING! *** DO NOT PROCEED WITHOUT THE CONSENT OF YOUR IT DEPARTMENT! Further, you assume all liability regarding the impact of the following recommendations.

Step 1 is to turn on the ability to do Ad Hoc Queries on the CRM server (Target Server). Execute the following commands against the Master database on the CRM (Target) server.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;

Step 2 is to add a linked server on the GP server. Execute the following commands against the Master database on the GP (Source) server.

EXEC sp_addlinkedserver
@server=N'SQL\CRMInstance',
@srvproduct=N'SQL Server'

You should now see a linked server when you Select * from sys.servers in the Master database (should show as server_id 1 or anything higher than 0)

Step 3 is to test your connection. I did this with a simple query to begin with.

SELECT *
FROM [SQL\CRMInstance].MSCRMDB.dbo.SalesOrder

Step 4 is to create your view as you would like it exposed in GP.

Create view v_GiftMessage as

Select so.Customeridname as [CustomerName],
so.OrderNumber as [CRMOrderNbr],
so.Name as [GPOrderNbr],
soext.cus_GiftMessage as [GiftMessage] -- Note: this is the Custom Field in the Extension of Orders
from [SQL\CRMInstance].MSCRMDB.dbo.SalesOrder SO
join [SQL\CRMInstance].MSCRMDB.dbo.SalesOrderExtensionBase SOExt
on so.SalesOrderId = SOExt.SalesOrderId