Microsoft Dynamics GP 2010 Reporting: Create and manage business reports with Dynamics GP

$65.99

4.5 (6 Ratings)

Paperback Apr 2011 360 pages 1st Edition

$65.99

Paperback Apr 2011 360 pages 1st Edition

What do you get with Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Preview Book

Key benefits

Identify the major reporting challenges facing your organization and select the most effective reporting tool to meet those challenges
Empower users from top to bottom in your organization to create their own reports
Go beyond basic reporting by providing true business intelligence for your organization
Discover how to use reporting tools to mine and analyze your Dynamics GP data for maximum competitive advantage
Explore new reporting features found only in Dynamics GP 2010
Employ real-life step-by-step examples in this part tutorial, part reference guide
A foreword by Errol Schoenfish, a member of the Microsoft Dynamics community for over 24 years

Description

Resources such as the book you now hold in your hand are critical to taking the extra step in uncovering the trends locked deep within your data. Not only will this book offer insight into the many reporting tools currently available for GP, it will also offer a unique perspective on how each reporting tool can be used to meet specific challenges faced by your organization" - Errol Schoenfish, a member of the Microsoft Dynamics community for over 24 years Microsoft Dynamics GP 2010 is a sophisticated Enterprise Resource Planning (ERP) system with a multitude of features and options. Microsoft Dynamics GP enables you to create and manage a variety of reports that help small and mid-size businesses effectively manage their financial and operational data. This book will show you how to create and manage reports, know what tools to use and when, how to use them and where to find the data based on how it's being entered into the system with Dynamics GP. This book will empower you with the tools and reports necessary to use Dynamics GP data in making key business decisions. The book addresses the many challenges and frustrations a company may face when preparing to build new reports. Then it moves on to explain how to find your data in the GP system and company databases. The book then dives deep into topics such as SmartLists, SL Builder and Excel Report Builder, Report Writer, SSRS Report Library, and Analysis Cubes Design and Management Reporter amongst others. With this knowledge in hand, you will be capable of selecting the most effective tool for the current reporting environment.

Who is this book for?

If you are a Microsoft Dynamics GP developer, consultant, or power user who wants to create and manage reports, then this book is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications such as Microsoft Excel and SQL Reporting Services is highly recommended.

What you will learn

Explore major reporting challenges faced by report writers
Understand how data is stored in Microsoft Dynamics GP
Utilize Excel and SmartLists Builders for basic GP reporting needs
Take advantage of the new Word Template functionality in Report Writer
Deploy and modify Dynamics GP SQL Reporting Services report library
Customize Analysis Cubes for Excel for improved ad hoc data analysis
Slice and dice Dynamics GP data with Excel Pivot Tables and Pivot Formulas
Design and create various building blocks for Management Reporter
Explore advanced concepts for delivering professional-quality financial statements
Identify the right tool for any Dynamics GP reporting need

Estimated delivery fee Deliver to United States

Economy delivery 10 - 13 business days

Free ~~$6.95~~

Premium delivery 6 - 9 business days

$21.95

(Includes tracking information)

Product Details

Publication date, Length, Edition, Language, ISBN-13

Publication date : Apr 26, 2011

Length: 360 pages

Edition : 1st

Language : English

ISBN-13 : 9781849682183

Vendor :

Microsoft

Category :

Business & Other

Languages :

Concepts :

Enterprise Resource Planning

Tools :

SQL Server

What do you get with Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Frequently bought together

$65.99

Microsoft Dynamics GP 2010 Implementation

$65.99

$65.99

Total $ 197.97

FAQs

What is the digital copy I get with my Print order?

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

What is custom duty/charge?

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order?

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges?

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.

How can I cancel my order?

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy?

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged?

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use?

You can pay with the following card types:

Visa Debit
Visa Credit
MasterCard
PayPal

What is the delivery time and cost of print books?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

Filter reviews by

All

Amazon verified reviews

Amazon Customer May 17, 2011

I just finished my first trip through this new book on GP 2010 reporting and all I can say is - incredible. This work, written by David Duncan and Christopher Liley of IBIS and reviewed by my dear friends Amy Walsh and Christine Belding, also of IBIS, provides an extremely well thought-out, well written, thorough look at the state of the art in reporting in GP 2010.The book not only covers all the reporting options available in GP 2010 but also provides a framework for developing a cohesive reporting strategy for your organization.From SmartList to Report Writer, from Excel Report Builder to Management Reporter, Microsoft Dynamics GP 2010 Reporting provides an overview of all of the report types, plus technical instruction on how to use and get the most of each of the report development tools.Whether you're a GP report developer or a GP user who's curious about the myriad reporting options now provided in the application, this book needs to be in your library. I highly recommend it.

