Comparing Trial Balance and Aging Reports Between Dynamics GP and Dynamics Business Central (2024)

Overview

The video starts with a detail trial balance and a historical aged trial balance for receivables in Dynamics GP. It then shows how to get the same information in Business Central.

In Business Central it covers the detailed trial balance, the summary trial balance with prior year or budget comparison, export to Excel, and the aging report for customers. Filtering options are shown for each report.

Key points

• Search ‘trial balance’ in Business Central to find both the Trial Balance report (similar to the GP summary trial balance) and the Detailed Trial Balance report.
• The Detailed Trial Balance report shows balances and the transactions posted to each account. It has an option to print a new page per GL account and can be filtered to one account or a range.
• The Trial Balance (summary) report compares current year balances to last year or to budgeted amounts, and can show the variance as a percentage.
• Budget comparison in the trial balance needs budgets to be configured in Business Central.
• The summary report supports rounding (e.g. to the nearest dollar) and filters by account range and date range.
• Reports can be previewed or sent to PDF, Word, or Excel; Excel allows further analysis and different visuals.
• Searching ‘aged accounts’ lists both AP and AR aging reports. The AR aging report can age by transaction date or due date, uses a selectable aging date, and can print in detail.

Features

Every feature below: status not stated, demoed.

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

• report “Trial Balance” at 0:45
• report “Detailed Trial Balance” at 0:45
• report “Summary Trial Balance” at 1:43
• report “Aging Report” at 3:07

Not found in BC28-30: report “Detailed Trial Balance”, report “Summary Trial Balance”, report “Aging Report”.

More than one object has this name, so none is linked: report “Trial Balance”.

Quotes

• 0:01 “I’ve printed out the detail trial balance for a specific period of time and included all accounts I can easily see balance information as”
• 0:27 “I’ve also printed out the historical age trial balance in receivables allowing me to easily see aging information for each of my customers”
• 1:05 “In the detail trial balance report options window I’ve indicated that I’d like a new page per GL account also in the filter area”
• 1:53 “I have the ability to compare values from from last year or if I configured budgets in business Central I could compare to the”
• 2:28 “you can see on the summary trial balance how it Compares this year’s balance to last year as well as displaying the variance as”
• 3:15 “I can select a date that I want to age the report as of and if I want to age by transaction date or”