{"id":4210,"date":"2017-08-21T15:20:45","date_gmt":"2017-08-21T15:20:45","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-netsuite-calcule-t-il-le-taux-de-change-moyen-consolide\/"},"modified":"2026-07-28T18:26:31","modified_gmt":"2026-07-28T18:26:31","slug":"comment-netsuite-calcule-t-il-le-taux-de-change-moyen-consolide","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-netsuite-calcule-t-il-le-taux-de-change-moyen-consolide\/","title":{"rendered":"Comment NetSuite calcule-t-il le taux de change moyen consolid\u00e9 ?"},"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":"Comprenez la m\u00e9thodologie sp\u00e9cifique utilis\u00e9e par NetSuite pour calculer les taux de change moyens dans le cadre des rapports financiers consolid\u00e9s, en vous concentrant sur les calculs au niveau des filiales.","ga_short_answer":"NetSuite calcule le taux de change consolid\u00e9 moyen pour chaque filiale \u00e0 l\u2019aide de la formule SUMSUM(Impact GL \u00d7 Taux de change)\/SUMSUM(Impact GL). Ce calcul ne prend en compte que les \u00e9critures pass\u00e9es sur des comptes dont le type de taux est \u00ab Moyenne \u00bb, en utilisant le taux de change entre la devise de base de la filiale et celle de sa soci\u00e9t\u00e9 m\u00e8re la plus proche \u00e0 la date de la transaction, tel que d\u00e9fini dans le tableau \u00ab Taux de change \u00bb.","ga_scenario":"Les utilisateurs cherchent souvent \u00e0 comprendre la m\u00e9thodologie pr\u00e9cise utilis\u00e9e par NetSuite pour calculer les taux de change consolid\u00e9s moyens, en particulier lorsqu\u2019ils ont affaire \u00e0 plusieurs filiales \u00e9tablissant leurs rapports dans des devises diff\u00e9rentes. Des \u00e9carts ou des valeurs inattendues peuvent appara\u00eetre si la logique de calcul sous-jacente, notamment en ce qui concerne les taux sp\u00e9cifiques aux filiales et la d\u00e9finition du taux de change, n\u2019est pas parfaitement comprise.","ga_solution":"NetSuite calcule le taux de change moyen consolid\u00e9 pour chaque filiale. Cela signifie que, m\u00eame pour des paires de devises identiques, deux filiales \u00e9tablissant leurs comptes dans la m\u00eame devise (par exemple, le CAD) et relevant de la m\u00eame soci\u00e9t\u00e9 m\u00e8re dans une autre devise (par exemple, l\u2019USD) peuvent pr\u00e9senter des taux moyens diff\u00e9rents.Le calcul suit la formule suivante :\n\n```\nSUM(GL Impact x Exchange Rate)\/SUM(GL Impact)\n```\n\nSeules les \u00e9critures pass\u00e9es sur des comptes configur\u00e9s avec un type de taux \u00ab Moyenne \u00bb sont prises en compte dans ce calcul. Le terme \u00ab Taux de change \u00bb de la formule correspond \u00e0 :\n1.  Au taux de change entre la devise de base de la filiale et la devise de base de sa soci\u00e9t\u00e9 m\u00e8re la plus proche (de la filiale vers la soci\u00e9t\u00e9 m\u00e8re).\n2.  Au taux d\u00e9fini dans la table des taux de change, accessible via `Lists > Accounting > Currency Exchange Rates`.\n3.  Au taux en vigueur \u00e0 la date de la transaction.","ga_source_author":"Jean-Mathieu Rose","ga_source_author_email":"","ga_date_original":"2017-08-21T17:20:45+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"Average Rate Calculation : Exchange Rates on GL Account Record","ga_ans_id":"ANS-0551","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Accounting & Financial Configuration","footnotes":""},"ga_category":[24,98,98],"ga_audience":[9],"ga_difficulty":[92],"class_list":["post-4210","qa_entry","type-qa_entry","status-publish","hentry","ga_category-accounting-financial-configuration","ga_category-configuration-comptable-et-financiere","ga_audience-finance-accounting-team","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":24,"label":"Accounting & Financial Configuration"},{"value":98,"label":"Configuration comptable et financi\u00e8re"},{"value":98,"label":"Configuration comptable et financi\u00e8re"}],"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\/4210","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\/4210\/revisions"}],"predecessor-version":[{"id":6131,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4210\/revisions\/6131"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=4210"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=4210"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=4210"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=4210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}