{"id":2549,"date":"2017-10-17T15:28:27","date_gmt":"2017-10-17T15:28:27","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-recuperer-la-mention-represente-une-filiale-pour-les-noms-des-ecritures-inter-societes-dans-les-recherches-enregistrees-de-netsuite\/"},"modified":"2026-07-28T18:25:01","modified_gmt":"2026-07-28T18:25:01","slug":"comment-recuperer-la-mention-represente-une-filiale-pour-les-noms-des-ecritures-inter-societes-dans-les-recherches-enregistrees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-recuperer-la-mention-represente-une-filiale-pour-les-noms-des-ecritures-inter-societes-dans-les-recherches-enregistrees-de-netsuite\/","title":{"rendered":"Comment r\u00e9cup\u00e9rer la mention \u00ab Repr\u00e9sente une filiale \u00bb pour les noms des \u00e9critures inter-soci\u00e9t\u00e9s 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":"Apprenez \u00e0 cr\u00e9er une formule de recherche enregistr\u00e9e dans NetSuite afin d\u2019afficher correctement la valeur \u00ab Repr\u00e9sente une filiale \u00bb pour les entit\u00e9s clients et fournisseurs li\u00e9es dans les \u00e9critures inter-soci\u00e9t\u00e9s.","ga_short_answer":"Pour extraire la valeur \u00ab Repr\u00e9sente la filiale \u00bb pour les entit\u00e9s figurant dans la colonne \u00ab Nom \u00bb d\u2019une \u00e9criture comptable inter-soci\u00e9t\u00e9s, utilisez une formule CASE WHEN. Cette formule compare l\u2019ID d\u2019entit\u00e9 associ\u00e9 au nom de la soci\u00e9t\u00e9 avec le champ \u00ab Nom \u00bb, et renvoie la filiale correspondante. Elle garantit un mappage pr\u00e9cis des filiales, tant pour les lignes client que pour les lignes fournisseur.","ga_scenario":"Les utilisateurs rencontrent souvent des difficult\u00e9s lorsqu\u2019ils tentent d\u2019extraire la valeur \u00ab Repr\u00e9sente la filiale \u00bb directement \u00e0 partir de la colonne \u00ab Nom \u00bb dans les \u00e9critures inter-soci\u00e9t\u00e9s de NetSuite. Le champ \u00ab Nom \u00bb combine g\u00e9n\u00e9ralement l\u2019identifiant de l\u2019entit\u00e9 et le nom de la soci\u00e9t\u00e9, ce qui rend difficile la recherche directe des informations relatives \u00e0 la filiale associ\u00e9e.","ga_solution":"Pour r\u00e9cup\u00e9rer avec pr\u00e9cision la valeur \u00ab Repr\u00e9sente une filiale \u00bb, une formule utilisant les fonctions CASE WHEN et NS_CONCAT peut \u00eatre mise en \u0153uvre dans une recherche enregistr\u00e9e. Cette approche tient compte de la mani\u00e8re dont NetSuite affiche les noms d\u2019entit\u00e9s dans la colonne \u00ab Nom \u00bb en les comparant \u00e0 la combinaison des champs \u00ab ID d\u2019entit\u00e9 \u00bb et \u00ab Nom de la soci\u00e9t\u00e9 \u00bb.La formule suivante peut \u00eatre utilis\u00e9e :\n\nGA_KEEP_0001.\n\nCette formule fonctionne comme suit :\n1. Elle compare le champ {name} (qui contient \u00e0 la fois l\u2019identifiant et le nom de l\u2019entit\u00e9) \u00e0 une cha\u00eene concat\u00e9n\u00e9e compos\u00e9e de {customer.entityid} et {customer.companyname}. La fonction NS_CONCAT est utilis\u00e9e pour une concat\u00e9nation robuste des cha\u00eenes de caract\u00e8res, g\u00e9rant de mani\u00e8re optimale les valeurs NULL \u00e9ventuelles.\n2. Si une correspondance est trouv\u00e9e pour un client, elle renvoie la valeur {customer.representingsubsidiary}.\n3. Elle v\u00e9rifie ensuite si le champ {name} correspond \u00e0 {vendorline.entityid}.\n4. Si une correspondance est trouv\u00e9e pour un fournisseur, elle renvoie {vendorline.representingsubsidiary}.\n5. Si aucune de ces conditions n\u2019est remplie, elle renvoie \u00ab null \u00bb. Cette solution est sp\u00e9cialement con\u00e7ue pour les \u00e9critures inter-soci\u00e9t\u00e9s. Pour d\u2019autres types de transactions, des conditions CASE WHEN suppl\u00e9mentaires, bas\u00e9es sur le type de transaction, seraient n\u00e9cessaires pour appliquer une logique diff\u00e9rente.","ga_source_author":"Jean-Mathieu Rose","ga_source_author_email":"","ga_date_original":"2017-10-17T08:28:27-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"Unable to pull the 'Represents Subsidiary' value of the record referenced in the 'Name' column of an Intercompany Journal Entry","ga_ans_id":"ANS-0810","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"While CONCAT is still supported, NS_CONCAT is a more robust function for string concatenation in NetSuite saved searches, as it handles NULL values more gracefully by treating them as empty strings, preventing the entire concatenated string from becoming NULL if one part is NULL. The original formula's nested CONCAT would return NULL if {customer.companyname} is NULL.; The DECODE function is still supported in NetSuite saved search formulas; however, CASE WHEN is generally considered a more modern, readable, and versatile alternative for conditional logic, especially for complex scenarios, as it is ANSI-standard and supports a wider range of logical operators beyond simple equality checks.","ga_final_category":"OneWorld & Multi-Subsidiary","footnotes":""},"ga_category":[41,105,105],"ga_audience":[9],"ga_difficulty":[92],"class_list":["post-2549","qa_entry","type-qa_entry","status-publish","hentry","ga_category-oneworld-multi-subsidiary","ga_category-oneworld-et-multi-filiale","ga_audience-finance-accounting-team","ga_difficulty-niveau-intermediaire"],"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":9,"label":"Finance\/accounting team"}],"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\/2549","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\/2549\/revisions"}],"predecessor-version":[{"id":4469,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2549\/revisions\/4469"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2549"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2549"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2549"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}