Retrieving information from Dynamics GP for reporting purposes is so easy to do because there are several great tools available and there are many sources of information on how to use the tools and specific code to make and build reports.
Victoria Yudin writes a blog in which she generously shares SQL code that allows you to easily create SQL views to retrieve information from Dynamics GP. Victoria wrote this article this week, and in it includes code for creating a SQL View that retrieves information about payables invoices and associated purchase order line details. This is fantastic.
You can easily copy the code from her blog and paste it into a new query using SQL Server Management Studio. Execute the query and it will create the view. The SQL view can be used in Excel and SmartList Builder to create SmartLists that all users can have access to.
I created this short video that shows how easy it is to do.