Management Reporter Error Opening Column Definition

Microsoft Dynamics GPDuring a recent upgrade of a client from Microsoft Dynamics GP 2010 to Microsoft Dynamics GP 2013 we also did a migration of FRx to Management Reporter.

After doing the test upgrade and migration I tested Management Reporter and everything was working fine. However, a month later when I was back on site for the live upgrade and some additional training, I found that Management Reporter was no longer working correctly.

When I tried to open a column definition I received an error:

Management Reporter: The operation could not be completed due to a problem in the data provider framework.Management Reporter: The operation could not be completed due to a problem in the data provider framework.

Continue reading

Management Reporter ‘Bad or missing data…’ error

Microsoft Dynamics GPI’ve had this post in my queue for a while after it got overlooked, but I figure it is still worth posting.

We received a call on the service desk from a client who was having problems with Management Reporter; whenever they tried to generate a report they received the following error:

Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled.Bad or missing data was encountered while loading the report and its building blocks. Report generation has been cancelled.

Continue reading

MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer

The Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The twenty-first Feature of the Day covered is Management Reporter Web Viewer. In the previous versions of Management Reporter 2012, the desktop Report Viewer was the only way that a report could be generated.

This new feature allows reports to be generated from within the Web Viewer by users who are in the Administrator, Designer or Generator roles. Going back and forth between applications can be cumbersome, by staying in the web viewer, accounting managers and staff accountants can get the most to date information faster.

This option refreshes the data in the report, using the original Base Period and Year and will only be visible to the user who refreshes the report.

This feature is targeted at the following roles:

  1. Accounting Manager
  2. Staff Accountant

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

Microsoft Dynamics GP 2013 R2 Feature of the Day
MDGP 2013 R2 Feature of the Day: SmartList Designer Go To's
MDGP 2013 R2 Feature of the Day: Identity Management - Login
MDGP 2013 R2 Feature of the Day: Purchase Requisitions
MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry
MDGP 2013 R2 Feature of the Day: Workflow
MDGP 2013 R2 Feature of the Day: Workflow Types
MDGP 2013 R2 Feature of the Day: Workflow User Delegation
MDGP 2013 R2 Feature of the Day: Default Fixed Asset ID From The Asset Class
MDGP 2013 R2 Feature of the Day: Identity Management - Scalability Groups
MDGP 2013 R2 Feature of the Day: Workflow Calendar
MDGP 2013 R2 Feature of the Day: Reprint Outstanding Transaction in Bank Reconciliation
MDGP 2013 R2 Feature of the Day: Requisition Management Integration Points
MDGP 2013 R2 Feature of the Day: Default Sort Order for Checks
MDGP 2013 R2 Feature of the Day: Document Attach - Scan
MDGP 2013 R2 Feature of the Day: Workflow History
MDGP 2013 R2 Feature of the Day: Workflow Email Notifications
MDGP 2013 R2 Feature of the Day: Azure Backups
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Analysis and Assignment
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements - Sales Script and Additional Information
MDGP 2013 R2 Feature of the Day: Dashboards
MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer
MDGP 2013 R2 Feature of the Day: Take Company Offline
MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports
MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format
MDGP 2013 R2 Feature of the Day: Reverse Year End Close
MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions
MDGP 2013 R2 Feature of the Day: Roll Down Segment Changes
MDGP 2013 R2 Feature of the Day: Assign An Item To Multiple Sites
MDGP 2013 R2 Feature of the Day: Replace OLE Note With Document Attachment
MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility
MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions
MDGP 2013 R2 Feature of the Day: Print Remaining Documents
MDGP 2013 R2 Feature of the Day: Email By Document Type

Management Reporter 2012 CU9 Released

I often seem to be busy when a new version of Microsoft Dynamics GP or one of the related products, such as Management Reporter, is released. And it has happened again.

On the 12th May when I was leaving for a weeks holiday in Scotland, a new cumulative update, CU9, for Management Reporter 2012 was released with the announcement made on the Dynamics Financial Reporting blog with the download available here.

This release contains enhancements to the Management Reporter Web Viewer around opening and refreshing reports along with additional troubleshooting information in the Configuration Console related to data issues in the ERP.

In brief, Cumulative Update 9 includes the following:

  • View a list of previous month’s reports and open them in the web viewer
  • Refresh a report in the web viewer
  • Publish a report from the web viewer
  • Headers and footers are shown by default in the web viewer
  • Enhanced data detection in the Configuration Console
  • Support for dynamically displaying currency symbol, currency code and currency description
  • Support for SQL Server 2014
  • Additional fixes for product defects

Management Reporter 2012 CU8 Now Available

The Dynamics Financial Reporting blog today announced the release of Management reporter 2012 CU8.

Full details can be found at the link above, but here’s a quick summary of some of the new features:

  • Dynamic calculated column headers…no more hard coding of Months within the column definition
  • Currency translation for Dynamics GP 2013 using DDM Data Mart provider
  • Ability to create a side by side balance sheet by using a section break option in row definition
  • Option to include line numbers on generated reports
  • Ability to set all columns in definition to Autofit by default
  • Collection of Excel formatting improvements

Management Reporter 2012 CU8 can be downloaded from here for the US and all other countries here (CustomerSource or ParnerSource login required).

Microsoft Dynamics GP 2013 Reporting – Second Edition eBook Giveaway

I am pleased to announce that I have teamed up with Packt Publishing and are organizing a give away especially for you. All you need to do is submit a comment below the post and win a free e-copy of Microsoft Dynamics GP 2013 Reporting – Second Edition by David Duncan and Christopher J Liley. Five lucky winners stand a chance to win an e-copy of the book.

Keep reading to find out how you can be one of the Lucky Ones.

Continue reading

Management Reporter Period 13 Is Not Valid For Company

This 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

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

I 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

Management Reporter Login Error

I thought I had posted this a while ago, but searching my blog I can’t find it. A client contacted me recently to report the following error message:

Management Reporter - CanManagement Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?

My first step was to try running Management Reporter myself and was able to log in without a problem'; this was on the same Citrix server the client had been trying to log into which ruled it out as being a problem with the Management Reporter services.

The client in question was a member of their internal IT department and had his own Domain account and access to a global Domain administrator account. It was his own Domain account which he had logged into the server with, but this user was not in Management Reporter; it had been configured using the global Domain Admin account to minimise the number of licenses assigned to IT (the client is running Microsoft Dynamics GP 2010).

Once he logged in with the global Domain Admin account he was able to access Management Reporter without any further issues.

Microsoft Dynamics GP 2013 Reporting – Review Incoming

I have received a copy of Microsoft Dynamics GP 2013 Reporting to review which I will be doing over the next couple of weeks.

This is an update to the previous edition of the book for Microsoft Dynamics GP 2010, but this one is for the current version:

Microsoft Dynamics GP 2013 Reporting

I’ll be giving it a thorough read and, setting aside my distaste for reporting outside of Management Reporter, I may even follow some of the examples and post a detailed account.

If you don’t want to wait for my review of the book, it can be bought now from Packt Publishing.