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

New Quick Queries Available in Microsoft Dynamics SL 2018

July 2, 2018 6:37 pm Published by
[indeed-social-media sm_list='fb,tw,goo,li' sm_template='ism_template_8' sm_list_align='horizontal' sm_display_counts='true' sm_display_full_name='false' ]

One of the most popular features of Dynamics SL for business intelligence and reporting are Quick Queries.  They provide an interactive view into your Microsoft Dynamics SL data and give you the ability to analyze it and get answers fast. You can use and edit any of the more than one hundred pre-defined quick queries included in  MS Dynamics or build your own. With the interactive screen, you can select and sort information, filter it, save a custom view or connect to a custom SQL Server view.

To access Quick Queries, select them from the main window of Microsoft Dynamics SL. Click on one of the functional groups to get a list of available queries:

After you select a query, you can customize the query by moving, renaming, or deleting columns. When the query has been modified to your satisfaction, you can export it to Excel in several ways such as:

  • Copy to Table – Gives you the results of the data you selected in the quick query at the point in time you created the worksheet.
  • Connection – Creates a worksheet connected to the query. Anyone with access to the Excel file can open and refresh the data eliminating the need to sign into Dynamics SL.
  • Query Table – Creates a worksheet connected to the query and a table bound to the connection in Excel. This option also eliminates the need to sign into Microsoft Dynamics SL 2018.
  • Pivot Table – Creates a worksheet connected to the query that has a pivot table. No need to sign into Dynamics SL.

New quick queries in Financials and Projects have been added with the release of Microsoft Dynamics SL 2018. These include:

  • GL – Journal Transactions
  • AP – Check Preview
  • AP – Vouchers and Adjustments Batch Preview
  • PO – Receipt Preview
  • PO – Purchase Order Preview
  • IN – Inventory Batch Preview
  • OM  – Sales Order Preview
  • RQ – Requisition Preview
  • Service – Invoice Preview

When you need to do a deep dive into your Microsoft SL data but aren’t an expert in databases, use Quick Queries to filter, modify and save it quickly and easily.

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
  • This field is for validation purposes and should be left unchanged.

MIG & Co.