1. Details rows/records from Trial Balance

I am looking at a Trial Balance report out of D365 F&O and attempting to reconcile detail rows using Data Entities in a BYODB environment.I can get close using a SQL script but not 100% across all CategoriesMenu = General Ledger > Inquiries and Reports > Trial BalanceHas anyone had any success in reconciling the Trial using Data Entities?Are there detail transactions reports/listings in core D365 Reports to align back to the Trial Balance?Does anyone have access to the backend Visual Studio/SSRS report selection criteria, to aid me in reconciling using Data Entity extracts?

I am looking at a Trial Balance report out of D365 F&O and attempting to reconcile detail rows using Data Entities in a BYODB environment.I can get close using a SQL script but not 100% across all CategoriesMenu = General Ledger > Inquiries and Reports > Trial BalanceHas anyone had any success in reconciling the Trial using Data Entities?Are there detail transactions reports/listings in core D365 Reports to align back to the Trial Balance?Does anyone have access to the backend Visual Studio/SSRS report selection criteria, to aid me in reconciling using Data Entity extracts?

3. RE: Details rows/records from Trial Balance

Thanks Mark. I was also looking to find a way to extract Ledger transactions from D365FO. Setting up an export job in Data Management workspace was pretty straightforward. I could even apply filter criteria to limit the number of rows to export.

I am looking at a Trial Balance report out of D365 F&O and attempting to reconcile detail rows using Data Entities in a BYODB environment.I can get close using a SQL script but not 100% across all CategoriesMenu = General Ledger > Inquiries and Reports > Trial BalanceHas anyone had any success in reconciling the Trial using Data Entities?Are there detail transactions reports/listings in core D365 Reports to align back to the Trial Balance?Does anyone have access to the backend Visual Studio/SSRS report selection criteria, to aid me in reconciling using Data Entity extracts?

4. RE: Details rows/records from Trial Balance

Being able to tie exact Invoice/Sales/SalesLine (Product/SKU) transaction details from the Trial Balance is a requirement from the business users... We're looking to develop PowerBI dashboards (external of the Entity Store) for the business users and this will go along way towards satisfying the data need... This gave me the direction that I was looking for...

Much appreciated...

Great to have this forum as an opportunity to share experience and knowledge...Thank you again...Joe

I am looking at a Trial Balance report out of D365 F&O and attempting to reconcile detail rows using Data Entities in a BYODB environment.I can get close using a SQL script but not 100% across all CategoriesMenu = General Ledger > Inquiries and Reports > Trial BalanceHas anyone had any success in reconciling the Trial using Data Entities?Are there detail transactions reports/listings in core D365 Reports to align back to the Trial Balance?Does anyone have access to the backend Visual Studio/SSRS report selection criteria, to aid me in reconciling using Data Entity extracts?