Call 855-644-2677 for Microsoft Dynamics GP / SL Support, Training, and Implementation

The Quick Query Module For Dynamics SL 2015 Part 3

May 24, 2016 9:56 am Published by

The Quick Query Module For Microsoft Dynamics SL 2015 Part 3The Quick Query module for Microsoft Dynamics SL enables users to quickly and easily mine the Microsoft Dynamics SL database, and to view, filter, and sort the mined data in a table format. with Quick Query, you can also export the data into Microsoft Excel, and set it up so that the Excel file is automatically refreshable with current data.

In our last couple of Microsoft Dynamics SL blog entries, we’ve covered some of the basics of how to use Quick Query, including the following:

  • Moving, deleting, and renaming columns
  • Changing the sort order
  • Drilling down to the source data
  • Filtering the data for a query
  • Copying and pasting data lines

Today we’ll continue going over how to use Quick Query for Microsoft Dynamics SL 2015.

Once you’ve filtered your query and arranged the data as you like it, it’s time to save it, which you can do by clicking the Save button at the top of the screen. In the Save Filtered Query View window, you can name this view and give it a description. You can also choose to make it available to all users, or to make it available to just a specified group or individual. Click OK, and your query is saved. The next time you open Microsoft Dynamics SL, you will see it in your Quick Query menu. You can delete it at any time by selecting it and clicking the Delete button.

To copy a query into Excel, just click the button for this at the top of the Quick Query Viewer window (furthest button to the right). Select “Copy to Table,” and your data will open in an Excel file.

About MIG & Co.

MIG & Co. is a professional consulting firm that specializes in the implementation of business management software solutions, including Microsoft Dynamics GP, SL, and CRM. We automate business processes to ensure that our customers work efficiently. MIG is a Microsoft Dynamics Gold Certified Partner.

Ready to learn how Microsoft Dynamics can help your business?

Talk to an Expert

Your privacy is important to us. MIG & Co. will never sell, lease, or share your information.

MIG & Co.