My second book as reviewer is Microsoft Dynamics GP 2013 Reporting – Second Edition written by David Duncan and Chris Liley.
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.