Dears,
i need to know which tables i have to use to recreate P&L statement in Power BI
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148