{"id":4010,"date":"2017-08-21T15:32:55","date_gmt":"2017-08-21T15:32:55","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-creer-une-recherche-personnalisee-sur-les-comptes-clients-avec-des-periodes-de-vieillissement-dans-netsuite\/"},"modified":"2026-07-28T18:26:19","modified_gmt":"2026-07-28T18:26:19","slug":"comment-creer-une-recherche-personnalisee-sur-les-comptes-clients-avec-des-periodes-de-vieillissement-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-creer-une-recherche-personnalisee-sur-les-comptes-clients-avec-des-periodes-de-vieillissement-dans-netsuite\/","title":{"rendered":"Comment cr\u00e9er une recherche personnalis\u00e9e sur les comptes clients avec des p\u00e9riodes de vieillissement 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":"Reproduisez la fonctionnalit\u00e9 de p\u00e9riode d'anciennet\u00e9 du rapport de cr\u00e9ances clients de NetSuite \u00e0 l'aide d'une recherche personnalis\u00e9e de transactions enregistr\u00e9es comportant des champs de formule sp\u00e9cifiques.","ga_short_answer":"Pour cr\u00e9er une recherche personnalis\u00e9e sur les comptes clients avec des tranches d\u2019anciennet\u00e9 dans NetSuite, acc\u00e9dez \u00e0 Listes > Recherche > Recherches enregistr\u00e9es > Nouveau > Transactions. Configurez les crit\u00e8res pour \u00ab Comptes clients \u00bb et d\u00e9finissez plusieurs colonnes de r\u00e9sultats avec des formules (devises). Chaque formule calculera les montants pour des tranches d\u2019anciennet\u00e9 sp\u00e9cifiques (par exemple, 1 \u00e0 30 jours, 31 \u00e0 60 jours, 61 \u00e0 90 jours, plus de 91 jours) en fonction de la date d\u2019\u00e9ch\u00e9ance.","ga_scenario":"Les utilisateurs de NetSuite ont souvent besoin d\u2019une recherche personnalis\u00e9e sur les comptes clients (A\/R) qui affiche les soldes impay\u00e9s class\u00e9s par tranches d\u2019anciennet\u00e9 sp\u00e9cifiques, \u00e0 l\u2019instar du rapport A\/R standard. Cela permet un suivi et une analyse flexibles des cr\u00e9ances clients en fonction de leurs dates d\u2019\u00e9ch\u00e9ance. Le d\u00e9fi consiste \u00e0 configurer une recherche enregistr\u00e9e afin de calculer et de pr\u00e9senter avec pr\u00e9cision ces tranches d\u2019anciennet\u00e9.","ga_solution":"Pour cr\u00e9er une recherche personnalis\u00e9e sur les comptes clients qui refl\u00e8te le rapport sur les comptes clients avec les p\u00e9riodes de vieillissement, proc\u00e9dez comme suit :\n\n1. Acc\u00e9dez \u00e0 Listes > Recherche > Recherches enregistr\u00e9es > Nouveau > Transactions.\n2. Dans l\u2019onglet **Crit\u00e8res**, ajoutez `Account Accounts Receivable`\n    .\n3. Dans l\u2019onglet **R\u00e9sultats**, d\u00e9finissez les colonnes suivantes. Pour chaque colonne, utilisez un champ `Summary Type: Sum`\n    et `Formula (Currency)`\n    , \u00e0 l\u2019exception de la premi\u00e8re colonne GA_KEEP_0004,\n    qui correspond \u00e0 `Group`\n    .\n\n*   Champ : Nom\n    Type de synth\u00e8se : Groupe\n    Formule : (vide)\n    Libell\u00e9 personnalis\u00e9 : (vide)\n\n*   Champ : Nom\n    Type de synth\u00e8se : Somme\n    Formule :\n\n```\ncase when trunc({today})-{duedate} between 1 and 30 then {amount} end\n```\n    Libell\u00e9 personnalis\u00e9 : 1-30\n\n*   Champ : Nom\n    Type de synth\u00e8se : Somme\n    Formule :\n\n```\ncase when trunc({today})-{duedate} between 31 and 60 then {amount} end\n```\n    Libell\u00e9 personnalis\u00e9 : 31-60\n\n*   Champ : Nom\n    Type de synth\u00e8se : Somme\n    Formule :\n\n```\ncase when trunc({today})-{duedate} between 61 and 90 then {amount} end\n```\n    Libell\u00e9 personnalis\u00e9 : 61-90\n\n*   Champ : Nom\n    Type de synth\u00e8se : Somme\n    Formule :\n\n```\ncase when trunc({today})-{duedate} > 90 then {amount} end\n```\n    Libell\u00e9 personnalis\u00e9 : Plus de 91\n\n*   Champ : Nom\n    Type de synth\u00e8se : Somme\n    Formule :\n\n```\nNVL(case when trunc({today})-{duedate} between 1 and 30 then {amount} end,0) + NVL(case when trunc({today})-{duedate} between 31 and 60 then {amount} end,0) + NVL(case when trunc({today})-{duedate} between 61 and 90 then {amount} end ,0)+ NVL(case when trunc({today})-{duedate} > 91 then {amount} end,0)\n```\n    Libell\u00e9 personnalis\u00e9 : Total en cours\n\n4. Cliquez sur le bouton **Aper\u00e7u** ou **Enregistrer** pour afficher ou enregistrer la recherche.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:32:55+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"Aging Buckets","ga_ans_id":"ANS-0351","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Financial Reporting","footnotes":""},"ga_category":[33,110,110],"ga_audience":[9],"ga_difficulty":[92],"class_list":["post-4010","qa_entry","type-qa_entry","status-publish","hentry","ga_category-financial-reporting","ga_category-rapports-financiers","ga_audience-finance-accounting-team","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":33,"label":"Financial Reporting"},{"value":110,"label":"Rapports financiers"},{"value":110,"label":"Rapports financiers"}],"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\/4010","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\/4010\/revisions"}],"predecessor-version":[{"id":5931,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4010\/revisions\/5931"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=4010"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=4010"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=4010"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=4010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}