--- id: post/thedynamicsexplorer-com/8821 type: post title: Dynamics GP to Business Central – How to Recreate the GL Summary Enquiry using G/L Account Balance, Analysis Mode or an Analysis View summary: "When migrating from Dynamics GP to Business Central, GL account structures change from segmented codes to single codes with dimensions. The post explains three methods to recreate Dynamics GP's GL Summary Enquiry view in Business Central: filtering the Chart of Accounts page, using Analysis Mode with natural language in Copilot, or creating an Analysis View." tier: community language: en tags: - migration - general ledger - chart of accounts - dimensions - analysis view - dynamics gp system: finance review: state: reviewed by: opus at: "2026-10-08T02:01:26.325Z" flags: [] generated: at: "2026-10-08T01:26:53.141Z" pipeline: 0.2.0 prompts: extract-post: 1 input_hash: 9caac5ac65d5beb5a266b4a5ebdd68099b7e52dc3f938464c057cbedcb6390a2 evidence: - kind: blog url: https://thedynamicsexplorer.com/2025/04/11/dynamics-gp-to-business-central-how-to-recreate-the-gl-summary-enquiry-using-g-l-account-balance-analysis-mode-or-an-analysis-view/ title: Dynamics GP to Business Central – How to Recreate the GL Summary Enquiry using G/L Account Balance, Analysis Mode or an Analysis View date: "2025-04-11" commit: null t: null quote: null - kind: blog url: https://thedynamicsexplorer.com/2025/04/11/dynamics-gp-to-business-central-how-to-recreate-the-gl-summary-enquiry-using-g-l-account-balance-analysis-mode-or-an-analysis-view/ title: Dynamics GP to Business Central – How to Recreate the GL Summary Enquiry using G/L Account Balance, Analysis Mode or an Analysis View date: "2025-04-11" commit: null t: null quote: In Dynamics GP the GL account code is segmented, whereas Business Central uses a single GL code and dimensions. - kind: blog url: https://thedynamicsexplorer.com/2025/04/11/dynamics-gp-to-business-central-how-to-recreate-the-gl-summary-enquiry-using-g-l-account-balance-analysis-mode-or-an-analysis-view/ title: Dynamics GP to Business Central – How to Recreate the GL Summary Enquiry using G/L Account Balance, Analysis Mode or an Analysis View date: "2025-04-11" commit: null t: null quote: The great thing about this is I can use natural language in Copilot to create the View. links: learn: [] objects: - object/page/16 - object/page/415 - object/page/20 - object/page/558 features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] post_id: "8821" source_id: thedynamicsexplorer-com source_name: The Dynamics Explorer url: https://thedynamicsexplorer.com/2025/04/11/dynamics-gp-to-business-central-how-to-recreate-the-gl-summary-enquiry-using-g-l-account-balance-analysis-mode-or-an-analysis-view/ published_at: "2025-04-11T15:00:00.000Z" author: Gavin Whittaker full_text: false words: 1039 quotes: - text: In Dynamics GP the GL account code is segmented, whereas Business Central uses a single GL code and dimensions. why_it_matters: This fundamental difference explains the structural changes users face when migrating from Dynamics GP and why GL balance viewing differs between systems. - text: The great thing about this is I can use natural language in Copilot to create the View. why_it_matters: Highlights that Copilot can generate Analysis Mode views using natural language, making it easier for users to achieve Dynamics GP-like reports without manual configuration. code_objects_mentioned: - page Chart of Accounts - page G/L Account Balance - page General Ledger Entries - page Analysis View Entries systems: - finance - reporting - copilot versions_mentioned: [] preview: embeddable: true frame_url: https://thedynamicsexplorer.com/2025/04/11/dynamics-gp-to-business-central-how-to-recreate-the-gl-summary-enquiry-using-g-l-account-balance-analysis-mode-or-an-analysis-view/embed/ image: https://i0.wp.com/thedynamicsexplorer.com/wp-content/uploads/2025/04/how-to-recreate-the-gl-summary-enquiry-using-gl-account-balance-analysis-mode-or-an-analysis-view.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:11.386Z" --- # Dynamics GP to Business Central – How to Recreate the GL Summary Enquiry using G/L Account Balance, Analysis Mode or an Analysis View [Read the post](https://thedynamicsexplorer.com/2025/04/11/dynamics-gp-to-business-central-how-to-recreate-the-gl-summary-enquiry-using-g-l-account-balance-analysis-mode-or-an-analysis-view/) · The Dynamics Explorer (Gavin Whittaker) · 2025-04-11 · 1039 words · tier community · reviewed (checked by Opus) > When migrating from Dynamics GP to Business Central, GL account structures change from segmented codes to single codes with dimensions. The post explains three methods to recreate Dynamics GP's GL Summary Enquiry view in Business Central: filtering the Chart of Accounts page, using Analysis Mode with natural language in Copilot, or creating an Analysis View. ## Key points - Dynamics GP uses segmented GL codes (e.g., 200-5170-00) while Business Central uses single GL codes with dimensions for department and division - Microsoft's migration tools consolidate segmented GL codes into single codes and create dimensions, so 50 variants of a Payroll Taxes code become one GL code - Chart of Accounts in Business Central shows only total balances at GL code level, unlike Dynamics GP's Summary Enquiry which shows balances for specific code combinations - Three methods to view GL balances like Dynamics GP: pre-filter Chart of Accounts before opening G/L Account Balance, use Analysis Mode on General Ledger Entries with Copilot natural language support, or create an Analysis View with compression by month and dimensions ## Quotes - "In Dynamics GP the GL account code is segmented, whereas Business Central uses a single GL code and dimensions." (This fundamental difference explains the structural changes users face when migrating from Dynamics GP and why GL balance viewing differs between systems.) - "The great thing about this is I can use natural language in Copilot to create the View." (Highlights that Copilot can generate Analysis Mode views using natural language, making it easier for users to achieve Dynamics GP-like reports without manual configuration.) ## 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 16 "Chart of Accounts"](../../objects/page/16.md) - [page 415 "G/L Account Balance"](../../objects/page/415.md) - [page 20 "General Ledger Entries"](../../objects/page/20.md) - [page 558 "Analysis View Entries"](../../objects/page/558.md) ## Context - Features: Analysis Mode, Analysis View, Dimensions, Copilot natural language, GL Account Balance, Chart of Accounts filtering Source: The Dynamics Explorer, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.