G/L Register Report - Send to Excel (Data Only)

(3) Share

Report

Posted on by SL_GP_BC_123

759

My customer was trying to export the G/L Register Report from BC using the "Send To", "Excel - Data Only" option. They received the error below. I've duplicated the error in both their live environment and in a separate demo environment.

Is there a potential issue with the report or is it possible that the report's design just does not support the "Excel - Data Only" option? I suspect the latter as the on screen output is layered and does not appear to be conducive to any data style of export. Please advise. Look forward to a response:

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Sohail Ahmed 11,086 Super User 2025 Season 2 on at

Like (2)

Report

G/L Register Report - Send to Excel (Data Only)

@JGarcia123
This is a known bug and a fix is expected soon. In the meantime, a temporary workaround is to change your timezone in your user settings."

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,869 Super User 2025 Season 2 on at

Like (4)

Report

G/L Register Report - Send to Excel (Data Only)

Hello,

This bug has been resolved by Microsoft in Version 26.2, Just check it out.

https://support.microsoft.com/en-gb/topic/update-26-2-for-microsoft-dynamics-365-business-central-2025-release-wave-1-application-build-26-2-34832-platform-build-26-0-34736-4e0fb86d-5340-4b6a-8754-87ffcdde2620

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Gerardo Rentería Ga... 23,574 Most Valuable Professional on at

Like (2)

Report

G/L Register Report - Send to Excel (Data Only)

Hi, good day
I hope this can help you, and give you some hints.

Viva Engage : Dynamics 365 Business Central Partner Community (Formerly: Development) : Ver conversación

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 19,137 Super User 2025 Season 2 on at

Like (2)

Report

G/L Register Report - Send to Excel (Data Only)

Yes, its bugs Microsoft aware of it. fix will be release soon. Select anytime zone from below and test.

Was this reply helpful? Yes No
Verified answer

Mansi Soni 8,869 Super User 2025 Season 2 on at

Like (4)

Report

G/L Register Report - Send to Excel (Data Only)

Hello,

Yes, this issue with exporting reports in Excel (Data Only) format while using certain time zone settings - particularly US Eastern Standard Time - has been identified as a known bug in the current release of Business Central (not report-specific). Changing to time zones like UTC+5 has temporarily resolved the issue for some users, however this is not a viable long-term solution.
Currently, you can monitor the Microsoft Dynamics 365 Business Central Release Notes page or follow the Microsoft Learn support and community forums for updates. If this issue has been logged with Microsoft Support, your administrator or partner should be able to follow up using the associated support ticket for progress.
Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
SL_GP_BC_123 759 on at

Like (3)

Report

G/L Register Report - Send to Excel (Data Only)

Steven,

Appreciate the update. Two quick follow up thoughts:

First, I tried different timezone settings, but still getting the same results. Was there specific timezones that were impacted. We are in US Eastern Standard Time, I tried several other US Time Zones plus some random foreign time zones, but still get the same export error. I also duplicated the error with a variety of reports, so it was not report specific.

Secondly, is there a "Bug" list or page that I can monitor to see if there is any progress or updates on this issue?

Please advise. Look forward to a response.

JG

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,668 Moderator on at

Like (3)

Report

G/L Register Report - Send to Excel (Data Only)

This is a bug, and will be fixed soon.

A workaround is to change your timezone in the settings.

Was this reply helpful? Yes No