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 / Finance | Project Operations, Human Resources, ... / GP18.3 Smartlist expor...
Finance | Project Operations, Human Resources, ...
Suggested Answer

GP18.3 Smartlist export to Excel drops off leading zeros in employee id

(0) ShareShare
ReportReport
Posted on by Robert Yao 492

Does anyone experience Smartlist export to Excel drops off leading zeros in employee id after upgraded from 18.2 to 18.3? Excel was working file in 18.2. I tried to add SmartlistEnhancedExcelExport=FALSE in dex.ini with no luck. 

I am also seeing an issue in RDS with published GP application after upgraded to 18.3, a few GP users can still login to GP fine with their browser, the other had trouble and ask them to launch GP utility but they are all fine to login through RDP. Any suggestion?

Thanks,

Rob

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    We haven't seen any specific issues to 18.3, but if you have tried the SmartListEnhancedExcelExport= and/or UseCOMForExcelExport= lines in the Dex.ini for Dynamics GP and neither have worked, my question would first be whether the decimal places show correctly when you view the reports in the SmartList window itself?

    Also, does this issue occur for all SmartLists including the default reports, or just some reports or custom reports?

    If custom, do you have SmartList Builder installed and were the custom reports created via SLB?

    If the decimal places are not correct when viewing the report in the SmartList window itself, there is a DECPLCUR value column in the ADH00100 table that holds that information, but if the report shows the decimal places correct when viewed in the SmartList window, but the issue is only seen when exporting the reports into Excel, that would be different.

    Thanks

  • Robert Yao Profile Picture
    Robert Yao 492 on at

    I tested with my local GP18.3 with Excel 2019, exported an employee with three leading zeros exported fine in Excel showing three zeros. The customer site is using Excel 2016, not using SmartLists builder at all, I checked ADH00100 and there is no DECPLCUR field, I tested with a new Smartlists called EMP CLASS and here is the statement in ADH00100: select [UPR00100].[EMPLOYID] AS 'Employee ID', [UPR00100].[EMPLCLAS] AS 'Employee Class' from SMUMN..[UPR00100], showed corrected in Smartlists with leading zeros for employee id, dropped leading zeros after exported to Excel 2016. Do we have to use Excel 2019 instead? What about my second part of question in my original post?

    Thanks Derek

    Rob

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    Dynamics GP 18.3 is supported/compatible, per System Requirements, with these Office versions:

    Microsoft Office 2013 32bit & x64

    Microsoft Office 2016 32bit & x64

    Microsoft Office 2019  32bit & x64 (18.2.1013 GP version or later)

    So, if you export the SmartLists to your Excel 2019, the leading zeros show, or are you using a completely different Dynamics GP environment, i.e. GP databases, then the customer?

    Besides the UseCOMForExcelExport=TRUE and/or SmartListEnhancedExcelExport=TRUE lines in the Dex.ini, which you can test together and each individually to see if any of these help resolve this issue, that would be my initial suggestion as I can't say I've seen the issue with leading zeros, but more so with decimal places.

    For the second question, since it is unrelated to the SmartList export issue, can you ask it in a new forum, just so we can keep each issue/question separate, which makes it easier for others to find the issue and resolution when searching for it.....

    Thanks

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans