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

(1) Share

Report

Posted on by DaveHorsley

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

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

DaveHorsley 20 on at

Like (1)

Report

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

Thank you, your help is much appreciated!!
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

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.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel?WT.mc_id=email&sharingId=DX-MVP-5005315

Could be an option worth looking into.