Excel Integration

Integrate Great plains with Excel

Jump to


    In today's fast-paced business environment, integrating your financial management system with powerful analytical tools is not just a convenience—it's a necessity. Integrating Great Plains with Excel empowers organizations to streamline processes, enhance data accuracy, and unlock valuable insights from financial data. On this page, we’ll explore the importance of this integration, detailing the seamless connection between Microsoft Dynamics GP and Excel to create comprehensive reports, conduct in-depth data analysis, and drive informed decision-making.

    We'll cover the essential aspects of this integration, including what you need to set up the connection using the Excel Add-In for Dynamics GP, the straightforward process of integrating Great Plains with Excel, and the various use cases such as mass imports, exports, and data management tasks. Additionally, we’ll provide guidance for troubleshooting your integration and answer common questions to ensure you make the most out of your Great Plains and Excel experience.

    Integration of Great Plains with Excel

    Integrating Microsoft Dynamics Great Plains with Excel enhances the functionality and efficiency of data management tasks. There are multiple methods to achieve this integration, which include using the Excel Add-In for Dynamics GP, built-in functions, an ODBC driver, third-party add-ons, and an Excel connection. This integration enables users to perform mass imports/exports/updates, data cleansing, de-duplication, and Excel-based data analysis directly from the familiar interface of Excel.

    Using the Excel Add-In for Dynamics GP

    The Excel Add-In for Dynamics GP is a self-contained tool that connects with Microsoft Dynamics GP data and integrates seamlessly with the Excel toolbar and ribbon. It does not require additional software installation and is specifically designed for tasks such as mass data operations and data analysis. This integration simplifies processes like data cleansing and de-duplication directly within Excel.

    Built-in Functions and Excel Connection

    Dynamics GP can interface with Excel using its built-in functions and an Excel connection. This method is considered to be one of the quickest ways to link GP data with Excel. By utilizing this connection, users can leverage Dynamics GP's capabilities along with the powerful data manipulation features of Excel.

    SmartList, Excel Budgets, and Pre-defined Reports

    Excel's integration with Dynamics GP extends to using SmartList, Excel Budgets, and Dynamics pre-defined Excel reports. These features allow users to conduct a variety of tasks ranging from budget management to generating sophisticated custom reports, all from within the Excel environment.

    Best Practices for Deployment

    When deploying Great Plains Excel reports, it is recommended to use a shared network location, a SharePoint Server 2007 Report Center, or a mapped drive with a consistent UNC path for accessibility. The deployment can be accomplished at no additional charge for Business Essentials and Advanced Management Business Ready Licensing. It is important to follow the instructions outlined in the SystemSetup.pdf file and to use the 'sa' user credentials for Microsoft Dynamics GP during deployment. Additionally, deploying reports as 2007 Microsoft Office system reports (*.xlsx) using an Office data connection (ODC) ensures that data can be updated at any time. For personalized interactions with the data, the User Level option enables users to modify and save reports locally on their workstations.

    Sourcetable Integration

    Integrating Great Plains with Sourcetable

    Shifting from traditional Excel spreadsheets to Sourcetable when integrating with Great Plains can significantly enhance your business intelligence and automation processes. Sourcetable simplifies the synchronization of live data from various applications or databases directly into a user-friendly spreadsheet interface. This seamless integration facilitates real-time data analysis and decision-making without the manual data entry often associated with Excel.

    By utilizing Sourcetable, businesses can take advantage of its ability to automatically pull in data from multiple sources, which greatly reduces the potential for human error and increases the accuracy of data reports. This automation not only saves valuable time but also allows for more frequent and timely data updates, ensuring that business insights are based on the most current information available.

    Moreover, Sourcetable's familiar spreadsheet format means there is no steep learning curve, allowing for a smooth transition from Excel with minimal training. The integration with Great Plains through Sourcetable empowers teams to focus on analyzing the data rather than spending time on its preparation, thereby enhancing productivity and strategic decision-making capabilities.

    Common Use Cases

    • G
      Excel Integration
      Automated Financial Reporting
    • G
      Excel Integration
      Budget Planning and Analysis
    • G
      Excel Integration
      Real-time Data Analysis and Decision Making
    • G
      Excel Integration
      Customized Sales and Inventory Reporting
    • G
      Excel Integration
      Secure Report Distribution and Access Control

    Frequently Asked Questions

    Why can't I see the Excel reports or data connections in Microsoft Dynamics GP?

    The paths of the Reports Library and of the data connections need to be entered in the Reporting Tools setup, the user may not have permissions to the reports, the Office system may not be installed on the computer running Microsoft Dynamics GP, or the reports may not have been deployed for that company.

    What should I do if clicking the name of the report in Report Center gives me an error message?

    Click the Excel button next to the report to open the report within the Excel application.

    What should I do if clicking a report in the SharePoint Server 2007 Reports Library opens the report in Internet Explorer?

    Configure the browser-enabled documents settings for SharePoint Server 2007 and click to select the Open in Client Application check box.

    What should I do if I receive an error message when deploying Excel reports to a network share?

    Install .NET Framework 3.0, verify that the UNC path of the network share is valid, and verify that the folder structure entered for the path exists.

    What should I do if I get a security warning when trying to open an Excel report in Report Center?

    Click Options, click Enable this Content, and then click OK.


    Integrating Microsoft Dynamics GP with Excel streamlines your business processes by enabling advanced reporting and custom report creation with ease. The Excel Add-In for Dynamics GP simplifies the connection, allowing for direct access to live data, mass data operations, and in-depth analysis—all from within the familiar environment of Excel, without the need for additional software. While there are various ways to interface Excel with GP, including SmartLists, Excel Budgets, and Dynamics pre-defined reports, the Excel Add-In is recognized for its speed and integration with the Excel toolbar. However, if you're looking for an alternative solution that bypasses traditional integrations, consider using Sourcetable. Sign up for Sourcetable to streamline your data management and get started on enhancing your business intelligence today.

    Connect your Great plains Data

    Analyze data, automate reports and create live dashboards
    for all your business applications, without code. Get unlimited access free for 14 days.