{"id":3756,"date":"2017-08-21T14:43:03","date_gmt":"2017-08-21T14:43:03","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/setting-up-formula-based-criteria-in-netsuite-saved-searches-2\/"},"modified":"2026-07-28T18:26:05","modified_gmt":"2026-07-28T18:26:05","slug":"configuration-de-criteres-bases-sur-des-formules-dans-les-recherches-enregistrees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/configuration-de-criteres-bases-sur-des-formules-dans-les-recherches-enregistrees-de-netsuite\/","title":{"rendered":"Configuration de crit\u00e8res bas\u00e9s sur des formules dans les recherches enregistr\u00e9es de 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":"Utilisez une formule num\u00e9rique dans les crit\u00e8res de recherche enregistr\u00e9s de NetSuite pour filtrer les transactions par type et selon des conditions de compte sp\u00e9cifiques.","ga_short_answer":"Pour appliquer un filtrage complexe dans une recherche enregistr\u00e9e NetSuite, utilisez le champ \u00ab Formule (num\u00e9rique) \u00bb dans les crit\u00e8res. Saisissez une instruction CASE WHEN pour d\u00e9finir vos conditions, telles que le type de transaction ou le compte. D\u00e9finissez cette formule sur \u00ab \u00e9gal \u00e0 \u00bb la valeur \u00ab 1 \u00bb afin d\u2019inclure les enregistrements correspondant \u00e0 la logique que vous avez sp\u00e9cifi\u00e9e.","ga_scenario":"Les utilisateurs de NetSuite ont souvent besoin de fonctionnalit\u00e9s de filtrage avanc\u00e9es dans les recherches enregistr\u00e9es,<\/a> qui vont au-del\u00e0 des comparaisons de champs standard. Cela concerne g\u00e9n\u00e9ralement des cas o\u00f9 plusieurs conditions portant sur diff\u00e9rents champs, tels que le type de transaction et des comptes sp\u00e9cifiques, doivent \u00eatre \u00e9valu\u00e9es simultan\u00e9ment afin d\u2019inclure ou d\u2019exclure des enregistrements.","ga_solution":"Pour mettre en \u0153uvre un crit\u00e8re bas\u00e9 sur une formule dans une recherche enregistr\u00e9e NetSuite, proc\u00e9dez comme suit :\n1. Acc\u00e9dez \u00e0 la d\u00e9finition de la recherche enregistr\u00e9e.\n2. Dans l\u2019onglet \u00ab Crit\u00e8res \u00bb, ajoutez un nouveau filtre.\n3. S\u00e9lectionnez \u00ab Formule (num\u00e9rique) \u00bb comme type de filtre.\n4. Dans le champ \u00ab Formule \u00bb, saisissez l\u2019instruction CASE WHEN suivante exactement telle qu\u2019elle est indiqu\u00e9e :\n\n```\nCASE WHEN {type} 'Invoice' THEN 1 WHEN {type} 'Bill' THEN 1 WHEN ({type} 'Journal' AND {account} '1045 Sterling - FL - Payroll') THEN 1 ELSE 0 END\n```\n\n5. D\u00e9finissez la condition de cette \u00ab Formule (num\u00e9rique) \u00bb sur \u00ab \u00e9gal \u00e0 \u00bb une \u00ab Valeur \u00bb de \u00ab 1 \u00bb. Cette configuration garantit que seuls les enregistrements correspondant aux types de transaction sp\u00e9cifi\u00e9s (Facture, Relev\u00e9) ou \u00e0 l\u2019\u00e9criture comptable sp\u00e9cifique associ\u00e9e au compte d\u00e9sign\u00e9 seront inclus dans les r\u00e9sultats de la recherche.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:43:03-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to set a formula in the criteria of the saved search","ga_ans_id":"ANS-0097","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],"ga_difficulty":[92],"class_list":["post-3756","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"}],"ga_difficulty":[{"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\/3756","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\/3756\/revisions"}],"predecessor-version":[{"id":5677,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3756\/revisions\/5677"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3756"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3756"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3756"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}