Import trail balance data from GP to D365 F&O

(3) Share

Report

Posted on by CU21052024-0

273

Hi All,

Could someone assist me with the form to import trail balance data into D365F&O via data management as a part of data migration. Specifically I would like to confirm whether the standard approach is to import general journals and post them?

Thank you!

I have the same question (0)

All responses (3)

Answers (3)

Sort by

Verified answer

André Arnaud de Cal... 305,173 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi,

Thanks for using the forum and your question. Yes, the approach is to import or create a general journal. There are some additional considerations.

Subledger information, like open customer and vendor transactions or fixed asset balances should be imported in detail. Usually, I suggest to have a different journal per subledger type and use a suspension ledger account to park the offset of these balances. For fixed assets, you can use multiple journals to post acquisition values and deprecated amounts.

When importing the ledger journal for the opening balance, instead of the centralization accounts for the subledgers, you can reverse the amounts on the suspension account. It is recommended to post the opening balance on the last date of a previous fiscal year before the live date. E.g. if you plan to go live on January 1 and the fiscal year starts at the same date, you can post the opening balance on December 31, {year-1}. You can then use the end-of-year job to create the opening balance in the opening period of the fiscal year.

Was this reply helpful? Yes No
Verified answer

Ramesh Kumar 7,555 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
I would suggest use a Suspense/Offset Account : If you’re migrating opening balances across multiple dimensions or entities, you can:

Create an offset line using a suspense account.

After full migration, reverse or reclass the suspense amount once balancing entries are finalized.

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,869 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I recommend proceeding with the approach suggested by Andre, using the following entities:

- General journal (LedgerJournalEntity): For migrating ledger balances and open customer/vendor transactions.

- Fixed asset journal (AssetJournalEntity): For importing fixed asset acquisitions and depreciation.

This method ensures alignment with standard processes and minimizes post-import issues.

Was this reply helpful? Yes No