{"id":3740,"date":"2017-08-21T14:50:53","date_gmt":"2017-08-21T14:50:53","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-filter-netsuite-transactions-by-open-status-in-searches-2\/"},"modified":"2026-07-28T18:26:05","modified_gmt":"2026-07-28T18:26:05","slug":"comment-filtrer-les-transactions-netsuite-en-fonction-de-leur-statut-ouvert-lors-des-recherches","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-filtrer-les-transactions-netsuite-en-fonction-de-leur-statut-ouvert-lors-des-recherches\/","title":{"rendered":"Comment filtrer les transactions NetSuite en fonction de leur statut \u00ab Ouvert \u00bb lors des recherches ?"},"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":"Ce guide fournit des crit\u00e8res de filtrage sp\u00e9cifiques pour les recherches enregistr\u00e9es dans NetSuite afin d\u2019afficher uniquement les factures en cours et les commandes client.","ga_short_answer":"Pour filtrer les transactions NetSuite dont le statut est \u00ab ouvert \u00bb, appliquez des crit\u00e8res sp\u00e9cifiques en fonction du type de transaction. Pour les factures, filtrez sur \u00ab l'un des \u00e9l\u00e9ments suivants (Facture : Ouverte CustInvc : A) \u00bb. Pour les commandes client, filtrez selon \u00ab aucun des \u00e9l\u00e9ments suivants : (Commande client : Factur\u00e9e SalesOrd:G ; Commande client : Cl\u00f4tur\u00e9e SalesOrd:H ; Commande client : Annul\u00e9e SalesOrd:C ; Commande client : En attente d\u2019approbation SalesOrd:A) \u00bb afin d\u2019exclure les statuts autres que \u00ab en cours \u00bb.","ga_scenario":"Les utilisateurs ont souvent besoin de cr\u00e9er des recherches enregistr\u00e9es dans NetSuite qui n\u2019affichent que les transactions en cours<\/a>. La difficult\u00e9 r\u00e9side dans le fait que les statuts des transactions varient selon leur type, ce qui rend difficile l\u2019application d\u2019un filtre \u00ab en cours \u00bb unique et universel. Cela n\u00e9cessite une logique de filtrage sp\u00e9cifique pour chaque type de transaction afin d\u2019identifier avec pr\u00e9cision les enregistrements en cours.","ga_solution":"Pour cr\u00e9er un filtre qui ne renvoie que les transactions en cours, notamment pour les factures et les commandes client, appliquez les crit\u00e8res suivants :\n* Pour les types de transaction \u00ab Facture \u00bb : appliquez un filtre \u00e0 l\u2019aide de `any of (Invoice:Open CustInvc:A)`.\n* Pour les types de transaction \u00ab Commande client \u00bb : appliquez un filtre \u00e0 l\u2019aide de `none of (Sales Order:Billed SalesOrd:G Sales Order:Closed SalesOrd:H Sales Order:Cancelled SalesOrd:C Sales Order:Pending Approval SalesOrd:A)`.\nCette approche garantit que seules les transactions consid\u00e9r\u00e9es comme \u00ab en cours \u00bb pour leurs types respectifs sont incluses dans les r\u00e9sultats de recherche.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T16:50:53+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"search filter on transaction status","ga_ans_id":"ANS-0081","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":[10],"ga_difficulty":[93],"class_list":["post-3740","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-developer-suitescript","ga_difficulty-debutant"],"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":10,"label":"Developer\/SuiteScript"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3740","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\/3740\/revisions"}],"predecessor-version":[{"id":5661,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3740\/revisions\/5661"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3740"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3740"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3740"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}