New April Hotfix and more changes for VAT
Check out the latest updates to Microsoft Dynamics GP 2016 and 2018.
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
In Microsoft Dynamics GP 2016, we now have the ability to export numbers from SmartList records into Microsoft Excel as numbers and not a text format, allowing the option to do mathematical calculations with those values, such as adding the values of records and more.
For example, if I open the SmartList window (click on Microsoft Dynamics GP, click on SmartList or from the Administration navigation menu, click on Reports, then click on SmartLists.) and click on the default Purchase Line Items SmartList report under Purchasing, it has a QTY Ordered column that shows number values. If I click on the Excel button in the SmartList window to export this report to Microsoft Excel, the Document Amount values have a format of 'Number'.
Because of this, I can use a SUM argument in Microsoft Excel to add values from this column, such as these screenshots:
This is true of all numbers and 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.
Detailed documentation for System Features System Features VIDEO a must see!!
Be sure to check back to the Microsoft Dynamics GP 2016 New Feature Blog Series Schedule page to review upcoming blog posts to help you gear up for What's New in Microsoft Dynamics GP 2016 with great content, documentation and videos.
I'm having trouble seeing what changed. When I export smartlists in GP 2015 the format/datatype in excel is a "Number" with 5 decimals. No difference with GP 2016. I could do a sum on it before.
The only difference appears to be smartlists created with smartlist designer. The export for those formatted them as text in GP 2015. It looks like they fixed that bug. Is that what we're cheering for here?
I can't see how this is any different to what already exists in 2015. The screen shot included with the feature of the day series suggested that the formatting that was seen in SmartList i.e. the currency symbol and 2dp would be retained when exported to Excel. That got me excited. So I was quite surprised just now when updating our client documentation for the release to find that that is not the case, it is simply the background formatting. Since most accountants I know would automatically highlight the columns and use the "comma" or $ shortcut format since they don't want all those extra decimals, this has been a non-issue. The issue most of my clients have is that the numbers look terrible - fixing the way they look would be worth getting excited about.
Business Applications communities