In the Community section of the Dynamics SL site, there is a nice Quick Query video.  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.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.  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.  You can also use Windows Explorer to link your documents to a shared drive by dragging your documents to the attachment screen.  You can change the names of the queries to make the views or data … [Read more...] about Quick Query Video and Quick Query Editor Thoughts

Have you had the experience where a Quick Query in Dynamics SL takes too long to return results for you?  You thought what you asked for was a simple query, but it’s taking too long to give you what you need.  We used to have the opposite issue with Dynamics GP, where Smartlists (Quick Query equivalent with Dynamics GP) would only return 1000 records regardless of how many records needed to be in the results to get an exhaustive answer to our query.In Dynamics SL, you need to introduce Paging to correct this issue with the performance of your query.Paging is a function that allows for the Quick Query screen not to return huge amounts of data all at once. It is like a Bing or Google search in that you only get one page at a time. The … [Read more...] about Dynamics SL Quick Query Enhancement

MSDynamicsWorld asked me to write a guest blog on comparing Dynamics SL’s new Quick Query function (new in Dynamics SL 2011) to Dynamics GP’s Smartlists.The post is at this link http://msdynamicsworld.com/story/easier-reporting-microsoft-dynamics-sl-2011-gains-gp-quick-query.  Please read if you are a software consultant or are interested in comparing the two tools.We were very excited to have Quick Query added to Dynamics SL 2011 and this post points out some further enhancements that Smartlists has that we would love to see in the future. … [Read more...] about Dynamics SL Quick Query and Dynamics GP Smartlists Compared