Skip to main content

Notifications

Business Central forum
Suggested answer

Business Central - No data connection to ExcelTemplateBalanceSheet-How to correct?

Posted on by 37

I am able to create and run reports just fine using Account Schedules.

However, I notice we also have a "Reports" area on the main screen under "Actions".

The "Financial Statements" work fine.

The "Excel Reports" do not.  I would think this would just be the excel version of the Financial Statements, but when I run any of the statements, this seems to require a data connection, and there is not one set up.

How do I connect the data so I can utilize these excel reports?

Here's where I'm running the Excel Reports:

4666.pastedimage1661289528772v2.png

And here's what I get for the Balance Sheet - no data - I assume due to no connection:

2018.pastedimage1661290208382v3.png

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Business Central - No data connection to ExcelTemplateBalanceSheet-How to correct?

    Hello,

    If you do not get further traction from the community, feel free to raise this issue to Microsoft via your partner or CSP.

    Thanks.

  • Martin Dráb Profile Picture
    Martin Dráb 228,441 Most Valuable Professional on at
    RE: Business Central - No data connection to ExcelTemplateBalanceSheet-How to correct?

    Moved from Dynamics 365 Finance Forum to Dynamics 365 Business Central Forum.

  • chicadeaqua Profile Picture
    chicadeaqua 37 on at
    RE: Business Central - No data connection to ExcelTemplateBalanceSheet-How to correct?

     More info on this - when I look at the second tab in the workbook, I see data, basically the chart of accounts with balances, so data is definitely coming through, it's just not populating the first tab, which is the actual report.  When I click on the Microsoft Dynamics data connector, I see there is a connection...so I just don't understand why the report doesn't have data:

    Here's the excelTemplateTrialBalance report:

    5773.pastedimage1661292095454v1.png

  • chicadeaqua Profile Picture
    chicadeaqua 37 on at
    RE: Business Central - No data connection to ExcelTemplateBalanceSheet-How to correct?

    A little more info - On the 2nd tab of the workbook, there is data, in a table...when I run the Exceltemplatetrialbalance report, I get basically just the chart of accounts with the current balances.  So data is coming through, it's just not populating the report on the first tab.

    Any ideas as to why this would be blank?:

    6735.pastedimage1661291807971v1.png

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans