Armanino Blog
Article

Where's My SmartList? Migrating from GP to D365 F&O

by Noah Kluge
September 11, 2018

Many Microsoft Dynamics GP clients have come to rely on SmartList as a way to get data out of GP in order to build Excel-based reports. SmartList allows you to connect different tables, providing a single view with general ledger (GL) account detail alongside descriptions and vendor or customer details.

SmartList Tables

But companies moving from GP to Microsoft Dynamics 365 for Finance and Operations (D365 F&O) may wonder what happened to this feature in their new system. While D365 gives you the ability to access this type of information with a powerful export-to-Excel functionality, you are limited to what's available within a data entity.

Armanino's Dynamic Insights solution improves on the SmartList concept by integrating sub-ledger details into the GL structure itself, coupling the data with an Excel report writer, Microsoft Power BI or other tools for visualization. This allows for the elimination of typical Excel data massaging with VLOOKUPs and SUMIFs, all while providing a better analytical environment.

How useful has this been? In a recent Dynamics GP to Dynamics 365 migration, one of our clients said, "I don't understand why they sell Dynamics 365 without this tool."

To illustrate the benefits of Dynamic Insights, we've included screenshots below. The first set showcases operating expense information in Excel, while the second set shows sales detail integrated into the GL.

Operational Example in Excel

Operational Example in Excel

Sales Example in Microsoft Power BI

Sales and booking information in Microsoft Power BI:

Sales and booking information in Microsoft Power BI

Sub-ledger details with sales order, item, customer and GL account details.

Sub-ledger details

Whether you're looking to move or have already moved from Dynamics GP to Dynamics 365 for Finance and Operations, contact us to learn about Dynamic Insights, our alternative to SmartList.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Authors
Noah Kluge - Senior Manager, Audit - San Ramon CA | Armanino
Senior Manager
Resources
Related News & Insights
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Women in Nonprofit Leadership Panel
Webinar
Aspiring nonprofit leaders should hear the insightful stories of these women industry leaders to empower their journeys.

December 14, 2021 | 10:00 AM - 11:00 AM PT
The Evolution of Gaming Companies
Webinar
From seed-funding to acquisition, position your gaming company for success.

December 9, 2021 | 01:00 PM - 02:00 PM PT