Karelia Sotelo, Author at FMT

Tracking and Reporting Projects using Office 365 and Project Online

Did you know Office 365’s tools can make your PMO run more efficiently?

Read More
  1. Microsoft Dynamics GP

    Multi-Database Dynamic View for SSRS

    If you are one of those companies that have over 50 Microsoft Dynamics GP databases and would like to have an SSRS report that will dynamically loop into each, then this is the blog for you. I had a request from a client to create an SSRS report for all vendors on all Dynamics GP…

    Read More
  2. Microsoft Dynamics GP

    How to Create Yearly Comparative Reports in Microsoft Dynamics GP

      We receive a lot of requests from our clients to create yearly comparative reports and there aren’t any readily available in GP. I have created a custom SQL query that will look over your account balances for account history or auditing purposes.  It uses Microsoft SQL Server’s pivot query which is a really nice feature…

    Read More
  3. Microsoft Dynamics CRM

    Tracking Changes in On-Premise CRM 2011 Audit View using SQL

    Have you ever found yourself needing to track the changes you make to records in CRM, but feeling uncertain how to do so? If you are using the On-Premise version of CRM 2011, you can leverage the Audit view in SQL Management Studio to easily track your changes. For example, let’s say you needed to…

    Read More

The FMT Way

Optimizing your business processes—and achieving your goals—can be easier. With our team of experts, from designers to architects, you’ll gain the technology experience, dedication, and know-how that your business needs.

We’re here to inspire your greatness through technology.

Let's Start the Conversation