{"id":3710,"date":"2017-08-21T15:37:07","date_gmt":"2017-08-21T15:37:07","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-display-unbilled-amount-at-line-item-level-on-a-netsuite-sales-order-saved-search-2\/"},"modified":"2026-07-28T18:26:03","modified_gmt":"2026-07-28T18:26:03","slug":"comment-afficher-le-montant-non-facture-au-niveau-des-lignes-dun-ordre-de-vente-netsuite-dans-une-recherche-enregistree","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-afficher-le-montant-non-facture-au-niveau-des-lignes-dun-ordre-de-vente-netsuite-dans-une-recherche-enregistree\/","title":{"rendered":"Comment afficher le montant non factur\u00e9 au niveau des lignes d&rsquo;un ordre de vente NetSuite dans une recherche enregistr\u00e9e ?"},"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 calculer et afficher le montant non factur\u00e9 pour chaque ligne d'une recherche enregistr\u00e9e de commande client NetSuite \u00e0 l'aide de formules personnalis\u00e9es.","ga_short_answer":"Pour afficher le montant non factur\u00e9 au niveau d\u2019une ligne de commande dans une recherche enregistr\u00e9e de commandes client, utilisez un champ de formule. \u00c9tant donn\u00e9 que les champs standard \u00ab Montant non factur\u00e9 \u00bb ne sont pas au niveau des lignes, calculez la valeur \u00e0 l\u2019aide de champs au niveau des lignes tels que la quantit\u00e9 livr\u00e9e, la quantit\u00e9 factur\u00e9e et le tarif. Cette approche refl\u00e8te avec pr\u00e9cision les montants non factur\u00e9s par ligne.","ga_scenario":"Les utilisateurs cherchent souvent \u00e0 afficher le montant non factur\u00e9 pour chaque ligne d\u2019une recherche enregistr\u00e9e de commande client dans NetSuite. La difficult\u00e9 r\u00e9side dans le fait que les champs standard tels que \u00ab Montant non factur\u00e9 \u00bb ou \u00ab Montant restant \u00bb ne sont pas disponibles au niveau des lignes dans les recherches enregistr\u00e9es.","ga_solution":"Pour afficher avec pr\u00e9cision le montant non factur\u00e9 au niveau d\u2019une ligne de commande, les utilisateurs doivent cr\u00e9er un champ de formule dans leur recherche enregistr\u00e9e. Cette formule utilise les champs existants au niveau des lignes pour calculer la valeur souhait\u00e9e. Par exemple, pour d\u00e9terminer le montant non factur\u00e9 des articles qui ont \u00e9t\u00e9 exp\u00e9di\u00e9s mais qui n\u2019ont pas encore \u00e9t\u00e9 factur\u00e9s, utilisez la formule suivante : `({qtyfulfilled}-{qtybilled})*{rate}`. Pour <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-calculate-back-ordered-quantity-on-netsuite-sales-orders\/\">inclure les quantit\u00e9s en rupture de stock dans le calcul<\/a>, afin de refl\u00e9ter le montant total non factur\u00e9 sur la base de la quantit\u00e9 command\u00e9e \u00e0 l\u2019origine, utilisez cette formule alternative : `({quantity}-{qtybilled})*{rate}`.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:37:07-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Want to display unbilled amount at a line-item level on a SO saved search","ga_ans_id":"ANS-0051","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89,9],"ga_difficulty":[92],"class_list":["post-3710","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_audience-finance-accounting-team","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":89,"label":"Administrateur NetSuite"},{"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\/3710","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\/3710\/revisions"}],"predecessor-version":[{"id":5631,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3710\/revisions\/5631"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3710"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3710"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3710"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}