Tag: KTL Solutions

How to increase profits and sales using CRM

Many times business executives get caught up in the details and miss the big picture. How do I increase sales, profits, and productivity? The answer might be right on your computer. Using Dynamics CRM, many options are available to easily and quickly increase your company's bottom line. Catching the attention of the Executive or Business owners in how to achieve better sales and profits and make more money is sometimes easier said then done. CRM is a company wide tool using technology to support a business strategy to improve, analyze and automate company sales, customer services, and marketing by combining them to improve the sales and profits of the company.  

Read More »
December 4, 2015

CRM = Create, Reach out, Money

Business today requires fast, accurate action, not reaction. Many of the features available in Microsoft Dynamics CRM will help facilitate those goals and lead to overall success in your business. This is more imperative than ever in today's instant gratification world. Dynamics CRM has multiple features to help accomplish this….fast!

Read More »
December 2, 2015

How to track projects using CRM

 

Before I present the options and the different ways to track projects in CRM, let’s look at the different aspects of project management that would be needed in any organization. 

  1. Resource Scheduling 

  1. Project planning &tracking 

  1. Time & Expense entry 

  1. Ap

Read More »
November 24, 2015

Riddle Me, Query Me: Asking the Right Questions.

Everybody has dirty data. If you are lucky, on a normal business day it isn’t noticed very much, if at all. But, during a data migration, it can cause more than an embarrassment. It can cause a whole implementation project to come to a stop. Or, in extreme cases, it can make the whole dataset unusable. 

 

Business data is valuable. Data is wanted for the convenience it brings. And, data is needed for legal reporting requirements. We can’t just throw dirty data away. We must respect the body of knowledge.  

Read More »
November 23, 2015

Modification to Bulk Update the Parent Account: MSFT Dynamics CRM

No one enjoys opening up each record, one at a time, to update a field with the same value in your company’s CRM. This is why the bulk edit feature in Microsoft Dynamics CRM is such a great tool, especially if the field you need to update is a Lookup field. This ends up saving a bunch of clicks and ultimately, time. One thing I never really noticed though, is that while most fields can be edited there is one on the Account that stood alone. The Parent Account. Since I hadn’t had a need to ever update this field en masse myself it wasn’t until a client wanted to change the Parent Account on multiple records that I realized CRM has the lookup link grayed out. Meaning, Read More »

November 20, 2015

Connections between Dynamics GP and Excel

Dynamics GP interfaces with Excel in several different ways.  The most common ways are through built in functions like Smartlists, Excel Budgets, and Dynamics pre-defined Excel reports.  These are the base interfaces, but there are also several other methods to link GP data to Excel.  Some of the other ways are through an ODBC driver, a third party add-ons, an Excel connection, etc.  In this article, we will discuss the base methods as well as the Excel connection, as these are the quickest ways to get linked.

Read More »
November 19, 2015

Leverage Your GP Reports Outside of GP!

Did you know that Microsoft Dynamics GP comes with around 260 SQL reports ready to be used? These reports can be used right out of the box and they don’t require any modifications. Imagine if you could make these reports available to non-GP users; just put them on your company’s internal website; or build an iframe in CRM and display GP data inside CRM. Well, you can do all of this and more if you manage to get these reports out of GP. The way to do this is to deploy them to SQL Server Reporting Services.

Read More »
November 16, 2015

Learning How to Sell Business Applications

I’ve had years of experience in the consultative selling world of IT, hardware, software, and professional services. My clients are located in both the private commercial sector and public sector arenas. I recently switched to selling business applications, and although most of my knowledge transferred, there have been some new twists. 

Read More »
November 13, 2015

How to Copy Word Template Formats

When working with Dynamics-GP we often go to format an invoice and realize that the return document or the order document are essentially the same format.  We don’t want to have to spend the same time manually formatting the other documents when it would be easier to just copy the formats.

It isn’t as easy as just renaming the word template and importing it into GP; but it isn’t that hard as well.  Below, I have documented the steps in the scenario of creating the SOP Blank Return from an already formatted SOP Blank Invoice word template. 

Read More »
November 12, 2015