Amazon Verified review

Mark Polino May 03, 2011

This is a phenomenal book. Chris and David have created a fantastic resource for reporting inside of Dynamics GP. If you use any version of Dynamics GP, buy this book. The book includes coverage of base reporting, SSRS, Excel reports, analysis cubes and more. I'm still not sure how they crammed it all into one volumne.

Marcia N. Doron Jun 28, 2011

By Marcia Nita Doron, Altico AdvisorsThis review is for: Microsoft Dynamics GP 2010 Reporting (Paperback)Full Disclosure: I was provided a no-charge paperback edition for the purpose of this review by the publisher, Packt.What piqued my interest in the first place was actually the fact that Errol Schoenfish, a monument in the Microsoft Dynamics community, wrote the foreword. And of course, Errol made a few great points, the most salient of which is that raw data is "useless" unless it can be analyzed and turned into meaningful reports on the health of a business through trend analyses and key performance indicators (KPIs).This book addresses the fundamental question of how to turn raw data into meaningful metrics using the reporting tools available in Microsoft Dynamics GP 2010. And it addresses that question in great detail, in a highly organized framework, replete with numerous, incredibly useful screenshots. It starts with the basics of "Meeting the Reporting Challenge" and "Where Is My Data and How Do I Get to It?" And it takes you all the way through the design and execution of sophisticated reports using the various tools available in Dynamics GP 2010, such as SmartList Builder (SLB), Excel Report Builder (ERB), Report Writer (RW), SQL Server Reporting Services (SSRS), Analysis Cubes (AC), and Management Reporter (MR).What's more, the Appendix at the end of the book compares those tools and outlines the features and functions of each. The Appendix serves as a quick, high level reference guide.Kudos to the authors for a tremendous effort and a valuable resource for skilled end users and Dynamics GP professionals alike.June 28, 2011

Constance Quigley Jul 01, 2011

First, I must express my utmost respect for anyone who undertakes a task this daunting. The subject matter is dense, and the tools are ever-changing. Kudos to these consultants for taking the time to create a handy guide like this!To many new users of Dynamics GP, the variety of tools that accompanies the ERP system is overwhelming. There are built-in or "canned" reports that can be modified, smartlists which can export data to Excel, and FRx or Management Reporter for creating standard financial reports. The latest versions of Dynamics also offer collections of Excel Reports and SQL Reporting Services (SRS) reports which can be deployed and used right away. In addition to all of this fare, a customer may purchase Smartlist Builder and Excel Report Builder, both of which further extend the capability of smartlists and Excel reporting to all areas of the system as well as external data sources. And we can't forget Analysis Cubes for Excel, which is essentially the height of business intelligence for the Dynamics end user. Essentially, data analysis and reporting tools for Dynamics GP have flourished over the past few years, and this book offers an excellent synopsis and technical comparison of the various tools available.While it is geared toward power users and data analysts, the book does offer some valuable information to anyone who wishes to learn more about the multitude of reporting options out there. The authors start out with a helpful discussion about the challenges of developing reports: defining the target audience, locating the appropriate data, selecting a form of presentation, and applying permissions to the final product. They then dedicate a full chapter (sometimes two) to each tool and provide some guidance on installation, deployment, security, and usage. The final chapter Bringing It All Together offers an in-depth comparison of the various tools and discusses the trade-offs among them in terms of data sources, latency, ease of formatting, and required development and IT resources.As a software consultant, I found this book very useful. It is very well-organized and the examples provided are a great way to introduce a power user to the strengths and weaknesses of each tool. Most importantly, the authors are enthusiastic about the wealth of reporting resources available and how each one can be used to improve visibility into an organization's financial and operational health, which is really the fundamental point of an ERP system. The book imparts enough information to inspire you to explore each tool by actually using it, which is the best method of learning!

Ghislain Jun 26, 2012

This is a good book that allow you to find your way in GP. It explain the structure of the data in GP who is a little challenging. It then show you how to use the different reporting tools in GP to create report.

Microsoft Dynamics GP 2010 Reporting: Create and manage business reports with Dynamics GP

What do you get with Print?