O'Reilly logo

Microsoft Dynamics GP 2013 Reporting - Second Edition by Christopher J Liley, David Duncan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a new reporting metric via Report Builder

Earlier in this chapter, we discussed the deployment of predefined charts and KPIs that can then be made visible on the GP 2013 Homepage in Business Analyzer. In this section, we'll take a look at creating a metric that shows us the top ten items on unposted sales orders by extended price. A metric of this sort can give members of our organization insight into which items are generating the most sales at the moment. As the data source for this metric, we'll use one of the SQL views that is generated in each GP company database by the predefined Excel Reports deployment that was covered in Chapter 3, Working with the Builders – SmartList and Excel Reports, of this book: dbo.SalesLineItems. Remember, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required