Dears,
i need to know which tables i have to use to recreate P&L statement in Power BI
I need also the asset/entities tables and chart of accounts
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.
You will need to use at least two tables: G/L Account and G/L Entry.
The rest depends on your BC environment.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,327
Sumit Singh 2,734
Nimsara Jayathilaka. 2,599
