web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Missing distinct="true" in lookup fetchxml of productid on quotedetail mainformular

(0) ShareShare
ReportReport
Posted on by 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.

pastedimage1645514957587v1.png

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?

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    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":

    Snipaste_5F00_2022_2D00_02_2D00_22_5F00_16_2D00_29_2D00_31.png

    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.

    Snipaste_5F00_2022_2D00_02_2D00_22_5F00_16_2D00_32_2D00_20.png

    2. Add price list items.

    Snipaste_5F00_2022_2D00_02_2D00_22_5F00_16_2D00_32_2D00_38.png

    3. Check the products in the Existing product of Quote line.

    Snipaste_5F00_2022_2D00_02_2D00_22_5F00_16_2D00_37_2D00_29.png

    Reference:

    Add products to quotes, orders, or invoices (Dynamics 365 Sales) | Microsoft Docs

  • McDauly Profile Picture
    219 on at

    Hello Steve, thank you. Your Information solved my problem!!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 60 Most Valuable Professional

#2
#ManoVerse Profile Picture

#ManoVerse 51

#3
Satyam Prakash Profile Picture

Satyam Prakash 42

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans