{"id":3776,"date":"2017-08-21T15:44:07","date_gmt":"2017-08-21T15:44:07","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-handle-blank-quantity-fields-in-netsuite-saved-searches-2\/"},"modified":"2026-07-28T18:26:06","modified_gmt":"2026-07-28T18:26:06","slug":"comment-gerer-les-champs-de-quantite-vides-dans-les-recherches-enregistrees-de-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-gerer-les-champs-de-quantite-vides-dans-les-recherches-enregistrees-de-netsuite\/","title":{"rendered":"Comment g\u00e9rer les champs de quantit\u00e9 vides 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":"D\u00e9couvrez comment garantir l'exactitude des r\u00e9sultats num\u00e9riques en convertissant les champs de quantit\u00e9 vides en z\u00e9ro dans les formules de recherche enregistr\u00e9es de NetSuite.","ga_short_answer":"Pour \u00e9viter que des champs de quantit\u00e9 vides n\u2019affectent les r\u00e9sultats de vos recherches enregistr\u00e9es dans NetSuite, utilisez la fonction NVL. Cette formule remplace toute valeur de quantit\u00e9 nulle ou vide par z\u00e9ro, garantissant ainsi la coh\u00e9rence des calculs num\u00e9riques et la pr\u00e9cision des rapports.","ga_scenario":"Lors de la cr\u00e9ation de recherches enregistr\u00e9es dans NetSuite, les utilisateurs peuvent constater que les colonnes de quantit\u00e9 apparaissent parfois vides, m\u00eame si la transaction correspondante affiche une valeur nulle. Cette divergence peut entra\u00eener des calculs inexacts ou des donn\u00e9es incompl\u00e8tes dans les r\u00e9sultats de recherche, en particulier lorsque ces champs sont utilis\u00e9s dans des formules.","ga_solution":"Afin de garantir des r\u00e9sultats pr\u00e9cis et coh\u00e9rents lorsque <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-calculate-back-ordered-quantity-on-netsuite-sales-orders\/\">des champs de quantit\u00e9 sont utilis\u00e9s dans les formules de recherche enregistr\u00e9es de NetSuite<\/a>\n\n, il est recommand\u00e9 de convertir toutes les valeurs vides (NULL) en z\u00e9ro. Cela permet d\u2019\u00e9viter d\u2019\u00e9ventuels probl\u00e8mes li\u00e9s au fait qu\u2019un champ vide pourrait autrement \u00eatre trait\u00e9 comme une valeur non num\u00e9rique ou entra\u00eener un comportement inattendu dans les calculs. Utilisez la fonction NVL dans votre formule de recherche enregistr\u00e9e pour remplacer les champs de quantit\u00e9 vides par un z\u00e9ro. La fonction NVL est con\u00e7ue pour renvoyer une valeur par d\u00e9faut sp\u00e9cifi\u00e9e si le premier argument est NULL.\n\n```\nNVL({quantityfield}, 0)\n```\n\nCette formule signifie concr\u00e8tement : \u00ab si le champ de quantit\u00e9 est vide (NULL), remplacez-le par 0 ; sinon, conservez sa valeur actuelle \u00bb. En appliquant cette formule, toutes les valeurs de quantit\u00e9 seront syst\u00e9matiquement num\u00e9riques, ce qui am\u00e9liorera la fiabilit\u00e9 des r\u00e9sultats de vos recherches enregistr\u00e9es.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:44:07+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"SOL0136 Saved Search Transaction Quantities","ga_ans_id":"ANS-0117","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The original answer suggests using DECODE({quantityfield}, '', 0, {quantityfield}) to handle blank quantity fields. While DECODE is still a supported function in NetSuite, current documentation and community discussions widely recommend using the NVL function (NVL({quantityfield}, 0)) as a more direct and idiomatic way to replace NULL (blank) numeric values with zero in saved searches. NetSuite treats blank numeric fields as NULL, not an empty string ('').","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[93],"class_list":["post-3776","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-debutant"],"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"}],"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\/3776","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\/3776\/revisions"}],"predecessor-version":[{"id":5697,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3776\/revisions\/5697"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3776"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3776"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3776"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}