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
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
chevron up
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

Top 10 most invoiced and returned items

You do not have to use 10 as the "most" number. It can be any number that will add value to you. Knowing what items sell the most by sectors can add great value. This should be obvious. Being able to identify what items get returned the most is just as important. Do you need another distributor, a competing product, or should you discontinue selling this product altogether? Items returned can lead to unhappy customers and may damage the reputation of your company, so finding the "why" is a critical mission.

Brief background of the company

This report was built for a company that sells all its products through eBay and a few other similar online stores. They wanted to know which online stores sold the most of the different kinds of items. In GP, they use the customer class to represent the store, and the individual who purchased the item is the customer. For this company, we removed the inventory site ID (because they only have one site), but we added...

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 2
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