Summary

In this chapter we've looked at a number of ways to get data from Dynamics GP 2016 into Microsoft Excel 2016. Having a lot of options makes it possible to still build an effective dashboard in spite of those restrictions. How data gets extracted from GP totally depends on the rights and needs of the report creator and/or report consumer. We mention this so that you can experiment and find out which options work best for you and your company. Chances are that you'll use more than one option. If you end up needing all of them, let us know. Better yet, write a book for us to read! I've no doubt we'd learn a lot from you.

In the next chapter, we will look at one of the best and easiest options to access Microsoft Dynamics GP 2016 data—(the out of the box) refreshable Excel reports. In that chapter, we will start putting together the data that will eventually go into our dashboard.