Study guide

1.3 Opening Balances & Data Migration Strategies

Microsoft Dynamics 365 Business Central Functional Consultant MB-800

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Company Creation & Data Migration

1.1 Creating Companies & Assisted Setup Wizards 1.2 Configuration Packages & RapidStart Worksheets 1.3 Opening Balances & Data Migration Strategies

2 Chapter 2: Security, Profiles & Auditing

2.1 Users, User Setup & Role Center Profiles 2.2 Permission Sets & Security Group Management 2.3 Security Filters, Change Log & Security Auditing

3 Chapter 3: Core System Configuration, Number Series & Copilot

3.1 Company Information, Number Series & Job Queues 3.2 Report Layout Management & Copilot AI Capabilities

4 Chapter 4: Dimensions Architecture & Governance

4.1 Dimension Concepts & Dimension Values 4.2 Global Dimensions vs Shortcut Dimensions 4.3 Default Dimensions, Combinations & Priorities

5 Chapter 5: Workflows & Approvals

5.1 Native Workflow Templates & Approval Hierarchy 5.2 Workflow User Groups & Notification Configuration

6 Chapter 6: Financial Setup, Periods & Currencies

6.1 General Ledger Setup & Accounting Periods 6.2 Payment Terms, Payment Methods & Deferrals 6.3 Multi-Currency Setup & Exchange Rates

7 Chapter 7: Chart of Accounts, Categories & Allocations

7.1 Chart of Accounts Structure & G/L Account Cards 7.2 Account Categories, Subcategories & Financial Reporting 7.3 General Ledger Allocation Accounts & Sharing

8 Chapter 8: Posting Groups & Posting Setup

8.1 Specific Posting Groups: Customer, Vendor, Bank & Inventory 8.2 General Posting Groups & General Posting Setup Matrix 8.3 Inventory Posting Setup & Alternative Posting Groups

9 Chapter 9: General Journals & Recurring Methods

9.1 Bank Account Cards & Posting Setup 9.2 General Journal Templates, Batches & Number Series 9.3 Recurring General Journals & Allocation Methods

10 Chapter 10: Accounts Payable & Accounts Receivable Setup

10.1 Purchases & Payables Setup & Vendor Master 10.2 Sales & Receivables Setup & Customer Master 10.3 Payment Journals, Cash Receipts & Payment Registration Setup

11 Chapter 11: Fixed Assets Setup & Depreciation Books

11.1 Fixed Asset Setup, Classes & Depreciation Books 11.2 Fixed Asset Cards, Main/Component Assets & Depreciation Methods

12 Chapter 12: Inventory Setup, Costing & Locations

12.1 Inventory Setup, Item Types, Categories & Variants 12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture 12.3 Locations, Transfer Routes & Stockkeeping Units (SKUs)

13 Chapter 13: Logistics Master Data, Pricing & Discounts

13.1 Shipping Agents, Locations & Vendor Lead Times 13.2 Sales Prices, Purchase Prices & Price Lists 13.3 Line Discounts, Invoice Discounts & Thresholds

14 Chapter 14: User Interface, Views, Inspection & Excel

14.1 Personalization, Profile Customization & Designer 14.2 Searching, Advanced Filters, Saved Views & Page Inspection 14.3 Edit in Excel, OneDrive & Data Analysis Mode

15 Chapter 15: Purchase & Sales Order Execution

15.1 Purchase Orders, Receiving, Over-Receipt & Undo 15.2 Purchase Invoicing, Recurring Lines & Blanket Orders 15.3 Sales Quotes, Availability Checks & Order Conversion 15.4 Sales Shipping, Invoicing, Undo & Blanket Orders

16 Chapter 16: Invoices, Credit Memos & Document Corrections

16.1 Direct Invoices, Credit Memos & Document Reopening 16.2 Correct, Cancel & Corrective Credit Memo Procedures 16.3 Combined Shipments/Receipts & Prepayment Workflows

17 Chapter 17: Cash Management, Bank Reconciliation & Ledger Applications

