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
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
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.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,235 Most Valuable Professional
nmaenpaa 101,156