General Ledger tables

(1) Share

Report

Posted on by Yi Han Wong

Hi all,

We are trying to extract the general ledger data from D365 F&O from the back end using BYOD (https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/export-entities-to-your-own-database).

Does anyone know which tables in D365 relates to the general ledger?

Kind regards,

Yi Han

Categories:

Data Integration

Financial Management

I have the same question (0)

All responses (7)

Answers (0)

Sort by

André Arnaud de Cal... 306,356 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Yi,

You are asking about tables. BYOD works with data entities. Is your question if there are standard entities available or do you need table names to create an own entity?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I would start by looking at data entities with word Ledger in the name. I assume you are looking for data entities, not tables, since BYODB export uses entities.

Was this reply helpful? Yes No
Suggested answer

Ties Philippi 962 on at

Like
a
(1)

Report
Copy link

Link copied!

I would assume you want the GeneralJournalAccountEntryEntity (name = General Journal Account Entry). This contains the transactions basically like you would get from the trial balance.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hello Yi Han,

If you could provide some additional information what kind of general ledger data you are looking for and what you try to do with them then it would be much easier guiding you what to look out for.

Would be great if you could spend a couple of minutes to explain what you try to achieve.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Yi Han Wong 5 on at

Like
a
(0)

Report
Copy link

Link copied!
I did some further digging and it turns out that the table I needed are

GeneralJournalAccountEntry

GeneralJournalEntry

I was slightly surprised by this as I did not expect D365 to have the same table structure as Dynamics AX.

By joining the GeneralJournalEntry column from GJAE to the recid column in GJE I was able to have the GL data (including entities, dates, descriptions, users etc) in one table.

Was this reply helpful? Yes No
MYGz 2,473 on at

Like
a
(0)

Report
Copy link

Link copied!

You will get the Journal Batch Number from LedgerEntryJournal table. It maps to the journalnum in Ledgerjournaltable. The JournalNumber column in GeneralJournalEntry is not the same as journalnum in LedgerJournaltable.

But I'd go with Andre's and Nikolaos's suggestion anyway.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,356 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

So, your question was about the tables. However, have a look at the standard entity mentioned above which already has the option to export the ledger entries.

If you are not aware: Dynamics 365 for Finance and Operations was an evolution of AX 2012 R3. The same data model and code base was used to create the new browser based version.

Was this reply helpful? Yes No