Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 512 Super User 2026 Season 1
Giorgio Bonacorsi 386
Adis 259 Super User 2026 Season 1
