Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Purchase Order Lines list page > how to Filter the Records ?

Posted on by 345

Hi -

   I need to update Purchase Order Lines List page to view all the records with the item Number column not empty. I only need those lines listed on the listpage which have the item number present. How can I achieve this ?

Please take a look at the screen shot.

Capture3333.JPG

As you can see these records have no Item numbers. I need to remove these records from the list page when the list page is opened.

Any help is appreciated.

Thanks

*This post is locked for comments

  • Muhammad_Ali Profile Picture
    Muhammad_Ali 345 on at
    RE: Purchase Order Lines list page > how to Filter the Records ?

    Thanks Sukrut

  • Suggested answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at
    RE: Purchase Order Lines list page > how to Filter the Records ?

    You have these options I can think of,

    1. Save that filter and add that list page to favorites, and then edit the favorites to apply that saved query. So user can use that favorite to open the list page without manually enterting criterion.

    2. Change the query behind that form to exclude records without empty item id.

    3. Use XDS security framework to exclude the records without empty itemid for those users don't want to see.

  • Muhammad_Ali Profile Picture
    Muhammad_Ali 345 on at
    RE: Purchase Order Lines list page > how to Filter the Records ?

    Andrew -

      That is correct but the users don't want to manually enter the filter. The form should automatically open without the lines which have no Item numbers. ?

    Thanks

  • Suggested answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at
    RE: Purchase Order Lines list page > how to Filter the Records ?

    Muhammad,

    You can put ?* in the filter box of Item Id and hit enter.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans