{"id":2487,"date":"2018-11-23T16:47:05","date_gmt":"2018-11-23T16:47:05","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-resoudre-les-resultats-de-recherche-inexacts-pour-les-elements-de-synthese-dans-netsuite\/"},"modified":"2026-07-28T18:26:00","modified_gmt":"2026-07-28T18:26:00","slug":"comment-resoudre-les-resultats-de-recherche-inexacts-pour-les-elements-de-synthese-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-resoudre-les-resultats-de-recherche-inexacts-pour-les-elements-de-synthese-dans-netsuite\/","title":{"rendered":"Comment r\u00e9soudre les r\u00e9sultats de recherche inexacts pour les \u00e9l\u00e9ments de synth\u00e8se dans NetSuite"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Lorsque les crit\u00e8res de recherche NetSuite impliquant des \u00e9l\u00e9ments membres et des transactions jointes produisent des r\u00e9sultats de synth\u00e8se erron\u00e9s, une instruction PL\/SQL peut apporter une solution pr\u00e9cise.","ga_short_answer":"Les r\u00e9sultats de recherche inexacts sur les \u00e9l\u00e9ments r\u00e9capitulatifs de NetSuite, en particulier lorsque les crit\u00e8res utilisent la n\u00e9gation ou impliquent des \u00e9l\u00e9ments membres joints, peuvent \u00eatre r\u00e9solus en rempla\u00e7ant les crit\u00e8res standard de l\u2019interface utilisateur par une instruction PL\/SQL. Mettez en \u0153uvre une condition de type CASE WHEN {memberitem.name} LIKE ('%TPM%') THEN 0 ELSE 1 END | \u00e9gale \u00e0 1 afin de garantir une r\u00e9cup\u00e9ration pr\u00e9cise des donn\u00e9es.","ga_scenario":"La fonctionnalit\u00e9 de l'interface utilisateur de NetSuite permettant de d\u00e9finir des crit\u00e8res de recherche peut parfois donner des r\u00e9sultats inexacts. Ce probl\u00e8me est fr\u00e9quemment observ\u00e9 dans les recherches o\u00f9 les crit\u00e8res utilisent une n\u00e9gation, telle que \u00ab ne contient pas \u00bb, en particulier lors de recherches sur des postes de synth\u00e8se associ\u00e9es \u00e0 des postes membres et \u00e0 des transactions.","ga_solution":"Pour corriger des r\u00e9sultats de recherche inexacts sur les articles r\u00e9capitulatifs, en particulier lorsque les crit\u00e8res standard de l\u2019interface utilisateur accompagn\u00e9s d\u2019une n\u00e9gation g\u00e9n\u00e8rent des erreurs, impl\u00e9mentez une instruction PL\/SQL directement dans les crit\u00e8res de recherche. Par exemple, pour filtrer en fonction du nom d\u2019un article membre, utilisez la condition PL\/SQL suivante :CASE WHEN {memberitem.name} LIKE ('%TPM%') THEN 0 ELSE 1 END | \u00e9gal \u00e0 1. Cette approche garantit une r\u00e9cup\u00e9ration pr\u00e9cise des donn\u00e9es en contournant les probl\u00e8mes d\u2019interpr\u00e9tation potentiels de l\u2019interface utilisateur li\u00e9s \u00e0 des crit\u00e8res complexes ou n\u00e9gatifs.","ga_source_author":"Louis Morin","ga_source_author_email":"","ga_date_original":"2018-11-23T08:47:05-08:00","ga_date_verified":"2026-07-05","ga_source_subject":"How do I resolve inaccurate Summary Item Search Results for Searches Joined to Member Items and Transactions in Criteria and Results?","ga_ans_id":"ANS-0011","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89,89],"ga_difficulty":[92,92],"class_list":["post-2487","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"},{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"},{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2487\/revisions"}],"predecessor-version":[{"id":2507,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2487\/revisions\/2507"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2487"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2487"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2487"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}