Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Can someone help me to create SQL query for Trial Balance report monthly/Yearly- Dynamics AX 2009?
Which are the list of tables I can use?
Why can't you use the standard trial balance report or the Management Reporter that is doing that for you?
Hi there. thank you for your response.
We are still using AX 2009 so we would Like to find road blocks if its there any, and Help us identifying the AX back end data structures on IT prospective .
Also, Validate our understanding matches to the report which created by our accounting team.
I am just trying to create a view for this Trial Balance report so they run it and compare the data.
If you can provide some information on Table and query that would be great.
I don't have access to AX2009 anymore, but I thought the table names were: LedgerBalances and LedgerBalancesDim which contains aggregated information per account, per date. The second table also per financial dimension.
Business Applications communities