
Building Dashboards with Microsoft Dynamics GP 2016
By :

Before we begin with Jet Reports, let's review what we've done so far. We've connected to GP data for use in Excel in a variety of ways, using several of these methods to create an Excel dashboard. Now that we are moving into Jet Reports, we'll begin using a combination of Jet Express for GP and native Excel functions to create a general ledger trial balance. Once you obtain these skills, you can tap into pretty much any GP data (that you have the rights to) and create an Excel table and, therefore, some power Excel reports.
Here is a sample of the report we will build in this chapter. This sample is currently only reviewing the accounts for the cost of goods sold for a fiscal period:
Change the font size
Change margin width
Change background colour