Hi all
I'm building a consolidated TB in PowerBI but I need Debits and credit amounts in our reporting currency GBP. The Data entities picked up and pushed into our BYODB data warehouse only show accounting or transactional - am I able to adjust or build a new data entity which would include reporting amounts? not sure where the fields would be.
Thanks!
Hi James,
An article about creating a trail balance in POWER BI is found for you. The article mentions the detailed steps of creating it. You can view the article and pay attention to the content of the screenshot:
Creating a Power BI Trial Balance for Month End Audit and Accounting Processes – Five Ledger
Best Regards,
Hana
Thanks Hana - useful article. My main issue currently is having access to the full set of data on the GeneralJournalAccountEntry. The data entity which I have in use and is exported to our warehouse only includes the accounting and transactional amounts, whereas I am looking for the reporting amounts for debits and credits which should be set to GBP. What I need is a way to explore and configure the data entities. Cheers
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
