{"id":3025,"date":"2018-07-19T18:30:04","date_gmt":"2018-07-19T18:30:04","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-afficher-les-noms-des-filiales-sans-hierarchie-dans-les-rapports-netsuite\/"},"modified":"2026-07-28T18:25:24","modified_gmt":"2026-07-28T18:25:24","slug":"comment-afficher-les-noms-des-filiales-sans-hierarchie-dans-les-rapports-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-afficher-les-noms-des-filiales-sans-hierarchie-dans-les-rapports-netsuite\/","title":{"rendered":"Comment afficher les noms des filiales sans hi\u00e9rarchie dans les rapports 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":"Simplifiez les rapports NetSuite en affichant les noms des filiales sans leur chemin hi\u00e9rarchique complet.","ga_short_answer":"La mani\u00e8re la plus simple d\u2019afficher le nom d\u2019une filiale sans son chemin hi\u00e9rarchique dans NetSuite consiste \u00e0 utiliser le champ d\u00e9di\u00e9 \u00ab subsidiarynohierarchy \u00bb. Ce champ fournit automatiquement le nom local de la filiale, ce qui \u00e9vite d\u2019avoir \u00e0 recourir \u00e0 des formules personnalis\u00e9es complexes pour analyser les cha\u00eenes hi\u00e9rarchiques.","ga_scenario":"Les utilisateurs ont souvent besoin que les noms des filiales s'affichent sans leur chemin hi\u00e9rarchique complet (par exemple, \u00ab Parent : Filiale \u00bb doit s'afficher sous la forme \u00ab Filiale \u00bb) afin d'obtenir des rapports plus clairs ou une pr\u00e9sentation simplifi\u00e9e des donn\u00e9es. Le champ \u00ab Filiale \u00bb par d\u00e9faut inclut g\u00e9n\u00e9ralement l'int\u00e9gralit\u00e9 de la hi\u00e9rarchie, ce qui peut s'av\u00e9rer fastidieux pour certaines analyses ou int\u00e9grations.","ga_solution":"La m\u00e9thode la plus efficace pour afficher le nom d\u2019une filiale sans sa hi\u00e9rarchie dans NetSuite consiste \u00e0 utiliser le champ \u00ab subsidiarynohierarchy \u00bb. Ce champ est con\u00e7u pour ne fournir que le nom local de la filiale, en supprimant automatiquement tout pr\u00e9fixe de la soci\u00e9t\u00e9 m\u00e8re.\nPour mettre cela en \u0153uvre :\n1. Acc\u00e9dez \u00e0 l\u2019enregistrement ou au rapport dans lequel le nom de la filiale doit \u00eatre affich\u00e9.\n2. Ajoutez ou s\u00e9lectionnez le champ intitul\u00e9 \u00ab subsidiarynohierarchy \u00bb.\n\nPar ailleurs, pour les cas n\u00e9cessitant une logique personnalis\u00e9e ou dans les environnements o\u00f9 le champ \u00ab subsidiarynohierarchy \u00bb pourrait ne pas \u00eatre directement disponible ou adapt\u00e9, une formule personnalis\u00e9e peut \u00eatre utilis\u00e9e. Cette formule analyse le nom complet de la filiale afin d\u2019en extraire uniquement le dernier segment.\n```\ncase when {parent} is null then {name} else REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+*$'),': ','') end\n```\nCette formule v\u00e9rifie si une filiale a une soci\u00e9t\u00e9 m\u00e8re. Si ce n\u2019est pas le cas, elle affiche directement son nom. Si c\u2019est le cas, elle utilise des expressions r\u00e9guli\u00e8res pour extraire la partie du nom situ\u00e9e apr\u00e8s le dernier deux-points, supprimant ainsi le chemin hi\u00e9rarchique.","ga_source_author":"Alexandre Dery","ga_source_author_email":"","ga_date_original":"2018-07-19T11:30:04-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"Show subsidiary without the hierarchy","ga_ans_id":"ANS-1286","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"A dedicated field 'subsidiarynohierarchy' now exists to display the subsidiary name without hierarchy, offering a simpler alternative to the provided formula.","ga_final_category":"OneWorld & Multi-Subsidiary","footnotes":""},"ga_category":[41,105,105],"ga_audience":[89],"ga_difficulty":[93],"class_list":["post-3025","qa_entry","type-qa_entry","status-publish","hentry","ga_category-oneworld-multi-subsidiary","ga_category-oneworld-et-multi-filiale","ga_audience-administrateur-netsuite","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":41,"label":"OneWorld & Multi-Subsidiary"},{"value":105,"label":"OneWorld et multi-filiale"},{"value":105,"label":"OneWorld et multi-filiale"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"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\/3025","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\/3025\/revisions"}],"predecessor-version":[{"id":4945,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3025\/revisions\/4945"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3025"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3025"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3025"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}