web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Group inventTrans reco...

Finance | Project Operations, Human Resources, ...

Answered

Group inventTrans records by month with X++

(0) Share

Report

Report

Posted on by AR-16051714-0

81

Hello everyone,

I need to be able to group item inventory receipt transactions by month. In SQL, this is not complicated using group by and month(), but in X++ there is no month clause, so I haven't found an alternative to do it. I have checked several forums and haven't come across similar problems. Any possible solution is welcome.
Thank you very much in advance.

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Martin Dráb 240,961 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Which version of AX are you using? If it's AX 2012 or F&O (which has a different forum), you can create a view with a computed column returning the month number (using the month() SQL function). Then you'll simply group by this computed column.

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 555 Most Valuable Professional

#2

André Arnaud de Cal... 484 Super User 2026 Season 2

#3

CU10121822-0 378

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans