Small and medium business | Business Central, N...

I'm facing an error when use function Open in Excel from General Ledger Entry screen.

(1) Share

Report

Posted on by Kittamet R.

Hi, Expert

I got an error when use function Open in Excel on General Ledger Entries screen. So before this error occur I've upgraded from BC v20 on-premise to BC v23.7 on-premise but in v20 can export as usual but v23 cannot with the same amount of data. And I've created xml port to export data. It's able to export.

Anyone have seen this issue before?. Please advise me. Thanks in advance.

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (0)

Suggested answer

Valentin Castravet 28,272 Super User 2025 Season 1 on at

Like (1)

Report

I'm facing an error when use function Open in Excel from General Ledger Entry screen.

Hope this helps as well - Operation Limits in Dynamics 365 Business Central - Business Central | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Kittamet R. 33 on at

Like (1)

Report

I'm facing an error when use function Open in Excel from General Ledger Entry screen.

Hello Mustafa,

The error details after copy details say nothing more than detail in the picture above but in v20 on-premise I can export GL Entries with 500K ++ record and file size around 200MB.

and this is error details from event viewer.

Thank you for your reply
Mustafa Omerbegović 1,420 Super User 2025 Season 1 on at

Like (0)

Report

I'm facing an error when use function Open in Excel from General Ledger Entry screen.

Hello Kittamet,

Could you please paste us the error details (AL call stack) if you still have this problem?
I tried to ''Open in Excel'' 25k GLE on the on-prem and SaaS v23 and did not get any error.

Greetings
Kittamet R. 33 on at

Like (0)

Report

I'm facing an error when use function Open in Excel from General Ledger Entry screen.

Hi Khushbu Rajvi,

How to check code compatibility? but I tried to filters more fields to reduce amount of data. It's able to export.

Thank you for your reply.
Khushbu Rajvi. 17,402 Super User 2025 Season 1 on at

Like (3)

Report

I'm facing an error when use function Open in Excel from General Ledger Entry screen.

Have you checked code compatibility?