{"id":3947,"date":"2017-08-21T15:16:55","date_gmt":"2017-08-21T15:16:55","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-convertir-des-valeurs-numeriques-en-mots-anglais-dans-les-transactions-netsuite\/"},"modified":"2026-07-28T18:26:16","modified_gmt":"2026-07-28T18:26:16","slug":"comment-convertir-des-valeurs-numeriques-en-mots-anglais-dans-les-transactions-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-convertir-des-valeurs-numeriques-en-mots-anglais-dans-les-transactions-netsuite\/","title":{"rendered":"Comment convertir des valeurs num\u00e9riques en mots anglais dans les transactions 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":"Ce guide fournit des formules NetSuite permettant d'afficher les montants des transactions sous forme de mots en anglais, y compris des solutions pour la gestion des centimes d\u00e9cimaux.","ga_short_answer":"Pour convertir une valeur num\u00e9rique en mots anglais dans NetSuite, utilisez la formule TO_CHAR(TO_DATE({votre_champ}, 'j'), 'jsp'). Pour traiter les centimes, une formule plus complexe utilisant les instructions INITCAP, TRUNC et CASE peut \u00eatre mise en \u0153uvre afin de repr\u00e9senter avec pr\u00e9cision le montant total en lettres.","ga_scenario":"Les utilisateurs de NetSuite ont souvent besoin d\u2019afficher des montants de transactions num\u00e9riques, tels que les totaux de factures, sous forme de mots en anglais sur des documents imprim\u00e9s. La fonctionnalit\u00e9 standard de NetSuite ne propose pas en soi de m\u00e9thode directe pour effectuer cette conversion, en particulier lorsqu\u2019il s\u2019agit de valeurs d\u00e9cimales repr\u00e9sentant des centimes. Cette exigence est courante dans les documents juridiques ou officiels o\u00f9 les montants doivent \u00eatre \u00e9crits en toutes lettres.","ga_solution":"Les utilisateurs de NetSuite peuvent convertir des valeurs num\u00e9riques en mots anglais \u00e0 l\u2019aide de formules de type SQL dans des recherches enregistr\u00e9es ou des champs personnalis\u00e9s.\n\nPour convertir une valeur num\u00e9rique en son \u00e9quivalent en mots anglais (par exemple, 123 en \u00ab One Hundred Twenty-Three \u00bb) :\n```\nTO_CHAR(TO_DATE({your_field}, 'j'), 'jsp')\n```\n\nCette formule est simple, mais ne prend pas en charge les valeurs d\u00e9cimales (centimes). Par exemple, 123,45 serait converti en \u00ab One Hundred Twenty-Three \u00bb sans tenir compte des 45 centimes.\n\nPour repr\u00e9senter avec pr\u00e9cision les montants incluant des centimes (par exemple, 123,45 en \u00ab One Hundred Twenty-Three AND Forty-Five CENTS \u00bb), vous pouvez utiliser la formule suivante. Cet exemple utilise le champ standard `TOTAL`\nd\u2019une facture :\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```\nCette formule avanc\u00e9e convertit d\u2019abord la partie enti\u00e8re du montant total, puis v\u00e9rifie s\u2019il y a des centimes. S\u2019il y en a, elle convertit la partie en centimes en mots et ajoute \u00ab CENTIMES \u00bb ; dans le cas contraire, elle ajoute \u00ab SEULEMENT \u00bb.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:16:55-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Convert numeric value to english words when printing transaction","ga_ans_id":"ANS-0288","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"verify_first","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Printing, PDF & Email Templates","footnotes":""},"ga_category":[95,19,95],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3947","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-niveau-intermediaire"],"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":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\/3947","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\/3947\/revisions"}],"predecessor-version":[{"id":5868,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3947\/revisions\/5868"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3947"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3947"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3947"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}