Comparing Financial Reporting Tools Between Dynamics GP and Dynamics Business Central (2024)
Account schedules in Business Central as the replacement for GP financial reporting. Covers the eight built-in schedules, account categories carried over by the GP cloud migration tool, row formulas, column layouts, dimension filtering, drill-down, and Excel export and cross-company import.
- Financial reporting in GP and introduction to Business Central
- Account schedules overview and built-in templates
- Account categories and migration from GP
- Creating and updating account categories
- Account schedule structure, formulas and column layouts
- Filtering by dimensions and drilling down into details
- Exporting and importing account schedules
Overview
A 5-minute demo from August 2024 for GP users moving to Business Central. It shows how financial statements are built with account schedules, which use account subcategories from general ledger accounts. Business Central includes eight account schedules out of the box.
The demo covers how accounts and their categories come across with the cloud migration tool, and how to create categories for accounts that were not assigned one. It then goes through row numbering and formulas, column layouts and date ranges, filtering by dimension (a sales department example), drilling down into amounts, and exporting schedules to Excel or to other companies.
Key points
- Business Central ships with eight account schedules out of the box.
- Account schedules build financial statements from account subcategories assigned to general ledger accounts.
- Accounts without an assigned category are not included on account schedules; the chart of accounts shows which ones are unassigned.
- With the cloud migration tool from GP, accounts and their assigned categories are moved to Business Central.
- After creating or changing account categories, update the account schedules so new accounts appear.
- Each row is numbered so formulas can sum multiple accounts or divide values; bold, italics and page breaks are available.
- Schedules can be filtered by dimension, drilled down into amounts, exported to Excel, and exported and imported between companies.
Features
Every feature below: status not stated, demoed.
| Feature | At |
|---|---|
| Account Schedules | 0:38 |
| Account Categories and Subcategories | 1:04 |
| Account Schedule Row Definitions and Formulas | 2:38 |
| Account Schedule Column Layouts | 2:58 |
| Dimension Filtering for Account Schedules | 3:32 |
| Drill Down into Account Schedule Details | 3:43 |
| Account Schedule Export to Excel | 3:58 |
| Account Schedule Import and Export Across Companies | 4:13 |
Quotes
- 0:38 “business Central comes with eight different account schedules out of the box”
- 1:04 “if you use the cloud migration tool to migrate your data from GP to business Central then your accounts and the categories assigned will”
- 1:31 “I can also see any accounts in my chart of accounts that are not currently assigned a category and therefore will not be included”
- 2:38 “each row is numbered so that you can create formulas allowing you to sum up mult multiple accounts or multiple divide values”
- 3:32 “you can also filter account schedules by dimensions in this example let’s say we want to filter on our sales department”
- 3:58 “each accounts schedule can also be exported to excel in addition if you create account schedules and want to use it in other companies”