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 / Microsoft Dynamics NAV (Archived) / Filter the Product Loo...
Microsoft Dynamics NAV (Archived)

Filter the Product Lookup in the Purchase order Lines

(0) ShareShare
ReportReport
Posted on by Ghetz 3,029

Is there a standard functionality to filter the 'No.' field of Purchase order lines so that only Items with "Vendor No." = "Purchase Header"."Buy to Vendor No" are available in the lookup dropdown?

If not, what would be the best approach to develop? We want the dropdown to display only the Vendor's items, but if the user clicks on advanced, he must be able to select any product, so the customization must only affect the dropdown list.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    You need to have the value in the Buy-from vendor No. field of the purchase line to add that filter on the No. field of TableRelation, so for that add the code in the Purchase Line Table in the InitType function to assign the Buy-from vendor No. Value also add the code in the OnInsert Trigger of the purchase line table.

    Since it will have a value after you added the above code, you can now add that filter in the No. field of TableRelation Filter, since you want the users to remove the filter and add any other item, in that case on that field you need to Set No to TestTableRelation or ValidateTableRelation Property.

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    edit table purchase line, select field "no.", edit property table relation, add table filter "Vendor No.=FIELD(Buy-from Vendor No.)" to condition="Type=CONST(Item)" | table=item.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    Perhaps this can also be useful: dynamicsuser.net/.../page-with-header-and-lines

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans