Skip to main content

Notifications

Announcements

No record found.

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

Historic Financials - Live OData Connection from BC to Excel for Trial Balance

(1) ShareShare
ReportReport
Posted on by 20
Hello,
 
I'm looking to connect my financial model directly to our business central trial balance.
 
The 'manual' way of connecting my models in the past is to download the trial balances as at the month end, save them to a folder and then use power query to bring them into excel as a table of 'actuals'. Whilst this process works i'd like it to be more automated. 
 
I have experiment using an  OData connection to ObjectID 5502. What I get by using that ID is the live trial balance. Is there a way to get month end summaries into Excel? Can anyone recommend a way to do that? 
 
The alternative I thought would be to have a hard coded opening trial balance and then connect to the GL entries report to get the movements.
 
Many thanks in advance,
David
 
 
 
  • DaveHorsley Profile Picture
    DaveHorsley 20 on at
    Historic Financials - Live OData Connection from BC to Excel for Trial Balance
    Thank you, your help is much appreciated!!
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    Historic Financials - Live OData Connection from BC to Excel for Trial Balance
    I would definitely be possible to create a API that gives you those data.
    But I think it would be a more future proof option to create a Power BI dataset and then connect Excel to your Power BI dataset.
    Could be an option worth looking into.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans