{"id":3134,"date":"2017-08-21T14:51:16","date_gmt":"2017-08-21T14:51:16","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-dynamically-source-a-transaction-column-field-based-on-a-header-field-in-netsuite-2\/"},"modified":"2026-07-28T18:25:31","modified_gmt":"2026-07-28T18:25:31","slug":"comment-determiner-dynamiquement-la-source-dun-champ-de-colonne-de-transaction-en-fonction-dun-champ-den-tete-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-determiner-dynamiquement-la-source-dun-champ-de-colonne-de-transaction-en-fonction-dun-champ-den-tete-dans-netsuite\/","title":{"rendered":"Comment d\u00e9terminer dynamiquement la source d’un champ de colonne de transaction en fonction d’un champ d’en-t\u00eate dans 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 configurer les champs de colonne de transaction NetSuite \u00e0 l\u2019aide de filtres dynamiques, afin de garantir une identification pr\u00e9cise des articles en fonction des donn\u00e9es d\u2019en-t\u00eate de transaction.","ga_short_answer":"Pour r\u00e9cup\u00e9rer dynamiquement une valeur dans un champ de colonne de transaction, cr\u00e9ez un champ personnalis\u00e9 \u00ab Liste\/Enregistrement : Article \u00bb avec un filtre sur \u00ab Contrat \u00bb. Masquez le champ \u00ab Article \u00bb standard \u00e0 l\u2019aide du script d\u2019\u00e9v\u00e9nement utilisateur `beforeLoad(context)` et mettez \u00e0 jour sa valeur via le script client `fieldChanged(scriptContext)` afin de garantir l\u2019alimentation des champs d\u00e9pendants.","ga_scenario":"Les utilisateurs ont besoin d\u2019un champ de colonne de transaction pour filtrer dynamiquement les \u00e9l\u00e9ments disponibles en fonction d\u2019une valeur s\u00e9lectionn\u00e9e dans un champ d\u2019en-t\u00eate de transaction. Ce filtrage dynamique garantit que seuls les \u00e9l\u00e9ments pertinents sont affich\u00e9s, ce qui am\u00e9liore la pr\u00e9cision des donn\u00e9es et l\u2019exp\u00e9rience utilisateur lors de la saisie des transactions.","ga_solution":"La solution repose sur une combinaison de configuration de champs personnalis\u00e9s et de scripts. Un nouveau champ de colonne de transaction de type \u00ab Liste\/Enregistrement : Article \u00bb est cr\u00e9\u00e9, avec un filtre appliqu\u00e9 en fonction d\u2019un champ \u00ab Contrat \u00bb. Afin de garantir une alimentation correcte de tous les champs d\u00e9pendant de l\u2019article standard, le champ \u00ab Article \u00bb standard doit \u00eatre masqu\u00e9 \u00e0 l\u2019aide de la fonction `beforeLoad(context)` d\u2019un script d\u2019\u00e9v\u00e9nement utilisateur. Par la suite, sa valeur doit \u00eatre mise \u00e0 jour lorsque le champ personnalis\u00e9 change, ce qui est g\u00e9r\u00e9 par la fonction `fieldChanged(scriptContext)` d\u2019un script client.Voici comment cr\u00e9er un filtre dynamique sur un champ de colonne de transaction :\n1. Acc\u00e9dez \u00e0 `Customization > Lists, Records, & Fields > Transaction Column Fields > New`.\n2. Configurez le champ : d\u00e9finissez le type sur \u00ab Liste\/Enregistrement \u00bb, plus pr\u00e9cis\u00e9ment \u00ab Liste\/Enregistrement d\u2019\u00e9l\u00e9ment \u00bb, et appliquez-le aux types d\u2019enregistrements concern\u00e9s.\n3. Dans le sous-onglet \u00ab Sourcing & Filtering \u00bb, ajoutez une ligne avec les valeurs suivantes : Filtrer selon : \u00ab Contract \u00bb (le champ de l\u2019\u00e9l\u00e9ment) Type de comparaison : \u00ab \u00e9gal \u00bb Champ de comparaison : \u00ab Contract \u00bb (le champ du corps de la transaction)","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:51:16-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to source a column field dynamically based on a header field in a CUE","ga_ans_id":"ANS-1395","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The SuiteScript function names 'SUE onBeforeLoad()' and 'CUE onFieldChanged()' are outdated. In current NetSuite SuiteScript 2.x, the corresponding entry points are 'beforeLoad(context)' for User Event scripts and 'fieldChanged(scriptContext)' for Client Scripts.; The menu path 'Setup > Customization > Transaction Column Fields > New' is partially outdated. The current path is 'Customization > Lists, Records, & Fields > Transaction Column Fields > New'.","ga_final_category":"Custom Fields, Records & Forms","footnotes":""},"ga_category":[97,22,97],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3134","qa_entry","type-qa_entry","status-publish","hentry","ga_category-champs-personnalises-enregistrements-et-formulaires","ga_category-custom-fields-records-forms","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":97,"label":"Champs personnalis\u00e9s, enregistrements et formulaires"},{"value":22,"label":"Custom Fields, Records & Forms"},{"value":97,"label":"Champs personnalis\u00e9s, enregistrements et formulaires"}],"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\/3134","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\/3134\/revisions"}],"predecessor-version":[{"id":5054,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3134\/revisions\/5054"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3134"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3134"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3134"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}