{"id":2488,"date":"2018-03-02T21:21:20","date_gmt":"2018-03-02T21:21:20","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-extraire-la-premiere-ligne-dune-commande-a-partir-de-plusieurs-transactions-netsuite\/"},"modified":"2026-07-28T18:26:00","modified_gmt":"2026-07-28T18:26:00","slug":"comment-extraire-la-premiere-ligne-dune-commande-a-partir-de-plusieurs-transactions-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-extraire-la-premiere-ligne-dune-commande-a-partir-de-plusieurs-transactions-netsuite\/","title":{"rendered":"Comment extraire la premi\u00e8re ligne d’une commande \u00e0 partir de plusieurs transactions 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 la fonction analytique DENSE_RANK dans les recherches enregistr\u00e9es de NetSuite afin d'extraire avec pr\u00e9cision des lignes sp\u00e9cifiques \u00e0 partir de donn\u00e9es de transactions regroup\u00e9es.","ga_short_answer":"Pour extraire la premi\u00e8re ligne parmi plusieurs transactions dans NetSuite, configurez une recherche enregistr\u00e9e avec mainline = F et regroupez par ID interne. Ajoutez des champs de formule \u00e0 l\u2019aide de MAX({champ}) KEEP(DENSE_RANK FIRST ORDER BY {ligne}) pour chaque r\u00e9sultat souhait\u00e9, en veillant \u00e0 ce que le type de synth\u00e8se soit d\u00e9fini sur MAX. Cette m\u00e9thode permet d\u2019isoler efficacement la ligne d\u2019article initiale.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019extraire des lignes sp\u00e9cifiques des transactions, en particulier la toute premi\u00e8re ligne, lorsqu\u2019ils analysent des donn\u00e9es issues de plusieurs transactions dans NetSuite. Les r\u00e9sultats des recherches enregistr\u00e9es standard affichent g\u00e9n\u00e9ralement toutes les lignes, ce qui rend difficile l\u2019isolation d\u2019une seule ligne principale \u00e0 des fins de reporting ou d\u2019analyse.","ga_solution":"La fonction analytique DENSE_RANK peut \u00eatre utilis\u00e9e \u00e0 cette fin. Filtres : commencez par ajouter les filtres n\u00e9cessaires \u00e0 la recherche enregistr\u00e9e. En r\u00e8gle g\u00e9n\u00e9rale, cela implique de d\u00e9finir mainline = F. R\u00e9sultats : Dans le sous-onglet \u00ab R\u00e9sultats \u00bb, il sera n\u00e9cessaire de regrouper la recherche par identifiant interne<\/a>. Pour chaque champ de r\u00e9sultat souhait\u00e9, ajoutez un champ de formule et d\u00e9finissez son type de synth\u00e8se sur MAX<\/a>. Voici un exemple d\u2019une telle formule : Max({job}) KEEP(DENSE_RANK FIRST ORDER BY {line}) Cette approche permet de s\u00e9lectionner la ligne \u00e0 conserver en fonction de divers crit\u00e8res. Par exemple, un champ autre que {line} pourrait \u00eatre utilis\u00e9 pour le tri. Pour r\u00e9cup\u00e9rer la derni\u00e8re ligne au lieu de la premi\u00e8re, il suffit de remplacer FIRST par LAST dans la formule.","ga_source_author":"Riley Van Ryswyk","ga_source_author_email":"","ga_date_original":"2018-03-02T13:21:20-08:00","ga_date_verified":"2026-07-05","ga_source_subject":"How can I return the first line from a transaction (for multiple transactions)?","ga_ans_id":"ANS-0012","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":[94,94],"class_list":["post-2488","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-avance"],"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":94,"label":"Avanc\u00e9"},{"value":94,"label":"Avanc\u00e9"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2488","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\/2488\/revisions"}],"predecessor-version":[{"id":2508,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2488\/revisions\/2508"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2488"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2488"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2488"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}