Announcements
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 671
André Arnaud de Cal... 621 Super User 2026 Season 1
Abhilash Warrier 589 Super User 2026 Season 1
