Customer experience | Sales, Customer Insights,...

"Price List Items" not showing in Advanced Find

(0) Share

Report

Posted on by Fasil Muhammed

"Price List Items" not sowing in Advanced Find.

Can anybody help??

Using CRM 2016 on premise

All responses (8)

Answers (0)

Fasil Muhammed 55 on at

Like (0)

Report

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 13,216 User Group Leader on at

Like (0)

Report

RE: "Price List Items" not showing in Advanced Find

@Muhammed please verify the reponse to close this thread.
meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: "Price List Items" not showing in Advanced Find

Hi,

Good news !!
Suggested answer

yleclerc 1,549 on at

Like (1)

Report

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 40,886 on at

Like (0)

Report

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 55 on at

Like (1)

Report

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 13,216 User Group Leader on at

Like (0)

Report

RE: "Price List Items" not showing in Advanced Find

Any news ?
Suggested answer

meelamri 13,216 User Group Leader on at

Like (1)

Report
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 !!