You’re offline. This is a read only version of the page.
5
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!
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
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.
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.
#1
Martin Dráb
501
Most Valuable Professional
#2
Saalim Ansari
315
#3
Abhilash Warrier
310
Share
Report
All responses (
Answers (
