D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Details rows/records from Trial Balance

  • 1.  Details rows/records from Trial Balance

    Posted Feb 07, 2019 07:48 PM

    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 Categories
    Menu = General Ledger > Inquiries and Reports > Trial Balance
    Trial Balance
    Has 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?

    Your guidance and assistance is appreciated in advance.

    Joe MacPherson
    Coldwater Creek
    Hingham MA

  • 2.  RE: Details rows/records from Trial Balance

    Posted Feb 08, 2019 08:47 AM
    Have a look at the GeneralJournalAccountEntity data entity.  This hold all of the gl transaction detail that supports the trial balance.

    Mark Schurmann
    Accounting Systems Manager
    Automobile Protection Corp
    Norcross GA

  • 3.  RE: Details rows/records from Trial Balance

    Posted Feb 08, 2019 11:11 AM
    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.

    Thanks again,
    Robert D M

    robert mohammed
    Ansa McAl Limited

  • 4.  RE: Details rows/records from Trial Balance

    Posted Feb 09, 2019 11:33 AM
    Hey Mark...

    Sorry for the delay in the response - Thanks for the lead...

    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 MacPherson
    Coldwater Creek
    Hingham MA

If you've found this thread useful, dive deeper into User Group community content by role