{"id":3858,"date":"2017-08-21T14:33:29","date_gmt":"2017-08-21T14:33:29","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/scripting-netsuite-saved-searches-accessing-multiple-formula-fields-2\/"},"modified":"2026-07-28T18:26:11","modified_gmt":"2026-07-28T18:26:11","slug":"creation-de-scripts-pour-les-recherches-enregistrees-dans-netsuite-acces-a-plusieurs-champs-de-formule","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/creation-de-scripts-pour-les-recherches-enregistrees-dans-netsuite-acces-a-plusieurs-champs-de-formule\/","title":{"rendered":"Cr\u00e9ation de scripts pour les recherches enregistr\u00e9es dans NetSuite : acc\u00e8s \u00e0 plusieurs champs de formule"},"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":"Les scripts NetSuite se heurtent \u00e0 des limitations lorsqu\u2019ils r\u00e9cup\u00e8rent plusieurs champs de formule \u00e0 partir d\u2019une recherche enregistr\u00e9e si ceux-ci partagent le m\u00eame type de synth\u00e8se, ce qui n\u00e9cessite une solution de contournement sp\u00e9cifique.","ga_short_answer":"Les scripts NetSuite ne peuvent pas acc\u00e9der directement \u00e0 plusieurs champs de formule pr\u00e9sentant des types de synth\u00e8se identiques \u00e0 partir d\u2019une seule recherche enregistr\u00e9e. Pour contourner cette limitation, attribuez des libell\u00e9s personnalis\u00e9s distincts \u00e0 chaque champ de formule au sein de la recherche. Dans votre code SuiteScript 2.x, parcourez les colonnes des r\u00e9sultats de recherche et identifiez les champs de formule souhait\u00e9s gr\u00e2ce \u00e0 leurs libell\u00e9s ou formules uniques.","ga_scenario":"Lorsqu\u2019ils utilisent des recherches enregistr\u00e9es NetSuite dans SuiteScript, les utilisateurs peuvent se heurter \u00e0 une limitation les emp\u00eachant d\u2019acc\u00e9der directement \u00e0 deux champs de type formule partageant le m\u00eame type de synth\u00e8se<\/a>. Par exemple, si une recherche enregistr\u00e9e sur les commandes client comprend un champ de formule (num\u00e9rique) additionnant {rate}*{quantity} et un autre additionnant {rate}*{quantitybilled}, un script ne pourra pas r\u00e9cup\u00e9rer ces deux champs de formule simultan\u00e9ment.","ga_solution":"Une solution possible consiste \u00e0 diviser la recherche enregistr\u00e9e en deux recherches distinctes et \u00e0 utiliser des filtres dans le script pour \u00e9tablir une corr\u00e9lation entre les donn\u00e9es de la deuxi\u00e8me recherche et celles de la premi\u00e8re. Une solution plus directe et couramment utilis\u00e9e consiste \u00e0 s\u2019assurer que chaque champ de formule de la recherche enregistr\u00e9e dispose d\u2019un libell\u00e9 personnalis\u00e9 distinct. Par exemple, si une recherche enregistr\u00e9e comprend un champ num\u00e9rique de formule pour {rate}*{quantity} et un autre pour {rate}*{quantitybilled}, attribuez un libell\u00e9 personnalis\u00e9 unique \u00e0 chacun d\u2019entre eux. Dans SuiteScript 2.x, au sein du script, acc\u00e9dez \u00e0 la propri\u00e9t\u00e9 \u00ab columns \u00bb d\u2019un objet `search.Result`. Parcourez ces colonnes et utilisez la propri\u00e9t\u00e9 \u00ab label \u00bb de chaque objet `search.Column` pour trouver le champ de formule sp\u00e9cifique requis. Vous pouvez \u00e9galement utiliser la propri\u00e9t\u00e9 \u00ab formula \u00bb de l\u2019objet `search.Column` \u00e0 des fins d\u2019identification.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:33:29-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"SOL0567 formula fields for saved search in scripts","ga_ans_id":"ANS-0199","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The SuiteScript 1.0 function `nlobjResult.getAllColumns()` is outdated; the SuiteScript 2.x equivalent is accessing the `columns` property of a `search.Result` object (e.g., `result.columns`).; The SuiteScript 1.0 function `nlobjColumn.getLabel()` is outdated; the SuiteScript 2.x equivalent is accessing the `label` property of a `search.Column` object (e.g., `column.label`).; The SuiteScript 1.0 function `getFormula()` (presumably `nlobjColumn.getFormula()`) is outdated; the SuiteScript 2.x equivalent is accessing the `formula` property of a `search.Column` object (e.g., `column.formula`).","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[10],"ga_difficulty":[92],"class_list":["post-3858","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-developer-suitescript","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":10,"label":"Developer\/SuiteScript"}],"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\/3858","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\/3858\/revisions"}],"predecessor-version":[{"id":5779,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3858\/revisions\/5779"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3858"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3858"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3858"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}