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) / SmartList Export to Ex...
Microsoft Dynamics GP (Archived)

SmartList Export to Excel in GP Dynamics 2013 formats dollar amounts to 5 decimal places

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Is there a way to change the default format so exported values only have two decimal places? We upgraded from version 10 and this was not a problem.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList Export to Excel in GP Dynamics 2013 formats dollar amounts to 5 decimal places

    One potential problem. Though exports appear to be 5 times faster the export appears to open additional instances of the Excel.exe process. This can cause problems.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SmartList Export to Excel in GP Dynamics 2013 formats dollar amounts to 5 decimal places

    thanks SmartlistEnhancedExcelExport=TRUE worked.

  • Verified answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: SmartList Export to Excel in GP Dynamics 2013 formats dollar amounts to 5 decimal places

    Add SmartlistEnhancedExcelExport=TRUE to your dex.ini file.

    Kirk Livermont

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans