News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Which tables to use to...

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

Suggested answer

Which tables to use to recreate P&L statement in Power BI

(0) Share

Report

Report

Posted on by alansalloum

30

Dears,

i need to know which tables i have to use to recreate P&L statement in Power BI

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

TeddyH 12,864 Super User 2024 Season 1 on at

Like (0)

Report

RE: Which tables to use to recreate P&L statement in Power BI

You will need to use at least two tables: G/L Account and G/L Entry.

The rest depends on your BC environment.
Guy McKenzie 1,330 on at

Like (0)

Report

RE: Which tables to use to recreate P&L statement in Power BI

The financial data is in the general ledger entries table.

You may also want dimension set ID if you want to do P&L by dimensions other than the two global dimensions.

You need the g/l accounts and possibly account categories to build your report structure.
alansalloum 30 on at

Like (0)

Report

RE: Which tables to use to recreate P&L statement in Power BI

I need also the asset/entities tables and chart of accounts

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans