Tag: KTL Solutions

Visualizing your Financial Statement with a Waterfall Chart

In July, Microsoft introduced six new chart types that will be available as part of Office 2016. Today, I’m will show you how to take advantage of the waterfall chart, one of the most popular visualization tools used in small and large businesses by modifying Dynamics GP’s Excel Financial Dashboard with Excel 2016 to add a Waterfall chart.  A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values and is very useful in analyzing an income statement.  

Read More »

The Benefits of CRM Systems and Microsoft Dynamics CRM improved Integration with Outlook

My question to you is; why wouldn’t you be using a CRM system?

CRM’s refer to allons between a business and its customers.  CRM systems not only help manage your business and relationships with clients it also provides s number of important benefits to both small and large companies including increasing revenue and decreasing costs.  What business or business owner wouldn’t want to do that?

Read More »

Pros and Cons of the different implementation strategies

The 3 main implementation strategies that I have used over the years have been:

  1. Parallel Run
  2. Big Bang
  3. Phased Approach

Proactively evaluating and selecting the appropriate ERP implementation strategy that fits your business and your individual risk tolerance is vitally important and is as much an early decision gate as it is to select the correct ERP solution for your business.

Read More »

How to Renew an SSL Certificate for CRM on ADFS 3.0

If you are using an Internet Facing Deployment for your CRM there is always that time every 1, 3, or X years where you receive the message to renew your SSL Certificate. With ADFS 3.0 no longer dependent on IIS like its previous version were it changes the process a little bit. It is not very difficult to do but it took me a little research to piece together all the steps in the right order. I wanted to share this information so that the process goes as smooth as possible and you aren’t stuck with your environment being down as you scramble to figure out how to get the CRM and ADFS applications working together again.

You will first want to remove the old certificate from the ADFS and CRM servers. If the certificate is not removed then this will cause problems later down the line.

Read More »

Why Are ERP Systems Sticky?

Congratulations! You are the executive chosen to spearhead the effort to select and implement a new ERP system to replace the one that your organization originally installed a number of years ago. As you plan for this project, you may find it helpful to know what others in your position have experienced so you know what to anticipate and can craft a better plan to unstick the existing ERP system. 

Read More »

Power BI- Empower the User Conference Recap

This year at KTL’s empower the User Conference one of the hottest topics was Microsoft’s Power BI. No surprise here after it was one of the most popular categories at Microsoft Dynamic’s Convergence back in March. 

For those who haven’t heard of Power BI before here is a short synopsis. Power BI is an excel add-in tool made up of 4 components: Power Pivot, Power Query, Power View, and Power Map. Power Pivot and Query are used for data preparation while power view and map are used for data visualization. These tools can take large amounts of data from virtually any system and harness it for real-time, powerful analytics. One of the huge differentiators of Power BI from other analytics tools is that you can combine resources from multiple data centers. Typically, when people want to see the profitability of an organization they look at the financial data. However, this is not always the only factor, especially in today’s world that is driven by technology and social media. 

Read More »

Uploading Vendors into Acumatica ERP

One of the most difficult decisions that has to be made during a new system implementation is how much and what kind of data to migrate from your old system to the new. How many years do we bring over? Do we bring over detailed or summarized data? Is it reconciled? Will we have access to old system for historical reporting purposes? These are all questions that are posed and answers that are debated during the process of making the decision.

Read More »

Strategies to keep your CRM data clean

With most CRM systems or for that matter any enterprise systems we often hear this saying “Garbage in Garbage out” about the data that resides in these systems. The reality is that most systems do have garbage data and each organization uses different methods to maintain/scrub/cleanse their data. Some organizations use a data warehouse where data is synced from different sources and normalized, the data warehouse is used as the master data source for all reporting and transactional data still remains in the same state. In another situation an ERP would be the source for the master data and all other systems like CRM would sync and integrate with the ERP data. But each system has its users and they too would like to maintain good data. In a modern system like Dynamics CRM, it provides a lot of methods to maintain your data. The following methods can be deployed to keep you data clean:- 

Read More »