Notifications
Announcements
No record found.
Hi,I have accessed a D365 online database through an API. I can display all the tables, but struggles when I try to find the relevant tables to display the general ledger transactions. I know that the table containing most GL transactions in the Dynamics AX were called "LedgerTrans", but does anyone know what's the name of the table/tables containing the general ledger data for the D365 online? Thanks in advance for any help!
What API are you using? It's not possible to access the database tables via any API in the standard application.
Anyway, GeneralJournalAccountEntry is the core table for ledger transactions.
Hi OTDynamics,
A small addition here: LedgerTrans was a table in AX2009 and before. As of AX2012 en now in Dynamics 365 there are two tables:
- GeneralJournalEntry
- GeneralJournalAccountEntry.
The data model has been normalized where the first table contains some voucher general data (one record per voucher) and the details are stored in multiple records containing e.g. the account, dimensions and the amount.
I am not going to repeat what Andre and Nikolaos said but if you want to see complete picture of replacement tables for LedgerTrans , download whitepaper from below link to get better understanding . Some sample x++ queries are also part of this white paper to get better understanding.
docs.microsoft.com/.../mapping-the-ledgertrans-table-to-general-journal-tables-white-paper
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 646 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
