The Microsoft Dynamics GP Support team has created a living document where users can get sample SQL Views for various modules in GP. This includes a wide variety of modules such as Bank Rec and Manufacturing. These SQL views can then be brought into SmartList Designer with the ‘sa’ user and can be used within GP by other users using KB 4014658 and can also be exported to Excel .
KB 4014658 - How to create a SmartList Designer report using a SQL View
Below is a list of just a few of our featured views:
Employee Year To Date Units and Dollars
Interface to GL
ACA Employee Info
ACA Dependent Info
MO Receipt Status
Non-Closed MO Variances
Deduction In Arrears
Employee Pay Rates
Hours Worked Per Year
Year End Wage
PTE Timesheets Pending Approval
Purchase Order Processing
PO Pending Approval Master List
Requisitions Ready for Purchase
Security Cheat Sheet
List Final Approvers of Documents
Pending Approval List
For the entire list please download the following document. (This is a living document that we will continue to update in the future.)
There are also many publicly posted SQL views for Microsoft Dynamics GP besides our list above, and you can find almost anything you need or at least a starting point by just searching “GP SQL View” on Bing or any search engine. Then use the KB above to bring it into SmartList Designer.
CLICK HERE TO START YOUR SEARCH!
Note: Issues with non-power user's receiving access errors when attempting to modify SmartLists based on SQL Views have been addressed in GP 2018.
Where do we get the actual views? "GP SQL View Living Doc" is only a listing of 'available' views.
The document contains the views as embedded objects.
You are correct, the SQL views are embedded in the Word Document. Just double click them to open them in SQL Server Management Studio. You should also be able to right click and save them from the Word Document to whatever location you desire.