Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013
上QQ阅读APP看书，第一时间看更新
上一章目录下一章

SmartList exports

Exporting from a SmartList to Excel is the easiest and most commonly used method in Dynamics GP to get data to Microsoft Excel. We'll practice with an Account Summary SmartList.

To export from a SmartList to Excel, follow these steps:

  1. In Dynamics GP 2013, select Microsoft Dynamics GP | SmartList.
  2. Click on the plus sign (+) next to Financial and select Account Summary.
  3. Once the SmartList finishes loading, click the large, green Excel button to export this SmartList to Excel.
    SmartList exports

    Tip

    In 2010, Microsoft revealed a previously unreleased Dex.ini switch that can dramatically improve the time it takes to export SmartLists to Microsoft Excel. The Dex.ini file is a launch file used to control system behavior, and this switch changes the behavior of an Excel export. Instead of sending data to Excel one line at a time, the switch tells Dynamics GP to bundle the SmartList lines together and send them to Excel as a group.

    This switch is unsupported and can render the results differently than the default export process. Please test this in your test system before using in production. The Dex.ini file is located in the Data folder of the Dynamics GP installation directory. To use this switch, add the following line to the Dex.ini file and restart Dynamics GP:

    SmartlistEnhancedExcelExport=TRUE
上一章目录下一章