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

Excel layout shows no data and #N/A errors for reports 107 and 113

(2) Share

Report

Posted on by MS-03121326-0

Hello,

We're experiencing an issue with two standard BC reports (Customer/Item Sales 113 and Customer - Order Summary 107) when using Excel layout. Both reports work correctly when using Word and RDLC layout. Has anyone encountered this issue with these reports?

BC Version: W1 28.2 (Platform 28.0.52048.0 + Application 28.2.50931.52241)

Any help appreciated!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

OussamaSabbouh 18,776 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Since both report 113 (Customer/Item Sales) and report 107 (Customer - Order Summary) have standard Excel layouts introduced in Business Central 2025 release wave 2, and the same reports work correctly with Word/RDLC, this points more to an issue with the standard Excel layouts in your specific BC 28.2 build rather than with the report dataset itself. I would first test the reports in a clean sandbox on the same version, export the standard Excel layout from Report Layouts to confirm it is not corrupted, and test whether importing a fresh copy resolves it. If the issue is reproducible in a clean standard environment with no customization, I would raise it with Microsoft support as a potential product issue/regression and include the exact error message and reproduction steps.

Regards,
Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,765 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

I ran a test, and there is indeed an issue with 107; I changed the conditions multiple times but still got no data.
There are no issues with 113.

107:

RDLC

113:

Thanks

ZHU

1 people found this reply helpful.

Was this reply helpful? Yes No