web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Consolidated TB in reporting amount for reporting

(0) ShareShare
ReportReport
Posted on by 5

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!

I have the same question (0)
  • Hana Xue Profile Picture
    Microsoft Employee on at
    RE: Consolidated TB in reporting amount for reporting

    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:

    pastedimage1684292747488v1.png

    Creating a Power BI Trial Balance for Month End Audit and Accounting Processes – Five Ledger

    Best Regards,

    Hana

  • James Jones 100 Profile Picture
    5 on at
    RE: Consolidated TB in reporting amount for reporting

    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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans