Dynamics GP to Business Central – How to Recreate the GL Summary Enquiry using G/L Account Balance, Analysis Mode or 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”
• page 415 “G/L Account Balance”
• page 20 “General Ledger Entries”
• page 558 “Analysis View Entries”

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.