Call 855-644-2677 for Microsoft Dynamics GP / SL Support, Training, and Implementation

You Can Export Numbers to Microsoft Excel as Numbers Rather Than as Text in Microsoft Dynamics GP 2016

June 1, 2016 11:39 am Published by

Export Numbers to Microsoft Excel as Numbers Rather Than as Text in Microsoft Dynamics GP 2016Microsoft Dynamics GP 2016 was released in May, and we’ve been going over the new features it delivers, first as introductions, and now in more detail. Today we’re going to take a closer look at another new feature we’ve previously introduced: the ability to export numbers to Microsoft Excel as numbers rather than as text.

Specifically, with Microsoft Dynamics GP 2016, you can now export numbers from SmartList records into Microsoft Excel as numbers rather than in text format. This feature enables you to do mathematical calculations with those values, such as adding the values of records (and much more, of course). And that is the entire point, as well as the value of this feature.

As an example, if you open the SmartList screen (Microsoft Dynamics GP > SmartList, or from the Administration navigation menu, Reports > SmartLists) and click on the default Purchase Line Items SmartList report under Purchasing, it has a QTY Ordered column that shows number values. If you click on the Excel button in the SmartList screen to export this report to Microsoft Excel, the Document Amount values have a format of “Number.”

Because of this, you can use a SUM argument in Microsoft Excel to add values from the QTY Ordered column. This will hold true for all numbers, such as currency values, exported into Microsoft Excel from SmartList reports in Microsoft Dynamics GP 2016, including SmartList Favorites, default SmartLists modified through SmartList Designer, and custom SmartLists created through SmartList Designer.

About MIG & Co.

MIG & Co. is a professional consulting firm that specializes in the implementation of business management software solutions, including Microsoft Dynamics GP, SL, and CRM. We automate business processes to ensure that our customers work efficiently. MIG is a Microsoft Dynamics Gold Certified Partner.

Ready to learn how Microsoft Dynamics can help your business?

Talk to an Expert

Your privacy is important to us. MIG & Co. will never sell, lease, or share your information.

MIG & Co.