Notifications
Announcements
No record found.
We're having a requirement to filter the Product lookup on Work Order Product down to those Products that have a Price List Item associated with the Work Order Products Price List.
(Same requirement as here (from 2018): https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/270933/addcustomfilter-not-working-as-expected-neither-in-line-nor-lookup )
When using the "standard way" to create such a Java Script filter we're getting "0x80072500 Invalid URI: The Uri string is too long" because the API call retrieves too many values (too many Products).
According to MS support there is a different behavior between classic UI and UCI.
We've tried with batch also but that didn't work neither.
Has anyone an idea how this can be solved?
Is it possible for you to acheive this with OOB filtering without JavaScript? Maybe by populating a field on the wop form so you can filter the products without using code.
Hi Thomas, thanks for your suggestion. A new simple lookup field wouldn't be enough to get the filter functionality of a Price List Item as in sales module.
But a new n:n relationship between Product and Price List with one entry per Price List Item does the filtering job.
So we decided to solve that with a mixture of several Flows, Work Flow and a additional custom entity. So that for each Price List Item one n:n record is created and, this is where it gets more tricky, on delete of a Price List Item, this n:n record gets deleted as well..
Surely you could add a plugin here to have a less complicated processing and fewer API calls.I was wondering whether there is a more economic solution / best practice to not have to replicate all these relationships.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 55 Super User 2025 Season 2
Daniyal Khaleel 27 Most Valuable Professional
Soundari 15
