{"id":3779,"date":"2017-08-21T15:08:29","date_gmt":"2017-08-21T15:08:29","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-search-item-fulfillment-lines-with-missing-account-data-in-netsuite-2\/"},"modified":"2026-07-28T18:26:07","modified_gmt":"2026-07-28T18:26:07","slug":"comment-rechercher-des-lignes-de-traitement-des-commandes-pour-lesquelles-des-donnees-de-compte-sont-manquantes-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-rechercher-des-lignes-de-traitement-des-commandes-pour-lesquelles-des-donnees-de-compte-sont-manquantes-dans-netsuite\/","title":{"rendered":"Comment rechercher des lignes de traitement des commandes pour lesquelles des donn\u00e9es de compte sont manquantes 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 comment interroger efficacement les enregistrements \u00ab Item Fulfillment \u00bb de NetSuite afin d\u2019extraire des d\u00e9tails au niveau des lignes, en particulier lorsque celles-ci ne sont associ\u00e9es \u00e0 aucun compte, \u00e0 l\u2019aide des filtres de recherche SuiteScript 2.x.","ga_short_answer":"Pour rechercher les lignes de traitement des commandes NetSuite qui ne sont associ\u00e9es \u00e0 aucun compte, cr\u00e9ez une requ\u00eate SuiteScript 2.x en utilisant le type d'enregistrement interne \u00ab itemfulfillment \u00bb. Appliquez un filtre ['account', 'anyof', '@NONE@'] pour cibler sp\u00e9cifiquement les lignes dont le champ \u00ab account \u00bb est vide ou nul, ce qui garantit une r\u00e9cup\u00e9ration pr\u00e9cise des donn\u00e9es au niveau des lignes.","ga_scenario":"Les utilisateurs rencontrent souvent des difficult\u00e9s lorsqu\u2019ils tentent d\u2019extraire des informations sp\u00e9cifiques au niveau des lignes \u00e0 partir des transactions \u00ab Item Fulfillment \u00bb de NetSuite. Bien que les filtres de recherche standard soient g\u00e9n\u00e9ralement efficaces pour les donn\u00e9es au niveau des lignes, une difficult\u00e9 particuli\u00e8re survient lorsqu\u2019on tente d\u2019identifier ou de filtrer les lignes dont certains champs, tels que le compte associ\u00e9, sont vides ou nuls. Cela peut emp\u00eacher la r\u00e9cup\u00e9ration de tous les d\u00e9tails n\u00e9cessaires relatifs aux lignes.","ga_solution":"Pour r\u00e9cup\u00e9rer avec pr\u00e9cision les d\u00e9tails des lignes de traitement des commandes, en particulier lorsque celles-ci ne sont associ\u00e9es \u00e0 aucun compte, une recherche SuiteScript 2.x doit \u00eatre configur\u00e9e avec un filtre sp\u00e9cifique. Bien que le fait de d\u00e9finir \u00ab Main Line \u00bb sur \u00ab false \u00bb soit une approche standard pour les donn\u00e9es au niveau des lignes, la cl\u00e9 de ce sc\u00e9nario particulier consiste \u00e0 filtrer explicitement les lignes pour lesquelles le champ \u00ab account \u00bb est vide. Pour ce faire, ajoutez le filtre ['account', 'anyof', '@NONE@'] aux crit\u00e8res de recherche. L\u2019interface utilisateur de NetSuite ne propose pas directement d\u2019option permettant de s\u00e9lectionner \u00ab none \u00bb ou \u00ab empty \u00bb pour ce champ, ce qui n\u00e9cessite une solution programmatique. Vous trouverez ci-dessous un exemple d\u2019impl\u00e9mentation de recherche en SuiteScript 2.x :\n\n```\njavascript\/\/ Ensure the 'N\/search' module is loaded in your SuiteScript 2.x environment.\/\/ Example: define(['N\/search'], function(search) { ... });var columns = [];columns.push(search.createColumn({ name: 'internalid', sort: search.Sort.ASC }));columns.push(search.createColumn({ name: 'quantity' }));columns.push(search.createColumn({ name: 'itemid', join: 'item' }));columns.push(search.createColumn({ name: 'account' }));var filters = [    [\"type\", \"anyof\", \"itemfulfillment\"],    \"AND\",    [\"account\", \"anyof\", \"@NONE@\"]];var itemFulfillmentSearch = search.create({    type: \"itemfulfillment\",    filters: filters,    columns: columns});var searchResults = itemFulfillmentSearch.run().getRange({ start: 0, end: 1000 });\/\/ 'searchResults' will contain an array of search.Result objects.\n```\n\n. Ce script d\u00e9finit une recherche ciblant le type d\u2019enregistrement \u00ab itemfulfillment \u00bb, incluant les colonnes essentielles au niveau des lignes et appliquant le filtre crucial permettant d\u2019identifier les lignes auxquelles aucun compte n\u2019est attribu\u00e9.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:08:29-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to search itemfulfillment lines ?","ga_ans_id":"ANS-0120","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The SuiteScript 1.0 functions `nlobjSearchColumn` and `nlapiSearchRecord` are outdated; current NetSuite development uses SuiteScript 2.x functions like `search.createColumn` and `search.create`\/`search.run` for searches.; The internal record type `ItemShip` used in the example code is incorrect; the current internal ID for Item Fulfillment is `itemfulfillment`.; The claim that the 'Main Line false filter can't work' appears to be inaccurate, as setting 'Main Line' to false (or 'No' in the UI) is a standard method to retrieve line-level details in transaction searches, including item fulfillments.; The filter array structure with explicit 'AND' operators and duplicate type filters is characteristic of SuiteScript 1.0 and would be structured differently in SuiteScript 2.x.","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3779","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\/3779","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\/3779\/revisions"}],"predecessor-version":[{"id":5700,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3779\/revisions\/5700"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3779"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3779"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3779"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}