{"id":3852,"date":"2017-08-21T14:38:55","date_gmt":"2017-08-21T14:38:55","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-retrieve-the-transaction-internal-id-from-a-line-item-in-netsuite-2\/"},"modified":"2026-07-28T18:26:11","modified_gmt":"2026-07-28T18:26:11","slug":"comment-recuperer-lidentifiant-interne-de-la-transaction-a-partir-dun-poste-de-commande-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-recuperer-lidentifiant-interne-de-la-transaction-a-partir-dun-poste-de-commande-dans-netsuite\/","title":{"rendered":"Comment r\u00e9cup\u00e9rer l&rsquo;identifiant interne de la transaction \u00e0 partir d&rsquo;un poste de commande 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":"D\u00e9couvrez les m\u00e9thodes permettant d'obtenir avec pr\u00e9cision l'identifiant interne de la transaction parente lorsque vous travaillez avec des donn\u00e9es au niveau des lignes dans les recherches enregistr\u00e9es ou les champs personnalis\u00e9s de NetSuite.","ga_short_answer":"Pour r\u00e9cup\u00e9rer l\u2019identifiant interne de la transaction \u00e0 partir d\u2019un poste de facture, utilisez {id} dans une colonne de transaction. Vous pouvez \u00e9galement r\u00e9cup\u00e9rer l\u2019identifiant interne de la transaction dans un champ de corps personnalis\u00e9. Si un identifiant au niveau de la ligne est concat\u00e9n\u00e9 de mani\u00e8re inattendue (par exemple, \u00ab 1925_1 \u00bb), utilisez des fonctions de manipulation de cha\u00eenes telles que SUBSTR et INSTR pour extraire l\u2019identifiant de la transaction.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019acc\u00e9der \u00e0 l\u2019identifiant interne de l\u2019enregistrement de transaction principal (par exemple, un bon de commande) lorsqu\u2019ils travaillent avec des d\u00e9tails au niveau des lignes, comme dans une recherche enregistr\u00e9e affichant des lignes individuelles. Il peut parfois s\u2019av\u00e9rer difficile de r\u00e9f\u00e9rencer directement l\u2019identifiant de transaction \u00e0 partir du contexte d\u2019une ligne, en particulier si les identifiants au niveau des lignes sont format\u00e9s diff\u00e9remment.","ga_solution":"Pour r\u00e9cup\u00e9rer l\u2019identifiant interne de l\u2019enregistrement de transaction principal (par exemple, un bon de commande) \u00e0 partir du contexte d\u2019un poste de commande, le champ {id} d\u2019une colonne de transaction fournit g\u00e9n\u00e9ralement directement l\u2019identifiant interne de la transaction.Toutefois, si un identifiant au niveau de la ligne se pr\u00e9sentait sous la forme d\u2019une cha\u00eene concat\u00e9n\u00e9e comprenant \u00e0 la fois l\u2019identifiant de la transaction et le num\u00e9ro de ligne (par exemple, \u00ab 1925_1 \u00bb), une manipulation de cha\u00eene serait n\u00e9cessaire pour extraire uniquement l\u2019identifiant de la transaction. Dans un tel cas, la formule suivante pourrait \u00eatre utilis\u00e9e :\n\n```\nSUBSTR({id},0,INSTR({id},'_')-1)\n```\n\nCette formule extrait la sous-cha\u00eene comprise entre le d\u00e9but du champ {id} et le caract\u00e8re pr\u00e9c\u00e9dant imm\u00e9diatement le premier trait de soulignement, isolant ainsi efficacement l\u2019identifiant de la transaction. Une autre m\u00e9thode consiste \u00e0 <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-access-child-record-values-in-a-netsuite-saved-search\/\">enregistrer l\u2019identifiant interne de la transaction dans un champ de corps personnalis\u00e9<\/a> de l\u2019enregistrement de transaction. Une fois que le champ de corps personnalis\u00e9 est renseign\u00e9 avec la valeur {id}, son contenu peut alors \u00eatre r\u00e9f\u00e9renc\u00e9 dans n\u2019importe quelle colonne o\u00f9 l\u2019identifiant de transaction est requis, ce qui simplifie l\u2019acc\u00e8s sans recourir \u00e0 des fonctions de manipulation de cha\u00eenes complexes.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T16:38:55+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"{internalid} in the Transaction column of a PO ?","ga_ans_id":"ANS-0193","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 `{id}` in a transaction column would return a concatenated string like 'transaction ID_line number' (e.g., '1925_1') is not consistent with current NetSuite documentation. Current documentation and community discussions indicate that `{id}` typically refers to the internal ID of the main transaction record, while line-level identifiers are usually accessed via fields like `{line}` or `{lineuniquekey}`, which are generally numeric.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3852","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"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\/3852","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\/3852\/revisions"}],"predecessor-version":[{"id":5773,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3852\/revisions\/5773"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3852"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3852"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3852"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}