This is the continuation of the 4-part series on getting the GL Account segment description into Excel. As I’ve said before, it doesn’t matter what you want, if it’s in Dynamics GP, you can get it into Microsoft Excel.
In this series, I’ll show you how to achieve this using the following tools:
- SmartList Designer (Click Here to see it)
- Excel Power Query
- SmartList Builder (eOne Product)
- Excel Builder (eOne Product)
In this part, I’ll use Excel’s 2016 Get & Transform. If you have Excel 2013 or 2010, you can download the Power Query Add-On and achieve the same results.