Dynamics 365 Opening balances at data migration there is good news for Functional consultant-D365

 Are you a Microsoft Dynamics 365 consultant importing opening balances using "9999" accounts? I understand you may have worked with other ERP or Accounting systems where you have had no choice but to use "9999" accounts. Or, another D365 consultant told you this was the only way to establish opening balances in D365. It really doesn't matter how you got here, just know there is a better way!

When importing opening balances, instead of using these fake numbers as offset, use the associated Control Account for that entity.

For example, importing open invoices to establish AR balances in D365, the entry would look like this:

Account Type = Customer

Account = [Customer's Account number]

Debit = Invoice Amount

Offset Account Type = Ledger

Offset Account = [ AR Control Account defined in your posting profile]

The resulting entry to General Ledger:

DEBIT: AR Control Account   = Invoice Amount

CREDIT: AR Control Account   = Invoice Amount

Yes! The net change to GL is zero, nil, nothing!

The GL upload posts the AR amount.

I've been spreading this good news for decades now, however in recent times I've seen the practice of using "9999" creeping in again. So, let’s spread the good news and stamp out "9999" in Dynamics D365.