Have you ever tried getting a drink of water from a fire hose? I’m willing to bet you haven’t… or if you have, you probably didn’t quench your thirst and instead wound up with a headache! There’s enough water flowing from the hose every second to satisfy your thirst for a week – but spilling out so fast that it’s worthless trying to fill a glass.
Microsoft Dynamics GP is an industrial-strength solution to business and financial management. Especially if your enterprise has been using it for any length of time, the datasets within the system hold a massive amount of information, too much to drink in all at once. Of course, that’s what we have computers for – to process it all for us so we can see the most important data and use it effectively for decision making.
The integration between Dynamics and Excel is phenomenal – and Excel is a powerful reporting tool in its own right. However, everything has its limits, and Excel is no exception. More often than not, Dynamics GP datasets contain too much information to run Excel reports. If you don’t limit the number of transactions processed, it can bog down the system and reduce your reporting to a snail’s pace.
Thankfully, there’s a solution. Parameters can be added to Excel reports in order to allow end-users to filter data on-the-fly using specific cells set aside for that purpose.
At the 2018 Dynamics GP User Group Summit, Turnkey Technologies’ very own Sean Hunter gave a presentation on how these Parameters can open up a world of reporting possibilities. Here’s a rundown of what was covered:
- How to connect an Excel spreadsheet to a GP database table using SQL scripts and Microsoft Query.
- How to add parameters to the data connection and then add those parameters to an Excel spreadsheet cell in order to dynamically change the data in the spreadsheet.
- Advanced features: How to use stored procedures and their associated parameters in Excel.
Did you miss the presentation at GPUG Summit? Would you like help implementing Excel reporting in your enterprise? Sean Hunter is but one member of our amazing team, all of whom are experts, dedicated to assisting our clients to get the most out of their Microsoft Dynamics GP system.
Contact us now for a helping hand!
Join us for the next free Dynamics GP User Group Meeting hosted by Turnkey Technologies on December 18, 12-4 pm!
Sean’s GPUG Breakout Sessions: