Reporting Solutions

Dynamics GP SSRS Report Deployment Problems

Posted by Brandon Richards, Implementation Manager on August 9, 2017

If you’re trying to deploy SQL Server Reporting Services Reports (SSRS) and it keeps failing, saying you don’t have permission, it might be because you have SQL Express.   Dynamics GP Error Message:  You do not have security access to the location where you want…

Read More

Divide by 0 Error in FRx

Posted by Tiffany Bennett, Senior Consultant on August 8, 2017

Have you ever gotten the “Divide by 0 Error” when you go to run a report in FRx Report Designer?  And to top if off, then the report does not print.  Other users can print FRx reports just fine, but for you, it happens on all reports.…

Read More

Missing Management Reporter Report Options

Posted by Misty Galbreth, Support Analyst on July 19, 2017

Setting Your Default Company in Management Reporter (MR) The first time you login into Management Reporter Designer as a new user, or the first time you login after an upgrade, you may notice that you are missing all of your report options on the left hand side.  You might…

Read More

Management Reporter Headers in Excel

Posted by Misty Galbreth, Support Analyst on July 17, 2017

Have you ever noticed that when you download Management Reporter (MR) reports into Excel, the headers don’t show up at all in the Normal View, or the headers only show up in the Page Layout View?  If the Page Layout View in Excel is not to your…

Read More

Change Your Debit/Credit SmartList Default Display Order in Dynamics GP

Posted by Misty Galbreth, Support Analyst on July 11, 2017

One of my personal frustrations when I started working with SmartLists in  Microsoft Dynamics GP, was the fact that on every report using debits and credits, they were ‘backwards’ from how I was used to seeing them.  In my mind, debits always came first and credits…

Read More

Dynamics SL: Time-Saving Report Templates

Posted by Michael Broadmeadow, Senior Support Analyst on April 26, 2017

Creating a New Report Template from an Existing Template and How-to Delete a Report Template In Microsoft Dynamics SL, report templates are valuable time-saving features.  We use report templates as a starting tool when creating similar type of reports.  That way, we can reuse our parameters to run…

Read More

Management Reporter Releases CU16 – What Else is Out There?

Posted by Mary Lenehan, Client Account Manager on March 1, 2017

Many Dynamics SL users have been confused by Microsoft’s messaging around Management Reporter (MR). Here's a question I've heard a few times lately: "I'm planning my Dynamics SL 2015 upgrade from Dynamics SL 2011, is it worth migrating to MR if it&rsquo…

Read More

Date Format Formulas for Acumatica ARM

Posted by Tiffany Bennett, Senior Consultant on January 18, 2017

Some of the most common reporting questions I receive are around formatting dates.  All date formats are controlled by formulas entered in the Column Set.  You just need to enter them as their own line in the Header Section.  Here are some tips to get you…

Read More

Reporting from Dynamics CRM Online: An Introduction to FetchXML Part 2

Posted by Mike Giuffre on November 14, 2016

In Part 1 of Reporting from Dynamics CRM Online: An Introduction to FetchXML, I explained how important your Advanced Find is for creating your FetchXML SQL Report.  To quickly recap, FetchXML is a way to bring data from Dynamics CRM Online into a SQL Report.  Hopefully you’re…

Read More

Get More Power from Your Acumatica Reports

Posted by Tiffany Bennett, Senior Consultant on November 8, 2016

Statistical Reporting with Acumatica Analytical Report Manager (ARM) Many clients we work with like to track statistical data in combination with their financial information.  This can be a powerful tool for management to track many business measures.  These statistical items can be tracked in a ledger, just like…

Read More