Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Real-world Business Intelligence with Microsoft Dynamics GP
  • Toc
  • feedback
Real-world Business Intelligence with Microsoft Dynamics GP

Real-world Business Intelligence with Microsoft Dynamics GP

By : Belinda Allen, Polino
5 (1)
close
Real-world Business Intelligence with Microsoft Dynamics GP

Real-world Business Intelligence with Microsoft Dynamics GP

5 (1)
By: Belinda Allen, Polino

Overview of this book

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.
Table of Contents (13 chapters)
close
close
Preface
Preface
Question
Answer
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
1. What Is BI and What Are BI Tools for Microsoft Dynamics GP?
1. What Is BI and What Are BI Tools for Microsoft Dynamics GP?
What is BI and how do I get it?
Out-of-the-box BI tools for Microsoft Dynamics GP
Summary
2
2. Business Intelligence for the General Ledger
2. Business Intelligence for the General Ledger
Balance sheet dashboard
Ratio of AP to AR
Summary
3
3. Business Intelligence for Bank Reconciliation
3. Business Intelligence for Bank Reconciliation
Bank balances with the last reconciliation date
Where the money goes
Summary
4
4. Business Intelligence for Payables Management
4. Business Intelligence for Payables Management
Unapplied credits/payments, invoices on hold, and vendor holds
Sharable aged trial balance
Summary
5
5. Business Intelligence for Receivables Management
chevron up
5. Business Intelligence for Receivables Management
Sharable aged trial balance
Customer sales this year compared to last year
Summary
6
6. Business Intelligence for Sales Order Processing
6. Business Intelligence for Sales Order Processing
Dashboard of sales by customer, state, item class, and salesperson
Dashboard of open orders by customer, state, item class, and salesperson
Items sold by the manufacturer
Summary
7
7. More Business Intelligence on Sales Order Processing
7. More Business Intelligence on Sales Order Processing
SOP documents on process holds
Items shipped within the last 30 days with tracking numbers
Returned items report
Summary
8
8. Business Intelligence for Inventory Control
8. Business Intelligence for Inventory Control
Rolling 12-month turnover report
Items on which you most frequently adjust quantities
Summary
9
9. More Business Intelligence for Inventory Control
9. More Business Intelligence for Inventory Control
Top 10 most invoiced and returned items
Items with quantities that are not available to sell and items that have not been sold within the last year
Summary
10
10. Business Intelligence for Purchase Order Processing
10. Business Intelligence for Purchase Order Processing
Purchase orders awaiting approval
Open purchase orders older than 45 days
Summary
11
11. Miscellaneous Business Intelligence
11. Miscellaneous Business Intelligence
Employee list with personal details by location
Commission details
Summary
12
Index
Index

Customer sales this year compared to last year

Are your customers spending more or less with you year after year? Which customers have had the biggest increase in revenue over the last year? Or, the biggest increase in gross margin over the last year? This report is all about comparing these types of statistics, using data from the receivables management module.

Brief background of the company

This report is for a company that has limited sales staff, so they need to know whether customers are increasing or decreasing their sales, in order to know which customers deserve rewards (for increasing sales) and which customers deserve some extra attention (for declining sales).

Pain or goal defined

This company wants to track which of their customers have the largest revenue increase and decrease. They also want to know which customer has the largest gross margin increase and decrease. The staff members who need this information are not GP users.

Our goal is to have one report that allows you to compare...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 3
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete