{"id":2836,"date":"2017-08-21T14:48:08","date_gmt":"2017-08-21T14:48:08","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-afficher-les-montants-numeriques-sous-forme-de-mots-sur-les-factures-netsuite\/"},"modified":"2026-07-28T18:25:15","modified_gmt":"2026-07-28T18:25:15","slug":"comment-afficher-les-montants-numeriques-sous-forme-de-mots-sur-les-factures-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-afficher-les-montants-numeriques-sous-forme-de-mots-sur-les-factures-netsuite\/","title":{"rendered":"Comment afficher les montants num\u00e9riques sous forme de mots sur les factures 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 configurer les champs personnalis\u00e9s de NetSuite afin de convertir les montants totaux des factures en une repr\u00e9sentation textuelle pour une meilleure lisibilit\u00e9.","ga_short_answer":"Pour afficher les montants num\u00e9riques sous forme de mots sur les factures NetSuite, il est possible de configurer un champ personnalis\u00e9 dans le corps de la transaction. Bien que NetSuite propose d\u00e9sormais des fonctions plus directes telles que `format.spellOut` ou le champ `{record.amountwords}` \u00e0 cette fin, une formule de type SQL peut \u00e9galement \u00eatre utilis\u00e9e pour convertir le montant total de la facture en un format texte lisible par l'utilisateur, directement sur la facture.","ga_scenario":"Les organisations exigent souvent que les montants totaux des factures soient affich\u00e9s non seulement sous forme de valeurs num\u00e9riques, mais \u00e9galement sous leur \u00e9quivalent en toutes lettres. Cela s\u2019av\u00e8re particuli\u00e8rement utile pour des raisons de clart\u00e9, de conformit\u00e9 l\u00e9gale ou pour respecter les formats de documents traditionnels. Le d\u00e9fi consiste \u00e0 configurer NetSuite de mani\u00e8re \u00e0 ce qu\u2019il convertisse automatiquement le montant total de la facture en une cha\u00eene de texte pouvant \u00eatre imprim\u00e9e sur la facture.","ga_solution":"NetSuite propose plusieurs m\u00e9thodes pour convertir des valeurs num\u00e9riques en mots. Bien que des fonctions plus directes telles que `format.spellOut` et le champ `{record.amountwords}` soient d\u00e9sormais privil\u00e9gi\u00e9es \u00e0 cette fin dans les champs de formule ou les mod\u00e8les, il est \u00e9galement possible de configurer un champ personnalis\u00e9 du corps de la transaction \u00e0 l\u2019aide d\u2019une formule de type SQL. Cette approche \u00e9tait auparavant utilis\u00e9e pour obtenir la repr\u00e9sentation textuelle souhait\u00e9e sur les factures. Pour mettre cela en \u0153uvre, vous pouvez cr\u00e9er un champ personnalis\u00e9 du corps de la transaction de type \u00ab Texte libre \u00bb ou \u00ab Zone de texte \u00bb \u00e0 l\u2019aide de la formule suivante, qui traite le champ `{TOTAL}` de la facture afin de convertir la partie enti\u00e8re et les centimes d\u00e9cimaux en leurs \u00e9quivalents en lettres, ce qui permet d\u2019afficher le montant sous forme de texte sur la facture :\n\n```\nINITCAP(TO_CHAR (TO_DATE (TRUNC ({TOTAL}), 'J'), 'JSP')  || CASE WHEN(({TOTAL} - trunc({TOTAL}))*100 > 0) THEN (' AND ' ||  TO_CHAR(TO_DATE(({TOTAL} - trunc({TOTAL}))*100, 'J'), 'JSP') || ' CENTS') ELSE ' ONLY' END)\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T16:48:08+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"Numbers as Text on the Invoice","ga_ans_id":"ANS-1097","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_first","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The reliance on a complex SQL formula for converting numbers to words, as NetSuite now offers a more direct native function (`format.spellOut`) for this purpose.","ga_final_category":"Printing, PDF & Email Templates","footnotes":""},"ga_category":[95,19,95],"ga_audience":[89],"ga_difficulty":[94],"class_list":["post-2836","qa_entry","type-qa_entry","status-publish","hentry","ga_category-impression-pdf-et-modeles-de-mails","ga_category-printing-pdf-email-templates","ga_audience-administrateur-netsuite","ga_difficulty-avance"],"taxonomy_info":{"ga_category":[{"value":95,"label":"Impression, PDF et mod\u00e8les d\u2019e-mails"},{"value":19,"label":"Printing, PDF & Email Templates"},{"value":95,"label":"Impression, PDF et mod\u00e8les d\u2019e-mails"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":94,"label":"Avanc\u00e9"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2836","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\/2836\/revisions"}],"predecessor-version":[{"id":4756,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2836\/revisions\/4756"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2836"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2836"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2836"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}