You’re offline. This is a read only version of the page.
Announcements
5
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
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.
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.
I did some further digging and it turns out that the table I needed are
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.
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
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.
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,186
Super User 2024 Season 2
#2
Martin Dráb
227,996
Super User 2024 Season 2
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (