- #MICROSOFT DYNAMICS POS QUERY TOOL HOW TO#
- #MICROSOFT DYNAMICS POS QUERY TOOL UPGRADE#
- #MICROSOFT DYNAMICS POS QUERY TOOL PASSWORD#
- #MICROSOFT DYNAMICS POS QUERY TOOL LICENSE#
#MICROSOFT DYNAMICS POS QUERY TOOL PASSWORD#
#MICROSOFT DYNAMICS POS QUERY TOOL LICENSE#
This tool expand even further the nice capabilities with the free tool.The following are the updates and enhancements made for each group of components: In a future post, we will talk about Quick Query Editor. Ask your partner if this may make sense to you due to the way Microsoft changed licensing a few years ago. This especially could make sense for you if you need only a few users, but have additional functionality (modules) you would like to add. If you are on a very old version of Dynamics SL, it may make more sense to repurchase in order to get this tool.
#MICROSOFT DYNAMICS POS QUERY TOOL UPGRADE#
Quick Query is free and included in your upgrade to Dynamics SL 2011. Quick Query allows you to store, find, and review data more easily.
#MICROSOFT DYNAMICS POS QUERY TOOL HOW TO#
The video referenced above will show you how to drill back to your original entry screen-Inquiry or Maintenance-right in Dynamics SL. When you save filters with your own names you can publish them to your Quick Query menu or to Favorites so these queries can be found often and easily.
You can share this data with individuals, groups or with everyone.Īs you would expect, Quick Query also allows you to export to Excel with column headers already included. Quick Query permits you to share with others the simple but useful Query you’ve created. the various fields you are interested in in order to release your data from “data jail”. You simply right click to add, move, rearrange, etc. Some of the items that can be fetched easily with queries that come with the system are Orders, Inventory Views, Field Service Information, Project details.Īs you will see in the demonstration Quick Query allows you to hide fields (removing columns without removing column data from your database), add fields, filter data, and rename column names. This video can be accessed on the Microsoft Dynamics SL Community site by clicking on the Quick Query video link here. Quick Query can filter the right data but will not allow you, for example, to sort first by vendor id and then by dollar amount so that your report can show invoices by vendor and then ascending or descending order within each vendor. One thing a Crystal Report or a SQL Reporting Services report can do better for you is have multiple sorts within the displayed data. Gone are the days when you had to ask your IT department to create a Crystal Report for you. There are over 50 predefined views and these views are for non-technical users.
“Show Results” allows multiple filters at once, showing columns that can be filtered. The video shows you how to set that second filter for a query. For a long time I thought that this was a real advantage that the Dynamics GP Smartlist program had over Dynamics SL and Quick Query. You can change the names of the queries to make the views or data easier to find later.Īnother thing that is nice to learn and not immediately intuitive, is that multiple filters can be set to a query. You can also use Windows Explorer to link your documents to a shared drive by dragging your documents to the attachment screen. The video also shows how you can link to a Sharepoint site so you don’t have 2 copies of the same document uploaded to two different sites. Some of my favorites that are demonstrated here are the ability to attach and view Word documents, as well as images from a simple query. It is under 8 minutes long but provides much of the training you may not have had time for when you worked through your upgrade from Dynamics SL version 7 to Dynamics SL version 2011. In the Community section of the Dynamics SL site, there is a nice Quick Query video.