Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2015: Comma separat...
Microsoft Dynamics GP (Archived)

GP 2015: Comma separation error in exporting SmartList to Excel

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

Hello,

We're currently running GP 2013 and I recently found the following problem: When exporting a Manufacturing module SmartList to excel using the "Excel" button, values that contain a comma are not properly exported. For example, I exported a Manufacturing Picklist SmartList with a "Required QTY" column containing values such as "1,200". The smartlist shows the comma in the number 1200.

When exported to Excel, the value for that cell is just "1". It appears that there a comma delimiting problem in the export function. Has this issue been resolved in a later version/bugfix?

Thanks,

Chris

*This post is locked for comments

  • Suggested answer
    adeel333 Profile Picture
    adeel333 485 on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    A quick solution is to add following line in DEX.INI at the end:

    SmartlistEnhancedExcelExport=TRUE

  • Rochelle Mausteller Profile Picture
    Rochelle Mausteller 769 on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    Chris,

    Thanks for your response.  I'll follow up with what I found.  We added the following to the dex.ini file and it resolved the problem with the comma.

    SmartlistEnhancedExcelExport=TRUE

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    We just upgraded to Dynamics GP 2016 and that resolved the problem.

  • Rochelle Mausteller Profile Picture
    Rochelle Mausteller 769 on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    Chris,

    I am also experiencing this problem.  Were you able to find an answer?

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    Hi Chris,

    You may also want to check the regional settings of the user's workstation where the smartlist export takes places.. I've seen funky things going on when not using a standard US English setting... especially when it comes to decimals and date formats.

    On Customer Source when going into the download section of the various GP versions, there should be a list of the bug fixes since the last release... If you can't find it there, then you're next stop would be to check the MS Connect site (requires registration, but is free to everyone). This site is used to report feature improvement and bugs (for some products). Most likely if it's a bug, the support call to Microsoft will be free of charge.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    I just realized I misspoke in the text of my post. We're running GP 2015. Is there a detailed list of fixed bugs available somewhere?

    It sounds like the only way for me to report the bug or even find out of this bug is fixed is by using up a support ticket.

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    Hi Chris,

    GP 2016 has corrected many of the bugs that occurred with currency & date values in SmartList to Excel export.. I'm not aware of issues with QTY fields, but there are some DEX.ini settings you could test to see if it improves the export.. This goes back to GP2010, but was still valid for 2013.

    dynamicsgpblogster.blogspot.ca/.../undocumented-dexini-switch-cuts-down.html

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    Praveen,

    Are you talking about a setting in GP or in Excel? By the time it gets to Excel it is too late - the data is lost. You can change the format in Excel but only numbers ahead of the comma are present in the cell. The rest is lost. "1,200" in the SmartList exports to "1.00" in Excel.

    Whether it is a numeric or a text field, I think that it is a bug if GP exports something different than what is displayed in GP. If it's a text field, the cell in Excel should read "1,200" just like it does in the SmartList.

    The export function does appear to handle commas appropriately for other fields like "Component Item Description."

    Thanks,

    Chris

  • Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: GP 2015: Comma separation error in exporting SmartList to Excel

    Hi Chris,

    Hope you tried setting up the Format of Require QTY column to Numeric manually....

    If not, suggest you to try this.

    Thanks,

    Praveen

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans