{"id":3905,"date":"2017-08-21T15:05:26","date_gmt":"2017-08-21T15:05:26","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-consulter-et-exporter-lhistorique-des-taux-de-change-dans-netsuite\/"},"modified":"2026-07-28T18:26:13","modified_gmt":"2026-07-28T18:26:13","slug":"comment-consulter-et-exporter-lhistorique-des-taux-de-change-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-consulter-et-exporter-lhistorique-des-taux-de-change-dans-netsuite\/","title":{"rendered":"Comment consulter et exporter l&rsquo;historique des taux de change dans 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":"Acc\u00e9dez \u00e0 l'historique des taux de change de NetSuite et cr\u00e9ez des recherches personnalis\u00e9es enregistr\u00e9es pour filtrer et exporter ces donn\u00e9es.","ga_short_answer":"Pour consulter l'historique des taux de change, acc\u00e9dez \u00e0 Listes > Comptabilit\u00e9 > Taux de change, puis cliquez sur \u00ab Historique \u00bb. Pour obtenir des donn\u00e9es filtr\u00e9es et exportables, cr\u00e9ez une recherche enregistr\u00e9e personnalis\u00e9e \u00e0 l'aide du type d'enregistrement \u00ab Taux de change \u00bb, en pr\u00e9cisant les crit\u00e8res et les r\u00e9sultats. Utilisez la fonction DECODE pour les noms de devises plut\u00f4t que les identifiants internes.","ga_scenario":"Les utilisateurs doivent pouvoir consulter et, le cas \u00e9ch\u00e9ant, exporter l'historique des taux de change au sein de NetSuite. L'interface standard offre une vue de l'historique des taux de change, mais des fonctionnalit\u00e9s de filtrage et d'exportation plus flexibles sont n\u00e9cessaires.","ga_solution":"Pour consulter l\u2019historique des taux de change directement dans NetSuite, proc\u00e9dez comme suit :\n1. Acc\u00e9dez \u00e0 Listes > Comptabilit\u00e9 > Taux de change.\n2. Cliquez sur le lien \u00ab Historique \u00bb en haut \u00e0 droite de la page. Cette page affiche toutes les mises \u00e0 jour apport\u00e9es aux taux de change et propose des options permettant de filtrer les r\u00e9sultats selon une plage de dates donn\u00e9e.Pour exporter des informations sur les taux de change ou cr\u00e9er un rapport personnalis\u00e9 avec des crit\u00e8res de filtrage sp\u00e9cifiques, une solution de contournement est d\u00e9crite sur la page SuiteAnswer \n37762. Les utilisateurs peuvent \u00e9galement <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-calculate-financial-ratios-in-netsuite-using-kpis-and-saved-searches\/\">cr\u00e9er un rapport personnalis\u00e9 (recherche enregistr\u00e9e)<\/a> pour extraire ces informations :\n1. Acc\u00e9dez \u00e0 Rapports > Recherches enregistr\u00e9es > Toutes les recherches enregistr\u00e9es > Nouveau.\n2. S\u00e9lectionnez \u00ab Taux de change \u00bb comme type d\u2019enregistrement.\n3. Dans le sous-onglet \u00ab Crit\u00e8res \u00bb, pr\u00e9cisez la plage de dates souhait\u00e9e.\n4. Dans le sous-onglet \u00ab R\u00e9sultats \u00bb, ajoutez les champs suivants : \u00ab Date d\u2019entr\u00e9e en vigueur \u00bb, \u00ab Taux de change \u00bb, \u00ab Devise de base \u00bb et \u00ab Devise de la transaction \u00bb.\n\nVeuillez noter que les champs \u00ab Devise de base \u00bb et \u00ab Devise de transaction \u00bb afficheront l\u2019identifiant interne plut\u00f4t que le nom r\u00e9el de la devise. Pour afficher les informations textuelles relatives \u00e0 la devise, vous pouvez utiliser un champ de formule faisant appel \u00e0 la fonction DECODE. Par exemple, utilisez un champ de formule (Texte) avec une fonction DECODE similaire \u00e0 celle-ci :\n```\nDECODE({basecurrency}, '1', 'CAN','2','GBP','3','USD','4','EURO') & DECODE({transactioncurrency}, '1', 'CAN','2','GBP','3','USD','4','EURO')\n```","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:05:26-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Exchange Rate History Report","ga_ans_id":"ANS-0246","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The menu path to view exchange rate history has changed from \"Financial --> List --> Currencies\" to \"Lists > Accounting > Currency Exchange Rates\".; The claim that it is not possible to filter the exchange rate history for a limited date range is outdated; the 'Currency Exchange Rate History' page includes a dropdown list of date ranges for filtering.; The menu path for creating a custom report (saved search) for currency exchange rates has changed from \"Financial --> List --> Currency Exchange Rate --> New\" to \"Reports > Saved Searches > All Saved Searches > New\", then selecting 'Currency Exchange Rate' as the record type.","ga_final_category":"Financial Reporting","footnotes":""},"ga_category":[33,110,110],"ga_audience":[9],"ga_difficulty":[92],"class_list":["post-3905","qa_entry","type-qa_entry","status-publish","hentry","ga_category-financial-reporting","ga_category-rapports-financiers","ga_audience-finance-accounting-team","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":33,"label":"Financial Reporting"},{"value":110,"label":"Rapports financiers"},{"value":110,"label":"Rapports financiers"}],"ga_audience":[{"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\/3905","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\/3905\/revisions"}],"predecessor-version":[{"id":5826,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3905\/revisions\/5826"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3905"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3905"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3905"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}