Notifications
Announcements
No record found.
i need to create sql query for Summery Trial Balance Report from sql by comparing date
for example today of this current year with today of last year
how can i do that with SQL query ?
*This post is locked for comments
thanks i see that but i'm facing problem to create sql query for that i'm trying but it's so difficult to create it's be more confusing any idea for that because i'm thinking to move that query to Power bi
Hi Mohammed,
If you want to use the data for a power BI report, you can have a look at the Entity store option: blogs.msdn.microsoft.com/.../introducing-entity-store-for-dynamics-ax-2012-r3
Then data import export framework can be used to export flattened ledger transactions in to another database which can be consumed by PowerBI.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
