Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Item List field is not...
Microsoft Dynamics NAV (Archived)

Item List field is not exported correctly to excel

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

Hello,

I have added a new field in item card, which is completed by an automatic import from another interface integrated with NAV 2013 R2. 

The field in NAV is automatically completed correctly and the value showed in item card and list is ok, but when I try to export item list in excel the value of this field is not correct.

When I export item list from the computer of an Admin user it is exported ok. The problem happens with all the other users. 

All users have the same excel version. Can anyone please suggest why is this problem when exporting to excel and only with some users?

Thanks and regards

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    No it doesn't work fine on the other computer. So the issue is not related with users

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    What abt using Admin user on that computer and see if it works fine or not?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    The error is happening on particular computers, but as I checked all of them have excel 2010 versions installed. But I doubt that it may be related with any excel add-ins?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    Admin user only works well from the server. So as I tried with 2 computers the export works well, while with two other computers it is not exported ok.

    That's why I thought that it is related with computer (and excel versions installed on the computer ) and not with users.  I am using NAV 2013 R2.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Item List field is not exported correctly to excel

    Is error happening on a particular excel version or for a particular profile ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    Ideally excel version should not be the issue otherwise it would not work even with Admin user as well. If this is the issue, you might face with other fields of NAV as well.

    What is NAV version (build), that you are using?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    The value is ok everywhere in NAV (table, page) it only appears wrong when exported in excel. No there is not any code written on item list page.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    Do you think it might be related to excel version or add-ins since it happens on some computers, and when exported from admin user on the server it is ok?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item List field is not exported correctly to excel

    Have you checked the value of that field in Item Table direct (not from Page)?

    Is there any code written on Item List Page?

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Item List field is not exported correctly to excel

    Try to restart the services.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans