Implementing Jet Enterprise: Series Index

Jet ReportsThis post is part of a series of posts on Jet Reports. As I said in the series index for the overall series on Implementing jet Reports, I am doing sub-series for each of the versions of Jet Reports.

This is the series index for implementing Jet Professional which is the top tier of the software and suitable for businesses with more complex financial and non-financial reporting requirements. It also allows the creation of dashboards and plugging in of other software into the cubes for reporting; this includes PowerBI and other BI software.

Continue reading “Implementing Jet Enterprise: Series Index”

Implementing Jet Professional: Series Index

Jet ReportsThis post is part of a series of posts on Jet Reports. As I said in the series index for the overall series on Implementing jet Reports, I am doing sub-series for each of the versions of Jet Reports.

This is the series index for implementing Jet Professional which is the middle tier of the software and suitable for businesses with more complex financial and non-financial reporting requirements.

Continue reading “Implementing Jet Professional: Series Index”

Implementing Jet Express: Series Index

Jet ReportsThis post is part of a series of posts on Jet Reports. As I said in the series index for the overall series on Implementing jet Reports, I am doing subseries for each of the versions of Jet Reports.

This is the series index for implementing Jet Express which is the lowest tier of the software and suitable for smaller business with simple reporting requirements.

Continue reading “Implementing Jet Express: Series Index”

Management Reporter 2012 CU15 Is Now Available

Microsoft Dynamics GPThe Dynamics Financial Reporting for Microsoft Dynamics GP has announced the availability of CU15 for Management Reporter 2012. This cumulative up-date contains a few bug fixes as well as some enhancements.

Here’s a summary of the new Management Reporter CU15 features:

  • Improved responsiveness in the Web Viewer.
  • A search bar has been added to search through the current level of the report as in-browser search functions may not always return all results because of the performance changes to improve responsiveness.
  • Printing in the Web Viewer through XPS download.
  • PowerShell module to enable reset of data mart.
  • Added a Turkish (tr-tr) localization.
  • Additional fixes for product defects.

The Dynamics Financial Reporting for Microsoft Dynamics GP team will be blogging about the new features in detail soon.

There are a few new prerequisites which are required for this cumulative update:

  • SQL Server 2012 or higher.
  • Microsoft .NET Framework 4.6.1 is also required (when installed this may require a reboot).

Management Reporter CU15 Release is version 2.12.15000.56; make sure your ERP version is supported by checking the compatibility list.

The EN-US download for Management Reporter CU15 is here and localised versions will be coming soon.

General Ledger Summary Trial Balance Returning Incorrect Data

Microsoft Dynamics GPWe are currently in the process of upgrading a large 20 site client from Microsoft Dynamics GP 9 to a later version (unfortunately not 2015 due to third party add-ons which are not supported on this version). The client previously had standalone implementations at each site, but we are aggregating them into one implementation for ease of maintenance and also to reduce licensing costs.

The first few we centralised went fine, but we then ran into problems when we did the head office companies. When they ran the GL Summary TB on the old and new systems there was a mismatch between them.

After investigating, the support team established that the problem was down to some corruption in the Account Index Master table (GL00105) where some of the accounts had segments separated with dots instead of dashes as defined in Account Format Setup (Administration area page » Setup » Company » Account Format).

The solution they followed was fairly simple, and in three steps:

  1. Run a script to clear the Account Index Master table:
    DELETE FROM GL00105
  2. Run Check Links (Microsoft Dynamics GP menu » Maintenance » Check Links) on Account Master.
  3. Run the General Ledger Reconcile utility (Financials area page » Utilities » Reconcile) on all years starting with the oldest and working forward.

After this was done, the report produced from the upgraded system matched the old one.

MDGP 2015 Feature of the Day: Management Reporter Data Integration

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirty third Feature of the Day is Management Reporter Data Integration. In Microsoft Dynamics GP 2015, the user can determine the data that is available to the Microsoft Dynamics Management Reporter DataMart, improving the performance and giving the user control over the data selected.

The user can choose per company (including sample company) if they want the General Ledger data available for reporting.

The user also has the ability to include or exclude Analytical Accounting data for each company:

Company Setup Options

I am slightly puzzled by this feature of the day as you can simply not import a company into Management Reporter if you don;t want to report on it. While I steer clients away from AA where possible, I am not entirely opposed to it, but I do wonder who would want to report on AA without also wanting to be able to report on the GL.

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: Management Reporter in Business Analyzer

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty sixth Feature of the Day is Management Reporter in Business Analyzer.This features enables users to add Management Reporter content to the Microsoft Dynamics Business Analyzer app:

Companion Application Services Configurator

Continue reading “MDGP 2015 Feature of the Day: Management Reporter in Business Analyzer”

MDGP 2015 Feature of the Day: Management Reporter Integration Setup

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twenty fifth Feature of the Day is Management Reporter Integration Setup. This feature created a new navigation list for accessing Management Reporter reports from within the Financial and Administration Navigation buttons.

The Management Reporter navigation list becomes enabled once the location of the Management Reporter service is defined in the Reporting Tools Setup window:

Reporting Tools Setup

The location of the Report Designer Application is an optional field and when defined, will enable users to launch the designer from the Management Reporter navigation list if they have permissions to application.

The navigation list displays a list of reports the current user has security access to and enables them to view the reports in the Management Reporter Viewer with just a click of a button.

The roles targeted by this feature are:

  • All

Click to show/hide MDGP 2015 Feature of the Day Series Index

Management Reporter Period 13 Is Not Valid For Company

Microsoft Dynamics GPThis is an issue I came across a few months ago and misplaced my screenshots. Having just stumbled across them on my test Hyper-V server I decided it is still worth posting about.

I was doing some testing on a system with multiple companies created and was looking at a report consolidating figures from all of them into one report. When the report was generated it failed and gave the error message below for several of the companies in the Report Queue Status window:

Period 13 for fiscal year 2013 is not valid for company <company name>. No data will be returned for this company.
Period 13 for fiscal year 2013 is not valid for company <company name>. No data will be returned for this company.

I checked the Fiscal Period Setup in Microsoft Dynamics GP for all reported companies and all of them had the same period 13 defined. Management Reporter, as well as reporting errors in the Report Queue Status window, logs errors in the Windows Event Viewer.

Continue reading “Management Reporter Period 13 Is Not Valid For Company”

Review of Microsoft Dynamics GP 2013 Reporting by David Duncan and Christopher J Liley

Microsoft Dynamics GPI have received a copy of the newly published Microsoft Dynamics GP 2013 Reporting, by David Duncan and Chrisopher J Liley, from Packt Publishing to review. This is an update of a previous book the pair wrote for Microsoft Dynamics GP 2010:

Microsoft Dynamics GP 2013 Reporting

The book covers an extensive range of the reporting tools in, or available with, Microsoft Dynamics GP 2013:

  • SmartList Builder including Excel Report Builder
  • Report Writer and Word Templates
  • Reporting Services Reports
  • Analysis Cubes
  • Management Reporter

Continue reading “Review of Microsoft Dynamics GP 2013 Reporting by David Duncan and Christopher J Liley”