O'Reilly logo

Microsoft Dynamics GP 2013 Cookbook by Mark Polino, Ian Grieve

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Delivering flexibility by exporting navigation lists to Excel

The big Excel button on the SmartList window provides a visual cue that SmartLists can be exported to Microsoft Excel. That same blinding flash of the obvious is not available for navigation lists. Navigation lists provide another way to interact with information in Dynamics GP and they can be filtered and limited like SmartLists. Navigation lists don't have a big Excel button so in this recipe we will look at how to export navigation list data to Excel.

How to do it...

To export a navigation list to Excel:

  1. Select Financial from the navigation pane.
  2. At the top of the navigation pane, select Accounts to open up the accounts list.
  3. Mark the checkbox in the header next to Account Number to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required