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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

meelamri 13,216 User Group Leader on at

Like (1)

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

Was this reply helpful? Yes No
meelamri 13,216 User Group Leader on at

Like (0)

Report

Any news ?

Was this reply helpful? Yes No
Fasil Muhammed 55 on at

Like (1)

Report

Hello Mehdi,

It was not worked for me.

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

Was this reply helpful? Yes No
Suggested answer

LuHao 40,892 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

yleclerc 1,549 on at

Like (1)

Report

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'

Was this reply helpful? Yes No
meelamri 13,216 User Group Leader on at

Like (0)

Report

Hi,

Good news !!

Was this reply helpful? Yes No
meelamri 13,216 User Group Leader on at

Like (0)

Report

@Muhammed please verify the reponse to close this thread.

Was this reply helpful? Yes No
Fasil Muhammed 55 on at

Like (0)

Report

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>

Was this reply helpful? Yes No