{"id":3807,"date":"2017-08-21T15:24:11","date_gmt":"2017-08-21T15:24:11","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/netsuite-saved-search-counting-unique-transactions-with-main-line-false-2\/"},"modified":"2026-07-28T18:26:08","modified_gmt":"2026-07-28T18:26:08","slug":"recherche-enregistree-netsuite-comptage-des-transactions-uniques-avec-la-ligne-principale-definie-sur-faux","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/recherche-enregistree-netsuite-comptage-des-transactions-uniques-avec-la-ligne-principale-definie-sur-faux\/","title":{"rendered":"Recherche enregistr\u00e9e NetSuite : comptage des transactions uniques avec la ligne principale d\u00e9finie sur \u00ab Faux \u00bb"},"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 une formule et une configuration permettant de compter avec pr\u00e9cision les transactions distinctes dans les recherches enregistr\u00e9es de NetSuite, en particulier lorsqu'il s'agit d'articles hors gamme principale.","ga_short_answer":"Pour compter les transactions uniques dans une recherche enregistr\u00e9e NetSuite, utilisez une formule combinant COUNT(DISTINCT({internalid})) et une instruction CASE WHEN pour des crit\u00e8res sp\u00e9cifiques. Veillez \u00e0 ce que le type de synth\u00e8se du champ de formule soit d\u00e9fini sur \u00ab Nombre \u00bb pour obtenir des r\u00e9sultats pr\u00e9cis, en particulier lorsque la valeur \u00ab mainline \u00bb est fausse.","ga_scenario":"Les utilisateurs rencontrent souvent des difficult\u00e9s lorsqu\u2019ils tentent de compter les transactions uniques dans les recherches enregistr\u00e9es de NetSuite, en particulier lorsque le crit\u00e8re \u00ab Ligne principale \u00bb est d\u00e9fini sur \u00ab Faux \u00bb. Ce cas de figure se pr\u00e9sente g\u00e9n\u00e9ralement lorsqu\u2019une recherche doit agr\u00e9ger des donn\u00e9es en fonction des lignes de transaction individuelles tout en veillant \u00e0 ce que chaque transaction ne soit compt\u00e9e qu\u2019une seule fois, afin d\u2019\u00e9viter des totaux gonfl\u00e9s.","ga_solution":"Pour compter avec pr\u00e9cision les transactions uniques dans une recherche enregistr\u00e9e NetSuite, configurez le champ de formule comme suit : commencez par ajouter un nouveau champ \u00ab Formule (num\u00e9rique) \u00bb \u00e0 vos r\u00e9sultats de recherche enregistr\u00e9s. Dans le champ \u00ab Formule \u00bb, saisissez l\u2019expression suivante pour identifier et compter les identifiants internes de transactions distincts en fonction de vos crit\u00e8res :\n\n```\nCOUNT(DISTINCT(case when TRUNC({trandate},'MM') TRUNC(ADD_MONTHS({today}, -13),'MM') then {internalid} else null end))\n```\n\nEnsuite, pour ce champ de formule, d\u00e9finissez le \u00ab Type de synth\u00e8se \u00bb sur \u00ab Nombre \u00bb. Cette configuration garantit que la recherche enregistr\u00e9e agr\u00e8ge et compte correctement chaque transaction unique identifi\u00e9e par la formule, fournissant ainsi un total pr\u00e9cis m\u00eame lorsqu\u2019une m\u00eame transaction comporte plusieurs lignes.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:24:11-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Saved Search Count unique transactions with mainline is false","ga_ans_id":"ANS-0148","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The recommendation to set the 'Summary type' to 'Maximum' for a formula designed to count distinct transactions is outdated. Current NetSuite documentation and community advice suggest using 'Summary Type = Count' when employing the DISTINCT function in a formula for counting unique records.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3807","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\/3807","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\/3807\/revisions"}],"predecessor-version":[{"id":5728,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3807\/revisions\/5728"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3807"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3807"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3807"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}