{"id":2841,"date":"2017-08-21T14:42:16","date_gmt":"2017-08-21T14:42:16","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-automatically-generate-a-upc-check-digit-in-netsuite-workflows-2\/"},"modified":"2026-07-28T18:25:15","modified_gmt":"2026-07-28T18:25:15","slug":"comment-generer-automatiquement-un-chiffre-de-controle-upc-dans-les-workflows-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-generer-automatiquement-un-chiffre-de-controle-upc-dans-les-workflows-netsuite\/","title":{"rendered":"Comment g\u00e9n\u00e9rer automatiquement un chiffre de contr\u00f4le UPC dans les workflows 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":"Automatisez la g\u00e9n\u00e9ration du 12e chiffre de contr\u00f4le des codes UPC dans les fiches d'articles NetSuite \u00e0 l'aide de formules de workflow personnalis\u00e9es.","ga_short_answer":"La solution consiste \u00e0 cr\u00e9er un workflow NetSuite qui se d\u00e9clenche lors de la cr\u00e9ation ou de la mise \u00e0 jour d\u2019un article. Elle utilise une formule personnalis\u00e9e pour calculer le chiffre de contr\u00f4le de l\u2019UPC \u00e0 partir des 11 chiffres existants ou d\u2019une s\u00e9quence, puis ajoute ce chiffre pour former l\u2019UPC complet \u00e0 12 chiffres. Cela garantit une g\u00e9n\u00e9ration pr\u00e9cise et automatis\u00e9e des codes UPC.","ga_scenario":"Les utilisateurs de NetSuite ont souvent besoin de g\u00e9n\u00e9rer automatiquement des codes UPC complets, y compris le 12e chiffre de contr\u00f4le, pour les fiches d'articles nouvelles ou mises \u00e0 jour. Cette exigence peut se pr\u00e9senter sous deux formes principales : soit en ajoutant le chiffre de contr\u00f4le \u00e0 un code UPC existant \u00e0 11 chiffres, soit en g\u00e9n\u00e9rant un code UPC complet \u00e0 12 chiffres sur la base d'une s\u00e9quence pr\u00e9d\u00e9finie.","ga_solution":"Cette solution explique comment mettre en \u0153uvre un workflow NetSuite permettant de g\u00e9n\u00e9rer automatiquement le chiffre de contr\u00f4le de l\u2019UPC. Cette approche peut \u00eatre adapt\u00e9e \u00e0 deux sc\u00e9narios courants :\n\n1.  **Ajout du 12e chiffre :** un workflow est d\u00e9clench\u00e9 lors de la validation si le champ \u00ab Code UPC \u00bb contient 11 chiffres. Ce sc\u00e9nario part du principe que l\u2019utilisateur saisit les 11 premiers chiffres.\n\n2.  **G\u00e9n\u00e9ration d\u2019un code UPC complet \u00e0 partir d\u2019une s\u00e9quence :** Lors de la cr\u00e9ation d\u2019un nouvel article, un workflow g\u00e9n\u00e8re automatiquement un code UPC unique en fonction d\u2019un num\u00e9ro de d\u00e9part de la plage UPC. Ce num\u00e9ro de d\u00e9part est enregistr\u00e9 en tant que variable de workflow et incr\u00e9ment\u00e9 de l\u2019identifiant interne de l\u2019article.\n\nDans les deux sc\u00e9narios, le num\u00e9ro UPC \u00e0 11 chiffres (du sc\u00e9nario 1) ou le num\u00e9ro UPC \u00e0 12 chiffres (du sc\u00e9nario 2) est utilis\u00e9 dans la formule suivante pour calculer le chiffre de contr\u00f4le :\n\n\n\n```\nMOD(SUBSTR({custworkflow_wf_next_upc_number}, 2, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 4, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 6, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 8, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 10, 1)+(SUBSTR({custworkflow_wf_next_upc_number}, 1, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 3, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 5, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 7, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 9, 1)+SUBSTR({custworkflow_wf_next_upc_number}, 11, 1)) * 3,10)\n```\n\n\n\n\n\n\n\nLe chiffre calcul\u00e9, qui est stock\u00e9 dans une variable (par exemple, `UPC building`\n\n\n\n), est ensuite ajout\u00e9 au num\u00e9ro UPC existant et enregistr\u00e9 dans le champ \u00ab Code UPC \u00bb \u00e0 l\u2019aide de cette formule :\n\n\n\n```\nUPC Code\u00caSE WHEN {custitem_upc_building} '10' THEN CONCAT({custworkflow_wf_next_upc_number},'0') ELSE CONCAT({custworkflow_wf_next_upc_number},{custitem_upc_building}) END\n```\n\n\n\nUne structure de formule similaire pourrait \u00eatre adapt\u00e9e aux codes EAN13.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:42:16-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Automatically creating UPC check digit","ga_ans_id":"ANS-1102","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Custom Fields, Records & Forms","footnotes":""},"ga_category":[97,22,97],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-2841","qa_entry","type-qa_entry","status-publish","hentry","ga_category-champs-personnalises-enregistrements-et-formulaires","ga_category-custom-fields-records-forms","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":97,"label":"Champs personnalis\u00e9s, enregistrements et formulaires"},{"value":22,"label":"Custom Fields, Records & Forms"},{"value":97,"label":"Champs personnalis\u00e9s, enregistrements et formulaires"}],"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\/2841","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\/2841\/revisions"}],"predecessor-version":[{"id":4761,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2841\/revisions\/4761"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2841"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2841"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2841"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}