Announcements
No record found.
Dear All
How to get month wise sales report
*This post is locked for comments
Could you please invest a few minutes to explain your problem in detail?
Dear Martin Drab
I want to show sale report month wise in each row
let suppose
month qty amount
January 2016 10 1000
February 2016 10 1500
like as
get sum of amount, qty and amount of eache month
Yew, but I still don't know with which part you need help. Where did you get stuck?
get month wise sum
how to get month wise sum
have any function use in query to get month wise sum
Hi Muhammad,
Probably you can create a temporary table with the columns as desired on the report. Then create a data provider (classes) in AX to fill this table aggregated the way you need to display your rows.
Have also a look at the next a bit similar thread: community.dynamics.com/.../187137
another ways can be calling SQL using userconnection from inside AX, but in such case DatAreaId and Partition must be take care of
I would create a view with month as a computed column. Then I would use a query with sum + group by month.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Joris dG 5
Alexey Lekanov 2
Henrik Nordlöf 2 User Group Leader
