Export to Excel Issue.

(0) Share

Report

Posted on by JP-18120653-0

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.

All responses (11)

Answers (0)

André Arnaud de Cal... 291,431 Super User 2024 Season 2 on at

Like (0)

Report

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?
JP-18120653-0 25 on at

Like (0)

Report

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 Cal... 291,431 Super User 2024 Season 2 on at

Like (0)

Report

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?
JP-18120653-0 25 on at

Like (0)

Report

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.
JP-18120653-0 25 on at

Like (0)

Report

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 Cal... 291,431 Super User 2024 Season 2 on at

Like (0)

Report

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.
JP-18120653-0 25 on at

Like (0)

Report

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 Cal... 291,431 Super User 2024 Season 2 on at

Like (0)

Report

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 148 on at

Like (0)

Report

Export to Excel Issue.

Hello, Try to export as data entity once, there you may get clearer details about error.
JP-18120653-0 25 on at

Like (0)

Report

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.