Announcements
Dears,
i need to know which tables i have 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.
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.
I need also the asset/entities tables and chart of accounts
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156