Management Reporter – Misspelled Account Categories


This would be second Management Reporter post in a row. This also is about the default reports and how to troubleshoot the issues pertaining to the default reports.

I have an Australian edition of GP installed. Most of the terminologies (such as “Fiscal/Financial”, “Realized/Realised”, etc) are localised in GP. However, default reports in Management Reporter still are in US English, if I am not wrong.

Consider the following default balance sheet row definition:

Screen Shot 2016-02-09 at 04.51.43 PM

I was wondering why balance on this account did not show up on the report. After several minutes, I realised that the account category was misspelled, compared to what’s there in GP. Notice that on the report definition it is “Amortization” with a ‘z’ and in GP it is “Amortisation” with a ‘s’.

After changing the categories with correct ones, by referring to GP, the report started showing the correct figures.

This post is relevant only if you reuse the default reports. It’s irrelevant otherwise.

Happy Reporting!

VAIDY

Management Reporter – This report view contains no data.


I have been working on a Management Reporter project, for which I wanted to install and configure MR2012 CU14 from the scratch.

Completed the server and client installation, completed the Configuration Console processes, imported data from GP2015R2 (sample company) and reached a point where I wanted to test the default reports.

Ran the report and got the following message:

Screen Shot 2016-02-10 at 09.44.58 AM

I checked everything, including the date range, data available in sample company and everything that I could remember. All were perfectly alright.

I was, however, getting some warning messages while the report was getting generated. Messages as follow:

Screen Shot 2016-02-10 at 09.47.43 AM

This one was familiar. When we install management reporter, we get default reports along with it. It’s a nice and easy way to get started with MR, learn the concepts. However, it comes with its own headaches.

To name one (also most important), each default report row definition would have link to both Dynamics AX and Dynamics GP financial dimensions. To a GP consultant’s dismay, AX dimensions link would be placed in a column before GP dimensions link, as shown below:

Screen Shot 2016-02-10 at 09.56.46 AM

Now let’s go back to the warning message. It says:

The row definition contains more than one financial dimensions link. Since the report does not use the row definition for reporting tree option, the report will use the *first* financial dimensions link to generate the report.

The first here being Microsoft Dynamics AX dimensions link. Thereby, rendering all reports with the message shown in the first screenshot on this post.

Alright, so I know the cause now. I know what I must do to get past this message. However, I had no clue HOW to do that. I mean, I know I must remove AX dimensions link column from the reports, but not sure how.

This community forum post answer from Sue tells us how to remove the link column. Too bad, this post was not marked as an answer.

I would, however, like to point to the standard & the easiest method to remove the unused link (in my case AX dimensions link).

  • Either you can go to the Edit menu and click on “Row Links” as shown below:

Screen Shot 2016-02-10 at 10.08.15 AM

  • Or you can also use the tool bar button for “Row Links” as shown below:

Screen Shot 2016-02-10 at 10.06.30 AM

Once you click on “Row Links” from either of the above steps, you should get the following window:

Screen Shot 2016-02-10 at 10.13.02 AM

Once deleted, your report definition would have only one dimensions link, i.e. to Microsoft Dynamics GP link.

Report would then show the data as expected.

Screen Shot 2016-02-10 at 10.16.26 AM

Of course, this would be the case if you want to reuse the default reports. This post would be irrelevant for those who design reports from the scratch.

Happy Reporting!

VAIDY

Analytics For Dynamics GP – BI Solution From Mark Polino (DynamicAccounting.Net) #MSDYNGP


Mark Polino of DynamicAccounting.Net has released first among series of Excel Dashboards, Sales Analytics Starter Edition, for Dynamics GP. This dashboard series is named as Analytics For Dynamics GP.

Sales Dashboard

Sales Starter Edition has got following charts with whole set of important filters:

  • Top Customers (with costs)
  • Top 10 Products (with costs)
  • Top 10 Salespeople
  • Top 10 Sales Territories
  • Top 10 Sites
  • Sales with Trend and Projection
  • Sales Mix with Item Class

It’s a simple plug and play kind of dashboard on Microsoft Excel (v2010 & v2013) file. Setting this up once you buy it is so very easy. How to map your GP data server is clearly explained as part of this dashboard solution. And you can modify this as you wish once you link this to your GP data server.

As it is just an Excel file with a straightforward GP data server connection, all you need to do is to click on refresh to get the real time information.

This sales dashboard starter edition is priced at $249 +$49 annual maintenance. Maintenance covers updates, improvements and fixes. Click on links provided across this post to visit Mark’s Analytics For Dynamics GP product page, learn more about this awesome BI solution and know how to buy your copy.

In my personal opinion, this is a simplistic and satisfactory BI solution which meet its promises pretty well.

VAIDY

Book Review: Microsoft Dynamics GP 2013 Reporting (Second Edition) – David Duncan & Chris Liley


My second book as reviewer is Microsoft Dynamics GP 2013 Reporting – Second Edition written by David Duncan and Chris Liley.

Snip20131206_19

This book is second edition to their famous Microsoft Dynamics GP 2010 Reporting. So those who have read this book before would see the new book as an upgrade. And that’s quite obvious as this book covers more on reporting features that are now part of Dynamics GP 2013.

