2,983
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
Perhaps this can also be useful: dynamicsuser.net/.../page-with-header-and-lines
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (