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.