web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Query is not working o...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Query is not working on functional side

(0) ShareShare
ReportReport
Posted on by Laraib 131

I have update a query of Generate Earning in Payroll Module. Actually I have add employ type drop down in query (PayrollStatementGenerationQuery) and it is showing dropdown in developer side when i run the query but when i tried to open form it is showing previous version. I've also run CIL and full CIL but it is still not working.

Here are screen shots of query in which I have created new data source of HcmEmployment table.

query

when i run query in developer side then it is showing dropdown of employ type

query

but when I tried to do it from functional side it is showing old version of query here are the screen shot below

query

query

query

I have the same question (0)
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 239,029 Most Valuable Professional on at

    AX typically shows you the query that you used the last time, therefore you don't have to fill in ranges and such things again. But your new range wasn't there and that's why you don't see it.

    I think it'll be solved if you simply press "Reset" button (can be seen in your second screenshot).

  • Laraib Profile Picture
    Laraib 131 on at

    Fist of all I would like to thank you for answering my question. Secondly I have done it as you said but it is still not showing.

  • Martin Dráb Profile Picture
    Martin Dráb 239,029 Most Valuable Professional on at

    Then look at the "Select query" lookup at the top. Unfortunately I don't remember the exact options there.

    And of course, make sure that the change was correctly deployed to "functional side". I'm not sure what you mean by that.

  • Suggested answer
    Laraib Profile Picture
    Laraib 131 on at

    This issue has been resolve via running Full compilation and full CIL.

    Thanks Martin Drab for your guidance and help

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

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