Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Creating a General Ledger Report

(0) ShareShare
ReportReport
Posted on by 131

Hi,

If I wanted to create a General Ledger report using either the data entities available in Data Management or in the "Open in Excel" feature.  Do you know which data entities would work best.

I am trying to get a GL report that will autorefresh and that is in excel.  We are trying to not have to always run a new GL thru "Financial Reports"

Thanks,

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,257 Super User 2025 Season 1 on at
    RE: Creating a General Ledger Report

    Not that I'm aware of.  You could have a custom data entity developed for that purpose.

  • JamesT Profile Picture
    JamesT 341 on at
    RE: Creating a General Ledger Report

    Hi Trevor,

    I cannot confirm that the below will give you what you want, but they might help.

    A while back I started playing with PowerBI Desktop and Odata connection, to try and see if I could do what you mentioned - Financial reporting outside D365FO.  But I admit I gave up as the ODATA connection was way to slow.

    However below were the entities I started with

    pastedimage1679611257360v1.png

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at
    RE: Creating a General Ledger Report

    Hi - It does, once I click into the "Closing Balance" and see the line item details.

    Is there a way to export the Trial balance thru data entities/data management?

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,257 Super User 2025 Season 1 on at
    RE: Creating a General Ledger Report

    Does the out of box Trial balance inquiry not meet your needs?  General ledger>Inquiries and reports>Trial balance.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans