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