Book Image

Microsoft Dynamics GP 2013 Reporting

Book Image

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
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Index

Extending SmartList data to Excel by deploying Excel Reports


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...