The book is structured as follows:

  • Chapter 1: Meeting the Reporting Challenge
  • Chapter 2: Where Is My Data and How Do I Get It?
  • Chapter 3: Working with the Builders – SmartList and Excel Reports
  • Chapter 4: Report Writer and Word Templates
  • Chapter 5: Utilising the SSRS Report Library
  • Chapter 6: Designing Your Analysis Cubes for the Excel Environment
  • Chapter 7: Utilising Analysis Cubes for Excel for Dynamic Reporting
  • Chapter 8: Designing Financial Reports in Management Reporter
  • Chapter 9: Viewing Financial Reports in Management Reporter
  • Chapter 10: Bringing it all Together
  • Appendix: Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges

Chapter 1 discusses about challenges faced by a report developer and how to get prepared to meet them. If there is one thing that’s changing constantly at Dynamics GP front is how we visualise the data that is entered in GP day-to-day. Financial statements, revenue analyses, stock analyses, multi-dimensional analysis of your business and then there is big data which you might want to link with your own business. This chapter provides food for your thoughts on Reporting overall.

Chapter 2 discusses about how GP stores your data and how easily and efficiently you can access them. This one is, in my opinion, very crucial chapter for any GP report developer. Unless you know how GP is structured and how data is stored, you can never become a successful report developer. To quote the authors themselves: Knowing where to begin is a critical first step. This chapter shows us exactly that.

Chapter 3 discusses about SmartList Builder and Excel Reports Builder. Two most amazingly simple yet efficient tools to create any report. Excellent chapter again.

Chapter 4 discusses about Report Writer and Word Templates. Report Writer, in my opinion, is a very underestimated tool. I am sure David Musgrave would pat me to have said this. Knowing this tool would most definitely help any GP report developer to harness their knowledge on GP data and structure. Word Templates were introduced some time back and meant to be alternative to Report Writer reports. So knowing them also would be better.

Chapter 5 discusses about SSRS reports that come with GP. If your are a SQL developer and you are asked to develop some reports on GP, SSRS is THE best reporting tool. Know the data and you are on. Brilliantly written chapter.

Chapter 6 and 7 discusses about Analysis Cubes for GP. If you require multi-dimensional reports on GP data and want to know how to develop them, these chapters are for you.

Chapter 8 and 9 discusses about Management Reporter, the replacement of FRx, but much more an advanced technology. These two chapters take you step by step in understanding MR and how to design reports.

Chapter 10 summarises whatever been discussed on all previous chapters.

Appendix gives you a view of all reporting tools that are discussed in a simple yet informative table. And this book is certainly not complete without this table. Amazing piece of information one could ask for.

David and Chris have put their sincere and precious efforts on writing this book. Their expertise on reporting is going to be a guiding force through this book to all of us.

This book is published by Packt Publications. Those who would like to buy this book can do so by clicking on the link provided at the beginning of this post OR by clicking on the book logo.

To the authors, David & Chris: I thank you both for this great book and accepting me as one of the reviewers. It’s very difficult to talk about the greatness of this book in one single post, but I guess I have done my best. It’s going to be my reference on anything about GP reporting. Thanks again.

VAIDY

Report Writer Series – Custom Reports (Kuntz Consulting Inc.)


I had earlier posted about this ongoing series; not long back. To know what it is exactly, read it here: Report Writer Series.

The new post on this series discusses about how to create custom report writer reports.

VAIDY

Report Writer Series – Kuntz Consulting


Report Writer has been considered by most of the clients as static and bland reporting tool, due to it’s look & feel and it’s rigidity in terms of modifying the reports.

But, Report Writer is an amazing reporting tool, if only people know how it’s structured technically and how to bend it for our requirements. I am not certainly talking about customers. It’s the consultants’ responsibility to convince customers by demonstrating the power of Report Writer.

Over at Kuntz Consulting blog, series of posts are to be read to understand Report Writer as a tool and how to use it for our betterment. Following are the posts that are already been posted:

  1. Report Writer Demystified – Part 1 – Dictionaries & Launch Files
  2. Report Writer Demystified – Part 2 – Other Considerations
  3. Report Writer Series – Formatting Text
  4. Report Writer Series – Don’t Settle for Ugly Reports – Part 1
  5. Report Writer Series – Don’t Settle for Ugly Reports – Part 2
  6. Report Writer Series – Toolbox Tips
  7. Report Writer Series – Drawing Options Tips
  8. Report Writer Series – Sections

And it’s only going to get more on this series.

Worth reading for all those who would want to know about this silent performer, that is Report Writer.

VAIDY

Limiting Number of Records Per Page on a Crystal Report


There are several methods to achieve limiting number of records per page on a crystal report.

But this method, from a blogger named Pankaj Lalwani, seems to be very simple and effective. Check his post here: Limiting Number of Records to be Displayed on Crystal Report.

Version won’t matter in this case, since the solution what he proposes uses most common functions/operators, unless the latest version of crystal reports have an in-built settings for DETAILS section in Section Expert (which I doubt it would be).

VAIDY