Tag: Dynamics

Third-Party Phobia

If you have ever attended Microsoft Convergence (may it rest in peace) and have walked the expo hall, then you are aware of the hundreds, even thousands of add-on products to Microsoft Dynamics. Any industry, any problem – there’s a product for it. However, some people are still against the idea of using third-party products. Why is that? Here are some third-party phobic myths I hear often.

Read More »

User Conference 2016: The ERP Track Remains Fully Loaded



KTL Solutions celebrated their 11th annual Empower the User Conference on May 19th at the Microsoft Center in Reston, Va.  This year, as in year’s past, KTL brought 3 unique tracks to the event allowing users to customize their own experience and gain the knowledge they deemed the most valuable.  However, we understand that not everyone could make it to all of their sessions. Below is a breakdown of what you may have missed from the ERP Track at UC 2016.

Read More »

CRM ISV Spotlight: Dynamics CRM 2016 Workflow Tools

Dynamics CRM has come a long way to become an established, and at the same time an evolving platform. There are several ISV solutions that have extended Dynamics CRM beyond a traditional CRM and provided many vertical solutions. One of the ISV solutions I would like to highlight today is “Dynamics CRM 2016 Workflow Tools” by demian_rasko on CodePlex. Like a lot of CRM add-on solutions on CodePlex, this one provides additional functionality at the CRM platform level; and the best part – it is free. This solution is available for Dynamics CRM On-Premises and Dynamics CRM Online, as well as a managed solution. Besides all these benefits, the source code behind this solution is open source, so if you are a developer then you can certainly extend it further to your requirements and add/contribute to this community.

Read More »

Microsoft Project Madeira

Microsoft recently released the preview of a new Software as a service (SAS) accounting system. This is their first pure SAS delivered system. I decided to take a look at it to evaluate the features available in this system.

For those of you that don’t know, Microsoft has been diving into the lower end of the accounting system going all the way back to when Great Plains designed Microsoft Profit. There has been a fascination with Microsoft to compete with QuickBooks and compete in that market space.

Read More »

Save a Tree: Tools to Go Paperless

It is almost that time of year again for KTL Solutions to host its annual Mid-Atlantic Technology User Conference, “Empower the User”.  This will be our eleventh annual user conference and it will be held on May 19, 2016, at the Microsoft Center in Reston, Virginia.  In past user conferences, we have found many users have benefited greatly from the topics presented and have been able to immediately apply some of the information obtained when they returned to their offices.

Read More »

Dear Diary, Why Don’t My Customers Want to Talk to Me?

In today’s tech driven world, human interaction is dwindling more and more. You see it everywhere! People sitting at dinner, staring at their phones; kids walking with headphones on while they look at the ground; professionals sitting in coffee shops with their phone, tablet, and laptop all at their fingertips. One thing is becoming very clear, we want to be empowered by technology and not have to rely on human interaction to get our information. 

Read More »

Prelude to KTL UC 2016 – Benefits of Moving to CRM Online

In the upcoming KTL User Conference 2016, we will have a session on the benefits of moving to CRM Online. You will get all the details on the ease of the move, plus details on the additional features you will get just by choosing CRM Online. As I type this blog, Microsoft has already released the preview guide for what’s coming as an update to CRM in Spring 2016.

Read More »

Best Practice for Building CRM Queries in an SSRS Custom Report

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

When writing a custom SSRS report for CRM, one of the greatest features is the ability to include pre-filtering in your reports.  By adding the CRMAF_ prefix to the alias assigned to the table you are querying, it will pass your selected CRM records as the context for your report. E.g.:

SELECT * FROM FilteredAccount AS CRMAF_Account

Read More »

Using MS CRM “IPluginExecutionContext” to Tackle Business Needs: A 3 Part Series

The “IPluginExecutionContext” contains a property called “MessageName.” This is the name of the message that was called to perform the action. Here is a link to a list of messages: https://msdn.microsoft.com/en-us/library/gg309482.aspx .   I couldn’t find my original source for this, so you can assume that each message name is just the class name listed without the request at the end. The one we are interested in is the “ConvertQuotetoSalesOrderRequest” or the “ConvertQuoteToSalesOrder” message. This is what is called when you click the “Create Order” button and can be called through the API as well. So to figure out if that is what is creating our sales order we would simply need to traverse the parent context list and check to see if the “MessageName” property equals “ConvertQuoteToSalesOrder”. Here is a code snippet to do that. 

Read More »