SQL Tag

    SQL views can be used to expand the value of your SmartLists reporting tool in Dynamics GP. Take advantage of the work provided by the generous people within the Dynamics Community. One of the values of Dynamics GP is that there are a lot of people who freely provide...

SQL Views with Dynamics GP allows you to use SQL views you either create on your own or discover on the Internet, to report on information within your Dynamics GP system. There are several sources of SQL scripts on the Internet, whose authors freely make available SQL queries that you...

Dynamics GP includes a variety of reporting tools that allow you to easily get the information you want. There is standard reporting in Dynamics GP that produce general ledge trial balance reports, accounts receivable aging reports, etc. Any of these can be modified to meet your needs. There are...

SmartLists is the easiest reporting tool to use and probably the most popular. You can quickly get to the information you want, and dump it to Excel. Sometimes the results one gets are not those expected. This often is because of the way that the underlying data queries...

SmartLists is probably the most popular reporting tool in Dynamics GP. It's easy to use and it really lets you get to the data you want. If you have multiple company databases in your GP system you should consider using SmartList Builder to create SmartLists that will access...

Analysis Cubes add another great reporting tool to Dynamics GP. Analysis cubes allow you to drill down deep into your data and uncover new information. Analysis cubes uses SQL Server to maintain a data warehouse of Dynamics GP data that has been imported from your GP...

SQL Server Reporting Services includes a nice little tool that allows you to easily create simple reports using SSRS. This is an excellent way to get an introduction to SSRS. It's not as frightening as you may think. Here's a video that will give you a quick look at it: ...