New April Hotfix and more changes for VAT
Check out the latest updates to Microsoft Dynamics GP 2016 and 2018.
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent 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 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.
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