Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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 highlighting a few of our SQL views available:
Employee Year To Date Units and Dollars
Interface to GL
Human Resources and Payroll
ACA Employee and Dependent Information
Beneficiary DependentsEarning History of when employee received pay increase information
Time Accruals and Time Available for Attendance
Deduction In Arrears (multiple views)
Employee Summary, Employee Pay Rates
Hours Worked Per Year
Payroll Year End Wage (W2)
W2 Duplicate Box and Labels for Pay Codes, Benefits, and Deductions
MO Receipt Status
Non-Closed MO Variances
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
GL Journal Entry Final Approvers for Workflow
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.
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.
The document contains the views as embedded objects.
Where do we get the actual views? "GP SQL View Living Doc" is only a listing of 'available' views.
Business Applications communities