web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Financial Report error

(2) ShareShare
ReportReport
Posted on by 615
When running VAT declaration reports, users with restricted access to legal entities may get reports generated with empty data.
Détails du problème 834697 still in 10.0.49 !!
-→ old reference to that issue see below

If user has access to all entities, the file have all the details.
 

 
Note: We are aware that with new design, we can run the VAT declaration for multiply entities, but it should not impact force to give access to all entities.
 
 

If user run report in ‘multi-legal entity mode’, the report should contain data for those entities that access is granted.Détails du problème 771876
 

  • Suggested answer
    Nyakinyua Profile Picture
    139 on at

    Hi @BBBCMAN , I would suggest you Rebuild the definitions in 28.5 rather than carrying them over from 29.0, since moving from a newer version to an older one isn’t a supported direction. I couldn’t confirm this is the cause, but it’s worth ruling out.

    Best,
    Nyakinyua.

  • Suggested answer
    Teagen Boll Profile Picture
    4,397 Super User 2026 Season 2 on at

    I would recommend upgrading your production to 29 before migrating those reports as Nyakinyua mentioned. There may be changes to the financial reports in V29 that break compatibility with older BC versions.

     

    Best,

     

    Teagen Boll, CPA
  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    3,944 Super User 2026 Season 2 on at

    Hi, the main thing I see is the version gap. You build on 29.0 and import into 28.5, and this direction is never really safe, the definition package from 29 can carry stuff that 28.5 doesn’t read the same way. I wouldn’t trust it until prod is on 29 too.

    For the Excel Buffer error, I’d first check if it’s the layout and not the rows. Run one of the standard Microsoft financial reports in production with Open in Excel (using layout). If that one works, then most likely your imported Excel layout, which was made on 29, is the problem. Generate a fresh template in 28.5 with Run/Export on the Financial Report Excel Layouts page, move your formatting to it and import it again.

    About the second message, as far as I know it shows when BC sees the definition as system maintained. Say Yes, work on the copy and point the report to it. Is it all the reports, or only the ones you imported?

    ►  If this solved it, marking it verified helps others too.       

    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

  • Suggested answer
    YUN ZHU Profile Picture
    104,246 Super User 2026 Season 2 on at

    BC29 added a few updates that weren't in BC28, so that's probably what's causing this.

    Under the current circumstances, the only option is to recreate it manually.

     

    Thanks.

    ZHU

  • Suggested answer
    OussamaSabbouh Profile Picture
    20,999 Super User 2026 Season 2 on at

    Hello,

    These are actually two separate things. The second message (“This report definition may be automatically updated…”) is not an error; Business Central shows it when you try to edit a system-generated financial report definition, and choosing Yes creates a copy that you can safely modify. The Excel Buffer error is more significant and I would not spend time looking for duplicate row/column definitions—Microsoft has already fixed a Financial Reporting defect (Bug 641503) where Report 29 Export Acc. Sched. to Excel could generate duplicate/stale Excel cells when financial reports used dimension/G/L Budget filters and Excel layouts. The fix was merged into the newer codebase before BC 29.0, which fits your observation that 29.0 sandbox works while 28.5 production fails, and I could not find the same fix backported to the 28.x branch. Your test with a newly created report also points to the standard application code rather than corrupted imported definitions. I would therefore reproduce it with a standard report in a clean 28.5 sandbox and, if confirmed, either upgrade production to 29.x or open a Microsoft support case requesting the corresponding 28.5 hotfix/backport rather than rebuilding all the financial reports.

    Regards,
    Oussama Sabbouh

  • BBBCMAN Profile Picture
    615 on at

    Thanks everyone for your kind reply.  We have upgraded to 29.0 and I created a brand new report using M-BALANCE row and column default and I am able to open row definition no error and Open in Excel getting same error.  I tried workaround to go to print then use the Send to and selected Microsoft Excel Document (data and layout) worked fine.  But not sure how to fix Open in excel directly and my sandbox works perfectly alright using this option.  After update following is the version numbers I can see.

    Sandbox - Central 29.0 (Platform 29.0.56880.0 + Application 29.0.54011.56829)

    Production - Central 29.0 (Platform 29.0.56880.0 + Application 29.0.54011.57244)

     

     

  • BBBCMAN Profile Picture
    615 on at

    Hi All,

    on this post my original query is replaced with something else do any of you having this issue.  on top of this post something else replaced my question as below.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 569 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 375 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 228 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans