Get The Most Out of Your Fixed Assets Depreciation Ledger Reports
One of the modules in Dynamics GP that is often left unutilized is the Fixed Assets module. If there aren’t that many fixed assets to
July 6, 2017
Tag: Reports
Enhancing Our Inventory Reorder Point Analysis in Power BI
In my original Inventory Reorder Analysis report, I’m using some of the techniques discussed by Belinda Allen in her Inventory Item Reorder Dashboard. I converted
June 19, 2017
The Hidden Gems of Microsoft Project
I recently had the opportunity to take a great course on Microsoft Project. Having been a user of both the standard edition as well as
May 31, 2017
How to Use Power BI and ‘R’ to Quickly Identify Business Insights
In statistics, the correlation coefficient or Pearson’s correlation is a measure of the strength and direction of association that exists between two continuous variables. The
May 4, 2017
Reports on Apple Mobile Devices
According to Microsoft TechNet, accessing reports is not available through a mobile device such as a tablet or phone. “Using Microsoft Dynamics 365 on a
April 18, 2017
Crystal Reports vs SQL Server Reporting Services
I use SQL Server Reporting Services (SSRS) when I want to build reports. I have enjoyed working with it since I started tinkering around with
February 8, 2017
Setting up Security in Microsoft Dynamics GP
In this blog, I wanted to address the various aspects involved in Microsoft Dynamics GP security. There are several levels of security within Microsoft Dynamics
December 6, 2016
Compare Your Reporting Tools: Management Reporter, BI360, and Jet Reports
KTL Solutions wants to keep you in the loop! This is our
June 8, 2016
How to Set Default Parameters in SSRS Reports Based on CRM Roles
I enjoy working with SSRS reports and learning new things to help me build out reports that meet our clients’ needs. When a client comes to me with an interesting way they want something displayed or a request for a feature that is unknown to me, I jump at the chance to do it. I love a new challenge and it acts as a learning experience as well. A recent request came to me that required a little creativity on my part. It was to modify the default value of certain report parameters based on the security role the User had in CRM.
December 14, 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.
November 19, 2015
