Creating a General Ledger Report

(0) Share

Report

Posted on by Trevor Cohen

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,

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Frank Hamelly | MVP... 46,631 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Trevor Cohen 131 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
JamesT 341 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,631 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No