You’re offline. This is a read only version of the page.
219
Hello,
on the mainformular of quotedetail is a lookupfield called productid.
when I click on the "glass" to start the search of the lookupfield, I only get 3 products back in the preview.
I already found the reason: In the fetchxml that is send there is the distinct="true" missing.
The search gives more results back, bad several times the same product because the distinct is missing.
Is there a way to add the distinct to the fetchxml?
Do other have the same problem?
Hi McDauly,
You are using Products in Parent Price List view, right? You could check/edit the fetch xml of view by FetchXML Builder in the XrmToolbox. I have checked this view, there is the distinct="true":
The products showed in this lookup field is based on the Price list you select in the Quote. You could try to add price list items to make products you need show in this lookup field.
1. Click the Price List in your quote.
2. Add price list items.
3. Check the products in the Existing product of Quote line.
Reference:
Add products to quotes, orders, or invoices (Dynamics 365 Sales) | Microsoft Docs
#1
Siv Sagar
149
Super User 2025 Season 1
#2
Muhammad Shahzad Sh...
61
Most Valuable Professional
#3
Daivat Vartak (v-9d...
53
Super User 2025 Season 1
Share
Report
All responses (
Answers (
