Share
Report
320Hi Community,
We are migrating opening balances from AccountEdge to Dynamics 365 Business Central and have posted all adjusted amounts and opening balances in our test company.
At this point, all ending balances match AccountEdge, except for:
- G/L Account 999999 (Opening Balance Suspense)
- Business Central shows: –18,882.45
- Expected: 0.0
Background / Root Cause (as we understand it)
In AccountEdge, most ending balances are shown in CAD, but some accounts are maintained and shown in USD (10 accounts). For each USD account, there is also a corresponding CAD exchange account.
Example:
- USD account (1‑1113) ending balance: 336,664.35 USD
- Exchange account (1‑1114) ending balance: 124,565.81 CAD
- AccountEdge presentation logic:
- Converted CAD total = 336,664.35 × 1.37 = 461,230.16 CAD
- This converted amount is what we expect Business Central to show for the USD account in CAD reporting
However, in Business Central, the Trial Balance appears to calculate the local currency (CAD) for the USD account by effectively combining:
- USD account (converted) + exchange account (CAD)
This seems to duplicate exchange impacts, which then creates the residual difference that lands in 999999 Opening Balance Suspense.
What we need to achieve
We are looking for a standard / supported approach (no customization preferred) to achieve the following reporting behavior:
- Display the 10 USD accounts strictly in USD (not converted to CAD and not combined with exchange accounts)
- Keep the exchange accounts strictly in CAD
- Keep all other accounts in CAD as usual
Any guidance on the best practice configuration/reporting approach would be greatly appreciated.
Thanks in advance!
All responses (
Answers (
