Announcements
No record found.
Hi,
I have a Trial Balance report where in separate columns I have data for Main Account and different dimensions.
How to find the tables from which Trial balance is created since I want to export this data to MS SQL.
Thank you,
Vesna
Hi vst ,
There is not an entity for Trial balance report in D365FO. Trial balance report generates in D365FO on voucher transaction based on the date interval (from and to), posting layer and financial dimension set, it displays full detail of the ledger accounts.
The data on this report comes from the following sources:
DimensionAttributeValueCombination table
DimensionFocusBalance table
GeneralJournalAccountEntry table
LedgerTrialBalanceTmp table
More info on Micorosof docs:
docs.microsoft.com/.../trial-balance-report-ledgertrialbalance
There is not a standard entity for LedgerTrialBalanceTmp table in D365FO and then you need to create a custom entity for this purpose.
docs.microsoft.com/.../create-entities
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 662 Super User 2026 Season 1
Giorgio Bonacorsi 660
Subra 489
