Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Overview of this book

Table of Contents (20 chapters)
Real-world Business Intelligence with Microsoft Dynamics GP
Credits
About the Author
Acknowledgments
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Items with quantities that are not available to sell and items that have not been sold within the last year


How many items are in your inventory that are either trapped in a status that makes them unavailable, or haven't been sold during the last 12 months? If an item is returned from a customer using SOP, the user is asked whether to make it reavailable for sale or unavailable by marking it as returned, in service, in use, or damaged. Any of these last four options will still make the item show in your inventory valuation and count, but the items are not reflected in the quantity available to either resell or allocate/fulfil. This report will show all of these problems in a super easy-to-read dashboard.

Tip

Note that this report contains two SQL Server views. If you like, you can create a simple report using one part, by only using the appropriate view.

Brief background of the company

A distribution company has over 500,000 items active at any given time. With this volume of items and a relatively...