Stop the back and forth between Dynamics SL and your Excel Spreadsheets. Exporting and extracting data from Dynamics SL has never been easier or more efficient.
With Dynamics SL2015, the Quick Query functionality (introduced in SL2011) allows you the ability to retrieve data from pre-defined templates for various modules (General Ledger, Accounts Payable, Accounts Receivable, Project Controller, etc). It is a quick and easy way to run reports and is a must use by any Dynamics player.
The best part about the quick query functionality is the ability to create a refreshable data connection, query table, and pivot table any time for selected queries. With the connection, the data resides in Excel and can be refreshed to retrieve new data available in the system.
Step away from your desk, come back in an hour, a week or a month (for those of us who enjoy long vacations) and the Quick Query connection will have you covered. Giving you the ability to update any report with a simple click of a button. This feature is an absolute “must-use” if you continually copy and paste the accounting data to Excel. The time savings are significant.
If you found this helpful come check out our guru Anthony Rice,
About T3 Information Systems
Based in Washington, DC, T3 Information Systems provides solutions to help our clients address their most critical and specific business needs. T3 combines best in class software applications with industry best practices and proven processes to meet your unique business needs; solutions for enterprise resource planning (ERP), customer relationship management (CRM), business intelligence (BI), and application development; Specializing in Microsoft Dynamics GP, SL and CRM solutions. T3 Information Systems is there throughout the entire lifecycle of your new solution; from initial software evaluation to installation, data migration, implementation, software development, system integration, training and support.
Please contact Joseph St Germain at firstname.lastname@example.org or (202) 770 3549 if you have any questions or would like to find out if Dynamics SL is correct for your company