{"id":2959,"date":"2018-11-19T15:02:38","date_gmt":"2018-11-19T15:02:38","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-corriger-lerreur-bad-sql-statement-dans-les-regles-de-chiffre-daffaires-des-projets-netsuite\/"},"modified":"2026-07-28T18:25:21","modified_gmt":"2026-07-28T18:25:21","slug":"comment-corriger-lerreur-bad-sql-statement-dans-les-regles-de-chiffre-daffaires-des-projets-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-corriger-lerreur-bad-sql-statement-dans-les-regles-de-chiffre-daffaires-des-projets-netsuite\/","title":{"rendered":"Comment corriger l&rsquo;erreur \u00ab Bad SQL Statement \u00bb dans les r\u00e8gles de chiffre d&rsquo;affaires des projets 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":"Une erreur \u00ab Bad SQL Statement \u00bb peut se produire dans NetSuite Advanced Revenue Management lorsqu\u2019une r\u00e8gle de chiffre d\u2019affaires de projet cr\u00e9\u00e9e par l\u2019utilisateur entre en conflit avec une r\u00e8gle g\u00e9n\u00e9r\u00e9e par le syst\u00e8me au cours du processus \u00ab Mise \u00e0 jour des accords de chiffre d\u2019affaires et des plans \u00bb.","ga_short_answer":"L\u2019erreur \u00ab Bad SQL Statement \u00bb dans NetSuite Advanced Revenue Management, lors de l\u2019utilisation de r\u00e8gles de chiffre d\u2019affaires de projet avec une facturation bas\u00e9e sur les frais, se produit lorsqu\u2019une r\u00e8gle de chiffre d\u2019affaires cr\u00e9\u00e9e manuellement entre en conflit avec une r\u00e8gle g\u00e9n\u00e9r\u00e9e par le syst\u00e8me. Pour r\u00e9soudre ce probl\u00e8me, renommez la r\u00e8gle cr\u00e9\u00e9e par l\u2019utilisateur afin d\u2019\u00e9viter le conflit de noms. Cela permet au syst\u00e8me de cr\u00e9er correctement la r\u00e8gle requise lors du processus \u00ab Mise \u00e0 jour des accords de chiffre d\u2019affaires et des plans \u00bb.","ga_scenario":"Lors de la mise en \u0153uvre <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-resolve-revenue-element-creation-issues-for-project-revenue-rules\/\">de<\/a> NetSuite Advanced Revenue Management, en particulier dans le cadre d\u2019une facturation \u00e0 l\u2019acte o\u00f9 les r\u00e8gles de chiffre d\u2019affaires sont d\u00e9finies directement sur les projets, les utilisateurs peuvent rencontrer une erreur \u00ab Bad SQL Statement \u00bb. Celle-ci survient g\u00e9n\u00e9ralement lors de la premi\u00e8re ex\u00e9cution du processus \u00ab Mise \u00e0 jour des accords et plans de chiffre d\u2019affaires \u00bb. Cette erreur survient lorsqu\u2019un utilisateur a cr\u00e9\u00e9 manuellement une r\u00e8gle de chiffre d\u2019affaires dont le nom est identique \u00e0 celui d\u2019une r\u00e8gle de chiffre d\u2019affaires de projet que NetSuite tente de g\u00e9n\u00e9rer automatiquement lors de la cr\u00e9ation d\u2019un \u00e9l\u00e9ment de chiffre d\u2019affaires pour la premi\u00e8re fois.","ga_solution":"Pour r\u00e9soudre l\u2019erreur \u00ab Bad SQL Statement \u00bb, proc\u00e9dez comme suit :\n1. Identifiez la r\u00e8gle de chiffre d\u2019affaires cr\u00e9\u00e9e manuellement qui est \u00e0 l\u2019origine du conflit de nommage. Cette r\u00e8gle a \u00e9t\u00e9 cr\u00e9\u00e9e par un utilisateur et porte potentiellement un nom similaire \u00e0 celui d\u2019une r\u00e8gle de chiffre d\u2019affaires de projet g\u00e9n\u00e9r\u00e9e par le syst\u00e8me.\n2. Renommez la r\u00e8gle de chiffre d\u2019affaires cr\u00e9\u00e9e par l\u2019utilisateur que vous avez identifi\u00e9e. Par exemple, si la r\u00e8gle en conflit s\u2019intitulait \u00ab R\u00e8gle de chiffre d\u2019affaires du projet \u00bb, renommez-la \u00ab R\u00e8gle de chiffre d\u2019affaires du projet_2 \u00bb ou donnez-lui un autre identifiant unique.\n3. Ex\u00e9cutez \u00e0 nouveau le processus \u00ab Mise \u00e0 jour des accords de chiffre d\u2019affaires et des plans \u00bb. Une fois l\u2019ex\u00e9cution r\u00e9ussie, le syst\u00e8me pourra cr\u00e9er la r\u00e8gle de chiffre d\u2019affaires de projet requise sans conflit, et le processus s\u2019ach\u00e8vera comme pr\u00e9vu.","ga_source_author":"Jean-Mathieu Rose","ga_source_author_email":"","ga_date_original":"2018-11-19T07:02:38-08:00","ga_date_verified":"2026-07-05","ga_source_subject":"Getting a Bad SQL Statement Error when running update revenue arrangement process (Advanced Revenue Management in a context of Charge Based Billing)","ga_ans_id":"ANS-1220","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The claim that the system creates a revenue rule specifically named 'Project Revenue Rule' is not explicitly supported by current NetSuite documentation. Current documentation refers to specific types of project revenue rules (e.g., Labor Based, Fixed Amount, Percent Complete) that users create, and other system-generated rules with different names (e.g., Default Standard, Default Percent Complete).","ga_final_category":"Revenue Recognition","footnotes":""},"ga_category":[111,36,111],"ga_audience":[35],"ga_difficulty":[92],"class_list":["post-2959","qa_entry","type-qa_entry","status-publish","hentry","ga_category-reconnaissance-des-revenus","ga_category-revenue-recognition","ga_audience-implementation-consultant","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":111,"label":"Reconnaissance des revenus"},{"value":36,"label":"Revenue Recognition"},{"value":111,"label":"Reconnaissance des revenus"}],"ga_audience":[{"value":35,"label":"Implementation consultant"}],"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\/2959","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\/2959\/revisions"}],"predecessor-version":[{"id":4879,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2959\/revisions\/4879"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2959"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2959"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2959"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}