As we have just seen, one of the common complaints about the default SmartList tool is that they take too long to export to Excel. This is especially true when viewing a transaction related SmartList. For example, let's look at the default SmartList for Sales Transaction Line Items without filters. Depending on our environment, this particular SmartList could have thousands, if not hundreds of thousands of records. When selecting to export this to Excel without using the dex.ini
switch trick for faster exporting, this could take some time. Also, what happens once we get our data into Excel? What do we do the next day after new sales transactions have been added into GP? We will have to run the SmartList and export to Excel all over again just to grab a few extra lines of data. Alternatively, we could apply a filter to find only transactions with a certain date, but this procedure just opens the possibility of data falling through...
Microsoft Dynamics GP 2013 Reporting
Microsoft Dynamics GP 2013 Reporting
Overview of this book
Table of Contents (21 chapters)
Microsoft Dynamics GP 2013 Reporting
Credits
About the Author
Acknowledgments
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Meeting the Reporting Challenge
Where Is My Data and How Do I Get to It?
Working with the Builders – SmartList and Excel Reports
Report Writer and Word Templates
Utilizing the SSRS Report Library
Designing Your Analysis Cubes for the Excel Environment
Utilizing Analysis Cubes for Excel for Dynamic Reporting
Designing Financial Reports in Management Reporter
Viewing Financial Reports in Management Reporter
Bringing it all Together
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Index
Customer Reviews