{"id":3494,"date":"2017-08-21T15:29:27","date_gmt":"2017-08-21T15:29:27","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-generer-un-rapport-sur-le-temps-estime-par-rapport-au-temps-alloue-par-service-dans-netsuite\/"},"modified":"2026-07-28T18:25:49","modified_gmt":"2026-07-28T18:25:49","slug":"comment-generer-un-rapport-sur-le-temps-estime-par-rapport-au-temps-alloue-par-service-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-generer-un-rapport-sur-le-temps-estime-par-rapport-au-temps-alloue-par-service-dans-netsuite\/","title":{"rendered":"Comment g\u00e9n\u00e9rer un rapport sur le temps estim\u00e9 par rapport au temps allou\u00e9 par service 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":"Comprenez les relations entre les donn\u00e9es relatives au travail estim\u00e9, au temps allou\u00e9 et au service afin d\u2019\u00e9tablir des rapports de projet complets.","ga_short_answer":"Alors que la cr\u00e9ation directe de rapports via l\u2019interface utilisateur pour comparer le travail estim\u00e9 et le temps allou\u00e9 par service constituait auparavant un d\u00e9fi en raison de la complexit\u00e9 du mod\u00e8le de donn\u00e9es, le classeur SuiteAnalytics de NetSuite facilite d\u00e9sormais les jointures \u00e0 plusieurs niveaux. Il est \u00e9galement possible d\u2019utiliser des portlets personnalis\u00e9s via des scripts ou des outils tiers tels qu\u2019iCharts pour g\u00e9n\u00e9rer ces rapports d\u00e9taill\u00e9s.","ga_scenario":"Les organisations ont souvent besoin de rapports d\u00e9taill\u00e9s comparant le travail estim\u00e9 au temps effectivement allou\u00e9, ventil\u00e9s par service, afin d\u2019\u00e9valuer l\u2019efficacit\u00e9 des projets et l\u2019utilisation des ressources. La difficult\u00e9 r\u00e9side dans la dispersion de ces donn\u00e9es entre diff\u00e9rents enregistrements NetSuite.","ga_solution":"La cr\u00e9ation de rapports sur le travail estim\u00e9 par rapport au temps allou\u00e9 par service implique de naviguer parmi des relations de donn\u00e9es sp\u00e9cifiques au sein de NetSuite. Le travail estim\u00e9 se trouve dans l\u2019<a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-identify-the-parent-project-of-a-netsuite-project-task\/\">enregistrement de t\u00e2che d\u2019affectation de<\/a> projet. Les informations relatives au service, en revanche, figurent dans un enregistrement de saisie de temps et sont li\u00e9es \u00e0 l\u2019enregistrement d\u2019employ\u00e9, qui se situe \u00e0 un niveau en retrait par rapport \u00e0 la t\u00e2che d\u2019affectation de projet. Jusqu\u2019\u00e0 pr\u00e9sent, la cr\u00e9ation d\u2019un tel rapport directement au sein de l\u2019interface utilisateur standard de NetSuite s\u2019av\u00e9rait difficile en raison de la nature \u00e0 plusieurs niveaux de ces relations entre les donn\u00e9es. Toutefois, le classeur SuiteAnalytics de NetSuite offre d\u00e9sormais des fonctionnalit\u00e9s robustes permettant de combiner des donn\u00e9es issues de diff\u00e9rents types d\u2019enregistrements, y compris celles n\u00e9cessitant des jointures \u00e0 plusieurs niveaux. Cela permet aux utilisateurs de cr\u00e9er des rapports complets directement au sein de l\u2019interface utilisateur en reliant les enregistrements \u00ab T\u00e2che de projet \u00bb, \u00ab Saisie des heures \u00bb et \u00ab Employ\u00e9 \u00bb. Pour les sc\u00e9narios n\u00e9cessitant une personnalisation avanc\u00e9e ou r\u00e9pondant \u00e0 des besoins de visualisation sp\u00e9cifiques, les options suivantes restent envisageables :\n1. Mettre en \u0153uvre un portlet personnalis\u00e9 via un script pour afficher les donn\u00e9es requises pour le rapport.\n2. Utiliser des solutions de reporting tierces telles qu\u2019iCharts, con\u00e7ues pour g\u00e9rer les relations complexes \u00e0 plusieurs niveaux au sein du diagramme des relations entre entit\u00e9s de NetSuite.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T17:29:27+02:00","ga_date_verified":"2026-07-05","ga_source_subject":"Can We make a Report on Estimated time vs Allocated Time By Department?","ga_ans_id":"ANS-1755","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The claim that the report 'cannot be accurately be created using the User Interface since the tables containing Estimated Work and Department are more than one level away from each other' is outdated. NetSuite's SuiteAnalytics Workbook, introduced after 2017, allows for multi-level joins of record types, enabling users to combine data from various sources, including those more than one join away from the root record type, directly within the user interface.","ga_final_category":"Project Management","footnotes":""},"ga_category":[107,21,107],"ga_audience":[89,9,75],"ga_difficulty":[92],"class_list":["post-3494","qa_entry","type-qa_entry","status-publish","hentry","ga_category-gestion-de-projet","ga_category-project-management","ga_audience-administrateur-netsuite","ga_audience-finance-accounting-team","ga_audience-project-managers","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":107,"label":"Gestion de projet"},{"value":21,"label":"Project Management"},{"value":107,"label":"Gestion de projet"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"},{"value":9,"label":"Finance\/accounting team"},{"value":75,"label":"Project managers"}],"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\/3494","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\/3494\/revisions"}],"predecessor-version":[{"id":5414,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3494\/revisions\/5414"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3494"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3494"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3494"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}