I have noticed since we went to GP2013 that when a smartlist is exported to Excel that the information comes over with five zeroes after the decimal point.
I was curious to find out if this could be fixed.
*This post is locked for comments
If you are using a full client add this switch to the dex.ini file. SmartlistEnhancedExcelExport=TRUE.
Regards,
Kirk
Larry,
Found this post: https://community.dynamics.com/gp/f/32/t/105612.aspx
and this one: https://community.dynamics.com/gp/f/32/t/119712.aspx
Hope it helps.
Larry,
As ever, when something changes, it has unintended consequences. I have seen similar posts in the past several weeks, and have to admit I am coming down more and more on the side of the additional decimal places are a bonus, especially for companies who deal with items tracked to 3 or more decimal places of accuracy in some units of measure. It all comes down to data quality.
Here is a small post on the issue with potential resolutions:
www.crestwood.com/.../dynamics-gp-smarllist-help-with-decimal-places
Additionally, one could use SmartList Builder to create alternative SmartLists, which use a different format for the same fields (i.e. integer with no decimal places).
You are totally right, I have seen this issue quite often mostly in all the upgrades of Dynamics GP to 2013 version, it is not a bug, but primarily due to the web client.
Consider this thorough article for explanation and proposed solutions Smartlist and Navigation Lists export currency values with 5 decimals in Excel using Microsoft Dynamics GP 2013
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,307
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
