Key Features
Book Description
If you're a GP user, this book is aimed at making your job easier. How? Through the use of Business Intelligence (BI) provided by your Microsoft Dynamics GP software to aid you in making informed decisions. This book assumes no previous experience; however, a basic knowledge of Excel is expected.What you will learn
- Learn where and how to deploy an SQL View
- Create PivotTables and PivotCharts using Excel
- Design PowerViews in Excel
- Use PowerPivot and PowerQuery in Excel for large data sets
- Manage Receivables better through the use of Business Intelligence
- Develop custom reports for your Microsoft Dynamics GP data
- Manage products using Inventory Control and BI
- Master how to use Excel Slicers, PivotTables, PivotCharts, PivotViews, Excel tables, Data Connections, and other Excel features
Who this book is for
Table of Contents
- What is BI and what are BI Tools for Microsoft Dynamics GP
- The General Ledger Holds It All
- Business Intelligence for Bank Reconciliation
- Making Money by Paying Bills in Payables Management
- Collect What Is Owed in Receivables Management
- SOP Sales at Your Mouse Click! (Sales Order Processing)
- Managing SOP just got easier (Sales Order Processing)
- Managing your Inventory (Control)
- Inventory (Control) with a boomerang effect
- Gain Control of Your Spending with Purchase Order Processing (POP)
- Payroll, Commissions and More oh my
Loading...
Loading...
