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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Smartlist Excel Report...
Microsoft Dynamics GP (Archived)

Smartlist Excel Report - 5 to 2 Decimal

(0) ShareShare
ReportReport
Posted on by M_Anne 320

Hello.  I recently upgraded from GP 2010 to 2013.  When I generate a report via SmartList and then export it to Excel, the dollar amounts show up with 5 numbers to the right of the decimal, instead of 2 like before.  (i.e $123.45000 instead of $123.45).  Is there anyway I can change this?  Thanks so much!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    I think you have discovered a bug! Surely it's not supposed to do this. Now this is an unsupported dex.ini switch, but it works (be careful, there have been oddities).

    SmartListEnhancedExcelExport=TRUE

    Put that in your dex.ini file (in the Data folder) and your currency will go back to two decimals. You'll also notice a drastic increase in your download speed.

    I tried various combinations of the following .ini switches and not of them worked.

    ListsFastExcelExport=TRUE

    StdInternationalInfo=FALSE

    ExplorerFormatCurrency=TRUE

    Kind regards,

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at

    Oh, I tried both True and False settings.

    LV

  • Community Member Profile Picture
    Community Member on at

    Be careful with the Dex.ini switch mentioned by Leslie. You might not be happy with the way it treats leading zeros, zeros or blanks in your export.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans