--- id: post/thedynamicsexplorer-com/9995 type: post title: Dynamics GP to Business Central – The Arrival of Smartlist Features via “Add Fields from Related Tables in Analysis Mode” summary: Business Central introduced 'Add fields from related tables in Analysis mode', a feature that mirrors Dynamics GP's Smartlist tool, enabling users to create custom reports by combining columns from related tables directly within list pages and analysis views without third-party tools. tier: community language: en tags: - analysis mode - reporting - list pages - smartlist - data joining - custom columns system: reporting review: state: reviewed by: opus at: "2026-10-08T01:59:37.734Z" flags: [] generated: at: "2026-10-08T01:26:53.141Z" pipeline: 0.2.0 prompts: extract-post: 1 input_hash: b746cd106bf8766272e04c5010aa63376839ede48a943e170b975ba7a7170fbe evidence: - kind: blog url: https://thedynamicsexplorer.com/2025/08/22/dynamics-gp-to-business-central-the-arrival-of-smartlist-features-via-add-fields-from-related-tables-in-analysis-mode/ title: Dynamics GP to Business Central – The Arrival of Smartlist Features via “Add Fields from Related Tables in Analysis Mode” date: "2025-08-22" commit: null t: null quote: null - kind: blog url: https://thedynamicsexplorer.com/2025/08/22/dynamics-gp-to-business-central-the-arrival-of-smartlist-features-via-add-fields-from-related-tables-in-analysis-mode/ title: Dynamics GP to Business Central – The Arrival of Smartlist Features via “Add Fields from Related Tables in Analysis Mode” date: "2025-08-22" commit: null t: null quote: The real power of this functionality comes when you want to include data from other related tables. - kind: blog url: https://thedynamicsexplorer.com/2025/08/22/dynamics-gp-to-business-central-the-arrival-of-smartlist-features-via-add-fields-from-related-tables-in-analysis-mode/ title: Dynamics GP to Business Central – The Arrival of Smartlist Features via “Add Fields from Related Tables in Analysis Mode” date: "2025-08-22" commit: null t: null quote: Lots more reporting requirements can be fulfilled without the need for third party reporting tools. links: learn: [] objects: - object/page/518 - object/page/256 - object/page/2610 features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] post_id: "9995" source_id: thedynamicsexplorer-com source_name: The Dynamics Explorer url: https://thedynamicsexplorer.com/2025/08/22/dynamics-gp-to-business-central-the-arrival-of-smartlist-features-via-add-fields-from-related-tables-in-analysis-mode/ published_at: "2025-08-22T09:00:00.000Z" author: Gavin Whittaker full_text: false words: 800 quotes: - text: The real power of this functionality comes when you want to include data from other related tables. why_it_matters: Identifies the key differentiator and primary value proposition of the feature beyond basic personalization - text: Lots more reporting requirements can be fulfilled without the need for third party reporting tools. why_it_matters: Demonstrates the practical business impact of reducing dependency on external solutions code_objects_mentioned: - page Purchase Lines - page Payment Journal - page Feature Management systems: - reporting - finance - purchasing versions_mentioned: [] preview: embeddable: true frame_url: https://thedynamicsexplorer.com/2025/08/22/dynamics-gp-to-business-central-the-arrival-of-smartlist-features-via-add-fields-from-related-tables-in-analysis-mode/embed/ image: https://i0.wp.com/thedynamicsexplorer.com/wp-content/uploads/2025/08/dynamics-gp-to-business-central-the-arrival-of-smartlist-features-via-add-fields-from-related-tables-in-analysis-mode.png?fit=1200%2C675&ssl=1 image_alt: null image_w: 1200 image_h: 675 site_name: null favicon: https://s1.wp.com/i/favicon.ico?m=1713425267i probed_at: "2026-10-07T11:51:01.070Z" --- # Dynamics GP to Business Central – The Arrival of Smartlist Features via “Add Fields from Related Tables in Analysis Mode” [Read the post](https://thedynamicsexplorer.com/2025/08/22/dynamics-gp-to-business-central-the-arrival-of-smartlist-features-via-add-fields-from-related-tables-in-analysis-mode/) · The Dynamics Explorer (Gavin Whittaker) · 2025-08-22 · 800 words · tier community · reviewed (checked by Opus) > Business Central introduced 'Add fields from related tables in Analysis mode', a feature that mirrors Dynamics GP's Smartlist tool, enabling users to create custom reports by combining columns from related tables directly within list pages and analysis views without third-party tools. ## Key points - The feature allows adding columns from related tables to list pages in Analysis mode after activating it via Feature Management - Users can save custom report views as Favourites to avoid recreating them repeatedly - The real power lies in joining data from multiple related tables, similar to Smartlist Designer in Dynamics GP - Users can manually link to tables that Business Central doesn't automatically suggest, expanding reporting possibilities ## Quotes - "The real power of this functionality comes when you want to include data from other related tables." (Identifies the key differentiator and primary value proposition of the feature beyond basic personalization) - "Lots more reporting requirements can be fulfilled without the need for third party reporting tools." (Demonstrates the practical business impact of reducing dependency on external solutions) ## AL objects mentioned As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named. - [page 518 "Purchase Lines"](../../objects/page/518.md) - [page 256 "Payment Journal"](../../objects/page/256.md) - [page 2610 "Feature Management"](../../objects/page/2610.md) ## Context - Features: Add fields from related tables in Analysis mode, Analyse button on list pages, Add columns from related tables, Save Favourites, Custom table linking via Other source option, Data filtering and export Source: The Dynamics Explorer, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.