17.1 Processing Payment Journals & Cash Receipt Registrations 17.2 Applying, Unapplying & Reversing Customer/Vendor Entries 17.3 Bank Account Reconciliation & Statement Matching Rules

18 Chapter 18: Operational Adjustments, Inventory & Asset Accounting

18.1 Exchange Rate Adjustments & Dimension Corrections 18.2 Inventory Adjustments, Transfers & Physical Counting 18.3 Fixed Asset Acquisitions, Depreciation Runs & Disposals

1.3 Opening Balances & Data Migration Strategies

Key Takeaways Explain This Topic AI

General Ledger opening balances are posted via General Journals against a dedicated Migration Clearing / Suspense account (e.g., 99999) to establish trial balance equity.

Customer and Vendor opening balances must be migrated as detailed open invoices to preserve historical aging, document numbers, and future cash receipt/payment application.

Subledger journal entries automatically post to G/L control accounts (AR/AP) via posting groups and must be balanced against the Migration Clearing account to offset the initial trial balance and eliminate double-counting.

Inventory opening balances are posted via the Item Journal as Positive Adjustments, requiring accurate unit costs, location codes, and mandatory Item Tracking Lines for serialized or lot-tracked stock.

Formal go-live sign-off requires four-way reconciliation matching the G/L Trial Balance, Aged AR, Aged AP, and Inventory Valuation reports against legacy cutoff figures.

Last updated: September 2026

1.3 Opening Balances & Data Migration Strategies

Quick Summary: Migrating opening balances establishes financial and operational balances in Dynamics 365 Business Central as of the cutover date. The process requires migrating the General Ledger trial balance using a Migration Clearing / Suspense Account (e.g., 99999), posting detailed open Customer and Vendor invoices against that same clearing account to synchronize subledgers with G/L control accounts without double-counting, and posting inventory balances as Positive Adjustments via the Item Journal with complete costing and Item Tracking (serial/lot) assignments. Formal sign-off requires four-way reconciliation across G/L, AR, AP, and Inventory.

Cutover Strategy & Migration Principles

Opening balance migration represents the final, critical milestone of an ERP implementation. Establishing clean opening balances requires defining a strict Cutoff Date (typically the final day of a fiscal period or fiscal year), executing a legacy transactional freeze, and loading balances via operational journals rather than raw table injection.

Consultants must choose between two overarching financial cutover strategies:

Historical Net Movements: Migrating monthly net debit/credit changes for all general ledger accounts across prior years (e.g., 12 to 24 months). While this provides historical comparative financial reporting in Business Central, it requires extensive reconciliation effort.

Ending Balance Cutover (Standard Best Practice): Migrating single cumulative ending balances for all balance sheet accounts as of the cutoff date, while prior-year profit and loss balances are condensed into Retained Earnings. Historical reporting is maintained in the legacy data warehouse or BI archive.

General Ledger Opening Balances & The Migration Clearing Account

When migrating the General Ledger trial balance, direct manual postings to subledger control accounts (such as Accounts Receivable, Accounts Payable, and Inventory Asset accounts) are restricted because their Direct Posting property is set to No . Attempting to manually post general journal lines to control accounts causes system errors.

To overcome this constraint while maintaining strict ledger integrity, consultants utilize a Data Migration Clearing / Suspense Account (commonly numbered 99999 Opening Balance Clearing or Opening Balance Suspense ): General Ledger Trial Balance Ingestion Pattern:

Account Type | Account No. | Description | Debit | Credit | Bal. Account No.

  • ------------+-------------+-----------------------+----------+----------+-----------------
  • G/L Account | 10100 | Operating Checking | $150,000 | | 99999 (Clearing)
  • G/L Account | 10400 | Accounts Receivable | $220,000 | | 99999 (Clearing)
  • G/L Account | 10700 | Finished Goods Inv. | $310,000 | | 99999 (Clearing)
  • G/L Account | 20100 | Accounts Payable | | $180,000 | 99999 (Clearing)
  • G/L Account | 30100 | Common Stock | | $100,000 | 99999 (Clearing)
  • G/L Account | 30200 | Retained Earnings | | $400,000 | 99999 (Clearing)
  • The Balancing Mechanics

Each G/L account is entered on an individual line in a General Journal batch ( Alt+Q -> type General Journals ).

Every line specifies the Bal. Account No. as 99999 .

Because total legacy debits equal total legacy credits in a balanced trial balance, the net sum of all offsetting entries posted to Account 99999 is $0.00 .

Dimension Tagging: Lines must include mandatory Global Dimensions (e.g., Department, Project) and Shortcut Dimensions to ensure that Day 1 financial reporting accurately reflects historical divisional allocations.

Note

If Accounts Receivable (10400), Accounts Payable (20100), and Inventory (10700) have Direct Posting disabled on their G/L Account Cards, consultants temporarily enable Direct Posting strictly for the trial balance migration, or bypass posting to the control accounts during initial G/L migration and let the subledger journals establish the control account balances.

Customer & Vendor Opening Balances: Subledger Integrity

For Accounts Receivable and Accounts Payable, migrating a single net lump-sum balance per customer or vendor is a catastrophic operational pitfall. Lump-sum balances erase historical invoice numbers, obscure original document dates, distort aging buckets (Current, 30, 60, 90+ days), and make it impossible to apply incoming cash receipts or outgoing vendor payments against specific open invoices.

The Detailed Open Invoice Method (Recommended Best Practice)

Every unpaid customer invoice, open credit memo, unapplied cash receipt, and open vendor bill is entered as a distinct line in a General Journal batch: Detailed Open Invoice Journal Configuration:

  • Account Type : Customer (or Vendor)
  • Account No. : CUST-00120 (Master Customer Number)
  • Posting Date : 2026-08-15 (Original Legacy Invoice Date for accurate aging)
  • Document Type: Invoice
  • Document No. : INV-90421 (Original Legacy Invoice Number)
  • Amount : $4,500.00 (Remaining Unpaid Open Balance)
  • Due Date : 2026-09-15 (Original Due Date based on Payment Terms)
  • Bal. Account : G/L Account -> 99999 (Migration Clearing Account)
  • The Subledger-to-G/L Offset Mechanism (Eliminating Double-Counting)

Understanding how Business Central processes subledger journal lines is crucial for passing the MB-800 exam:

Subledger Posting: Business Central generates an open Customer Ledger Entry (or Vendor Ledger Entry) for Customer CUST-00120 with a Remaining Amount of $4,500.00 . When a payment arrives post-go-live, it can be applied directly against INV-90421 .

Automated G/L Control Posting: Because the line uses Account Type = Customer , Business Central automatically looks up the customer's Customer Posting Group (e.g., DOMESTIC ), identifies the mapped Receivables Account (e.g., 10400 Accounts Receivable ), and posts a Debit of $4,500.00 to Account 10400 in the General Ledger.

Clearing Account Offset: The offsetting side of the journal line posts a Credit of $4,500.00 to the balancing account: 99999 Migration Clearing . Clearing Account Offset Flow:

  • Step 1: Trial Balance G/L Migration
  • DEBIT: 10400 Accounts Receivable $220,000
  • CREDIT: 99999 Migration Clearing $220,000
  • Step 2: Detailed Customer Subledger Migration (Sum of all open invoices = $220,000)
  • DEBIT: 10400 Accounts Receivable $220,000 (via Customer Posting Group)
  • CREDIT: 99999 Migration Clearing $220,000 (via Bal. Account)

Result:

To prevent double-counting 10400, the initial Trial Balance entry either:

Option A: Omits 10400 from Step 1, letting Step 2 establish the $220,000 balance against 99999.

Option B: Includes 10400 in Step 1, and Step 2 balances against 10400 directly (or clearing account is adjusted).

Under Option A (Industry Standard) , the initial Trial Balance journal posts all balance sheet accounts except Accounts Receivable and Accounts Payable directly to 99999. Then, the detailed Customer and Vendor subledger journals are posted against 99999. The subledger postings automatically populate Accounts Receivable and Accounts Payable while driving Account 99999 to an exact zero balance.

Inventory Opening Balances via the Item Journal

Inventory balances cannot be migrated via the General Journal. Physical quantities and item valuations must be registered in the Item Ledger Entries and Value Entries to establish inventory availability, location bins, and cost layers. UI Navigation Path:

  • Tell Me (Alt+Q) -> Item Journals -> Batch Selection -> Action Bar: Functions / Prepare
  • Item Journal Line Configuration

In an Item Journal batch, lines are populated with:

Entry Type: Positive Adjustment .

Posting Date: Cutover date (e.g., 2026-08-31 ).

Document No.: Migration document series (e.g., INV-OPEN-001 ).

Item No.: Valid master item code from Table 27.

Location Code: Warehouse or plant location where stock is physically staged.

Bin Code: Specific bin identifier (mandatory if Bin Mandatory is activated on the Location card).

Quantity: Verified physical count as of the cutoff date.

Unit Amount / Unit Cost: The inventory valuation per unit as determined by the item's costing method.

Costing Method Considerations

Standard Costing: The Unit Cost in the journal must match the fixed Standard Cost configured on the Item Card. Any discrepancy will generate an immediate inventory variance entry.

FIFO / Average / Specific: The Unit Amount entered establishes the initial inbound cost tier in the Value Entry table. This unit cost forms the baseline for subsequent outbound cost applications (sales and consumption).

Serial & Lot Number Item Tracking

If an item is governed by an Item Tracking Code requiring inbound serial or lot tracking, the Item Journal cannot be posted until tracking details are explicitly allocated:

Select the Item Journal line.

In the action bar, choose Line -> Item Tracking Lines ( Ctrl+Shift+I ).

In the Item Tracking Lines window, assign the discrete Serial No. or Lot No. , quantity, and optional Expiration Date for each unit.

The sum of quantities in the Item Tracking Lines window must exactly match the Quantity on the Item Journal line before the system permits posting.

Inventory Cost Posting to the General Ledger

Posting an Item Journal creates Item Ledger Entries and Value Entries. If the Automatic Cost Posting toggle in Inventory Setup is set to Yes , Business Central immediately creates corresponding G/L entries, debiting the Inventory Asset account (via Inventory Posting Setup) and crediting the Inventory Adjustment account. If Automatic Cost Posting is disabled, the consultant must manually run the Post Inventory Cost to G/L batch job ( Alt+Q -> type Post Inventory Cost to G/L ).

Data Migration Reconciliation & Go-Live Sign-Off

Before executing the final production cutover and opening the environment to general users, consultants must perform a disciplined four-way reconciliation audit:

Audit Stream Primary Business Central Report Verification Checkpoint Sign-Off Criteria

General Ledger Trial Balance or Detailed Trial Balance General Ledger Account Balances Total debits equal total credits; account balances match legacy trial balance; Migration Clearing Account (99999) has an ending balance of exactly $0.00 .

Accounts Receivable Aged Accounts Receivable Customer Subledger vs G/L Control Account Total open AR balance matches the G/L Accounts Receivable control account; aging bucket distribution matches legacy AR aging report.

Accounts Payable Aged Accounts Payable Vendor Subledger vs G/L Control Account Total open AP balance matches the G/L Accounts Payable control account; vendor balances tie out to legacy AP vendor balances.

Inventory Valuation Inventory Valuation Item Subledger vs G/L Inventory Asset Account Total inventory valuation matches the G/L Inventory Asset account; on-hand quantities match physical inventory count sheets.

Post-Migration Locking

Once all four reports reconcile to the penny and business stakeholders sign the formal cutover acceptance document, administrators lock the migration period. Navigating to General Ledger Setup and User Setup , administrators configure the Allow Posting From and Allow Posting To dates. This locks the migration cutoff date, preventing any subsequent user from inadvertently posting retroactive transactions into the opening balance period.

Loading diagram... Migration Clearing (Suspense) Account Zero-Balance Flow