Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

"Price List Items" not showing in Advanced Find

Posted on by 55

"Price List Items" not sowing in Advanced Find.

Can anybody help??

Using CRM 2016 on premise

pastedimage1613048513616v1.png

  • Fasil Muhammed Profile Picture
    Fasil Muhammed 55 on at
    RE: "Price List Items" not showing in Advanced Find

    Hello Lu Hao,

    Thank you for your respond.

    I couldn't find the attribute ' IsValidForAdvancedFind Property' in customization.xml file.

    Below is the file.

    Can you please share the solution to my email : fasilwdr@hotmail.com if you are using the same version?

    My CRM Version 1612 (8.2.6.19) (DB 8.2.6.19) on-premises

    <ImportExportXml xmlns:xsi="www.w3.org/.../XMLSchema-instance">

     <Entities>

       <Entity>

         <Name LocalizedName="Price List Item" OriginalName="Price List Item">ProductPriceLevel</Name>

         <ObjectTypeCode>1026</ObjectTypeCode>

         <EntityInfo>

           <entity Name="ProductPriceLevel" unmodified="1">

             <attributes />

           </entity>

         </EntityInfo>

         <RibbonDiffXml>

           <CustomActions />

           <Templates>

             <RibbonTemplates Id="Mscrm.Templates"></RibbonTemplates>

           </Templates>

           <CommandDefinitions />

           <RuleDefinitions>

             <TabDisplayRules />

             <DisplayRules />

             <EnableRules />

           </RuleDefinitions>

           <LocLabels />

         </RibbonDiffXml>

       </Entity>

     </Entities>

     <Roles></Roles>

     <Workflows></Workflows>

     <FieldSecurityProfiles></FieldSecurityProfiles>

     <Templates />

     <EntityMaps />

     <EntityRelationships />

     <OrganizationSettings />

     <optionsets />

     <Languages>

       <Language>1033</Language>

     </Languages>

    </ImportExportXml>

  • meelamri Profile Picture
    meelamri 13,198 User Group Leader on at
    RE: "Price List Items" not showing in Advanced Find

    @Muhammed please verify the reponse to close this thread.

  • meelamri Profile Picture
    meelamri 13,198 User Group Leader on at
    RE: "Price List Items" not showing in Advanced Find

    Hi, 

    Good news !! 

  • Suggested answer
    yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: "Price List Items" not showing in Advanced Find

    Hi all,

    When we exported the Price List Items entity in an solution, there was no "IsValidForAdvancedFind" Property in the customization.xml.

    What fixed it is Mehdi's solution, with a very small change:

    Mehdi's query:
    update MetadataSchema.Entity set IsValidForAdvancedFind = 1 where Name = productpricelevel

    Our query:
    update MetadataSchema.Entity set IsValidForAdvancedFind = 1 where Name = 'ProductPriceLevel'

  • Suggested answer
    LuHao Profile Picture
    LuHao 40,844 on at
    RE: "Price List Items" not showing in Advanced Find

    Hi Fasil,

    I'm on the same page with Mehdi.

    You will export the "Price List Items" entity in an unmanaged solution, open the customization.xml file of the solution, find the IsValidForAdvancedFind Property for the "Price List Items" entity and update the value to '1' before importing the solution back into CRM.

    This solution is available for the D365 OP.

  • Fasil Muhammed Profile Picture
    Fasil Muhammed 55 on at
    RE: "Price List Items" not showing in Advanced Find

    Hello Mehdi,

    It was not worked for me.

    Im using Version 1612 (8.2.6.19) (DB 8.2.6.19) on-premises

  • meelamri Profile Picture
    meelamri 13,198 User Group Leader on at
    RE: "Price List Items" not showing in Advanced Find

    Any news  ?

  • Suggested answer
    meelamri Profile Picture
    meelamri 13,198 User Group Leader on at
    RE: "Price List Items" not showing in Advanced Find

    Hi,

    It's by design, the price list items are not visible in the advanced find in your CRM version. 

    There is a property named "IsValidForAdvancedFind" in EntityMetadata to tag which entity should appear in Advanced Find. You can update this value directly on the database. I'm not sure if it's supported.

    update MetadataSchema.Entity set IsValidForAdvancedFind = 1 where Name = productpricelevel

    Reset your server, and clear your browser cache

    Take a look to this blog, it explains how to remove an entity from the advanced find: 

    http://blogs.webrange.com.au/index.php/2016/10/22/remove-entity-from-advanced-find-without-removing-users-access-via-security-role/

    Good Luck !!

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans