Tag: KTL Solutions

How to create a Drop Point in PaperSave

A Drop Point in PaperSave is a method of capturing documents and sending them to a PaperSave workflow.   Each Drop Point can be associated to a single workflow, but a workflow may have several Drop Points.  The reason a workflow may have several Drop Points is to capture documents from different methods, such as Email, drag and drop, scan, etc.

Read More »

Upcoming Updates to SQL in 2016

Coming in 2016, the newest upgrades and features to SQL have developers everywhere speculating about the future. Microsoft has designed the 2016 release of SQL to be easy to use, traditional in application appearance and control, and most importantly data-secure. The most exciting new feature for SQL in 2016 is called Always Encrypted. Microsoft has created an extra layer of data security so that even when you are working with sensitive data such as social security numbers or credit card numbers, the data is secure. This ensures that even at the most vulnerable time for an attack, while data is being used, a person’s identity and company’s reputation are safe. The best part about this upgrade and its new features is that it will not hinder the performance of the application. 

Read More »

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 »