web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Exporting smartlist
Microsoft Dynamics GP (Archived)

Exporting smartlist

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    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).

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at

    If you are using a full client add this switch to the dex.ini file. SmartlistEnhancedExcelExport=TRUE.

    Regards,

    Kirk

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans