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
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 (