Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to extract Trail Balance from AX tables

Posted on by

Hi,

I am not an experienced in AX, but want to extract opening and closing Trail balance for all GL accounts from AXtable, I cannot extract from AX application.

Please help me to extract from backend tables.

*This post is locked for comments

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
    RE: How to extract Trail Balance from AX tables

    Getting the trial balance data is not easy . You can check logic in LedgerTrailBalanceDP class how the calculations are done and data is pulled in to the report.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to extract Trail Balance from AX tables

    Hi

    Have you been able to get this fixed with the help of the standard cubes?

    Is there anything where you get stuck or have you been able to get your issues resolved?

    Would be great if you could keep us updated.

    Many thanks,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to extract Trail Balance from AX tables

    Hi,

    Why do you need that?

    The trial balance shows you summarized data for your account findim combinations for the period selected.

    Trying to rebuild this somewhere outside requires that you extract the original accounting data and do the same summary calculations outside. That can mean quite some work.

    An alternative might be the use of the standard cubes. Have you checked out them?

    Best regards

    Ludwig

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans