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

How to Use Quick Query in Web Apps For Microsoft Dynamics SL 2015 Part 2

February 19, 2016 5:04 pm Published by

How to Use Quick Query in Web Apps For Microsoft Dynamics SL 2015In our last Microsoft Dynamics SL blog entry, we were discussing Quick Query in web apps for the solution. Quick Query is a great tool you can use to query the Microsoft Dynamics SL database, and to view, filter, and sort the data, and to add/remove columns. Last time, we gave an overview for setting up Quick Query and for its basic use. Let’s pick up where we left off.

Let’s say that you want to know if any new contracts have been added each week. You’ll want to create a refreshable Excel file for this. From the Quick Query page in web apps, expand “Contract Management,” then select “Contracts (Base).” Open the “Actions” menu at the upper right, then click the Copy button under the “Export To Excel” heading. An Excel spreadsheet will open with all the contract data already copied into it. Click the Enable Editing button at the top, then close the file.

Next you’ll want to create a connection to the file so that it is refreshable. Click the Connection button under the “Export To Excel” heading, and click the Enable Editing button again. This time you’ll also have to click the Enable Content button. Click the Data tab, then click “Existing Connections” at the top. Select your file and click the Open button. Your data will then be loaded into the spreadsheet. Save it to a location where you will want to go open it each week. The file will be read-only.

Each week, you’ll open the file, click the Enable Content button, click the Data tab, and click “Refresh All.” Any new data will be added, so your information will always be up to date.

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.