Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Export to Excel Issue.

Posted on by 25
Dear All, 

  I am facing an issue while exporting invoice journals inside a Project. It is giving this error. /An error occurred while exporting the data to Excel. Please contact your system administrator./
This issue is only with Project invoice Journals table. All the other tables are getting exported to excel without any error.  Even for the server it is working very well only the clients have the issue.  Kindly help me on this. 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    Export to Excel Issue.
    Hi,
     
    You mentioned that it is working OK on the server. Can you check if on the clients the same AX client is installed as on the server?
  • Community member Profile Picture
    Community member 25 on at
    Export to Excel Issue.
    HI, 
          If there is One or more invoices, it still happening the same for every projects. I even tried to select only one line, that also giving the same result. 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    Export to Excel Issue.
    Thanks for the additional details. Do you have the same issue when selecting some records instead of exporting all? How many invoice records do you have? Are there customizations on this form? 
  • Community member Profile Picture
    Community member 25 on at
    Export to Excel Issue.
    Hi, 

    Additionally, the only issue all the user facing only in OVERVIEW Table inside the Project Invoice Journal (Project Management and Accounting > *Any Project* > Manage > Invoice Journals).  On the invoice journals there is two tables one is OVERVIEW and another ON-ACCOUNT.  Even the ON-ACCOUNT table Easly exporting to excel without an error message. But only the OVERVIEW has the issue. Other than this, From the AX all users can export any tables without error to Excel. 
  • Community member Profile Picture
    Community member 25 on at
    Export to Excel Issue.
    Hi, 

    Thank you for your quick response.
           All the client users having the same issue. The option Workbooks supports refresh was already in Never option. Also, While I am trying form the server directly, it is exporting without any error. 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    Export to Excel Issue.
    Hi,
     
    Thanks for the clarification. Do all users have the same issue when exporting to Excel? Can you check what options are set for the Excel export on the user options? Is the option Workbooks supports refresh set to When possible? If so, try to change this to Never.
  • Community member Profile Picture
    Community member 25 on at
    Export to Excel Issue.
    HI Deepak,

               Please assist me, how to export as data entity? While I am exporting to Excel (CTRL+ T), I am getting the only one error I mentioned. /An error occurred while exporting the data to Excel. Please contact your system administrator. /
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    Export to Excel Issue.
    Hi Community member,
     
    Were you able to solve your issue? If not, have you checked execution log details for a possible explanation?
  • Deepak Agarwal Profile Picture
    Deepak Agarwal 148 on at
    Export to Excel Issue.
    Hello, Try to export as data entity once, there you may get clearer details about error. 
  • Community member Profile Picture
    Community member 25 on at
    Export to Excel Issue.
    Hi, 

        Permissions are there, they can even export all other tables except this Project invoice journal. And not only one user all client users are experiencing the same issue. But only from server directly it is working fine.    

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans