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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to hide old record

(0) ShareShare
ReportReport
Posted on by

Hi,

We are trying to find a way (through the interface) how to hide (or archive) old records.

When a user open the gird of the purchase requisitions, the grid shows first the old req and we need to scroll up each time, thousands of records.
These requisitions are CLOSED and never used.

pastedimage1636638739747v1.png

Thank you !

I have the same question (0)
  • Suggested answer
    Alex Voytsekhovskiy Profile Picture
    on at

    Try to use filters docs.microsoft.com/.../filtering

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Have you tried enabling the new grid / view functionality that allows you filtering and illustrating forms as needed?

    Best regards,

    Ludwig

  • Suggested answer
    Alex Voytsekhovskiy Profile Picture
    on at

    pastedimage1636640683844v1.png

  • Finance and operations Profile Picture
    on at

    Thank you both for your responses.

    The grid/view I have enabled and tested in Sandbox, we are not ready to publish it, since communication should be sent and I noticed some bugs on it.

    What I'm looking is not filtering after opening the grid, but having a smart filter for users when they open the grid, the old records are never shown.

    Thanks again !

    Kamel.

  • Alex Voytsekhovskiy Profile Picture
    on at

    Once you saved your filter as Default view, it becomes 'smart' :)

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,679 Super User 2025 Season 2 on at

    Hi Kamel,

    You can save this view so you can use as a default view:

    pastedimage1636652128768v2.png

    You can also export this view (i.e. filter that you have created) and then import for users or security role so that other can have same view.

    pastedimage1636652189957v3.png

  • Finance and operations Profile Picture
    on at

    Hi Alex,

    Please share how you save a filter (I'm not using the View), when I reload the page, the filter is reset and all the data is back.

    Thank you !

  • Alex Voytsekhovskiy Profile Picture
    on at

    Hi Kamel,

    Filters can be saved under a particular view.

    Alireza already shared it with you. Please check it and find more detail by the URL I provided you with.

  • Finance and operations Profile Picture
    on at

    Hi Alex,

    This I got, a business decision was taken to not enable the feature Saved view (not yest tested and need to send communication to users). Alireza's solution I'm using it in Sandbox, but in production, we are looking on a way how to save a filter (removing old data) without tis feature.

    I think it is just not feasible without this feature

    Thank you all!

  • André Arnaud de Calavon Profile Picture
    301,030 Super User 2025 Season 2 on at

    Hi Kamel,

    I would recommend to put effort in testing the Saved views feature. This feature is supported by Microsoft and would prevent the need for a customization.

    Saved views - Finance & Operations | Dynamics 365 | Microsoft Docs

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans