web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

Migrate Legacy system Trial Balances into D365 FO

(2) ShareShare
ReportReport
Posted on by 154

Hi,

I have a project to migrate all the trial balance into D365 FO. I have read many articles but still need clarity before implementation. 

Using the General journal (General ledger > Journal entries > General journals) i can post all the balance for pure GL account, can use the ledger account type and directly use the GL to migrate the balance.

And for the control account like AR, AP, inventory, fixed assets, Bank etc balance, select the respective account type like customer, vendor, bank and post the general journals. 

Is this is correct approach to migrate the legacy TB to D365 fo or there are any other ways to do it? 

  • Verified answer
    H.M.Burhan Profile Picture
    496 Super User 2026 Season 2 on at

    Hi Dolly,

    Yes, you can upload the trial balance directly into the GL using a General Journal. However, I'd suggest the following:

     

    a) Don't use an offset account. Since you're migrating the closing balances of each account, simply enter the balances (DR or CR) without an offset account and post them in a single journal voucher. As long as all balances are entered correctly, the journal should balance.

     

    b) For subledgers (customers, vendors, inventory, fixed assets, etc.), record both a debit and a credit for the same amount. This creates the required subledger transactions while having no net impact on the General Ledger. Alternatively, you can use a temporary offset account (for example, 99999) to offset the subledger balances during the migration.

    Cheers,

    Burhan

  • Dolly Chauhan Profile Picture
    154 on at

    Hi @H.M.Burhan ,

    Thanks for the response. Got it. Using the General journal is the best way to upload legacy balances with respect of Account type. 

  • Suggested answer
    H.M.Burhan Profile Picture
    496 Super User 2026 Season 2 on at

    Hi Dolly,
     

    Yes, you can use the General Journal to upload all of the opening balances for the subledgers you mentioned, except for inventory. However, I would recommend uploading vendor open invoices through the Invoice Journal and fixed assets through the Fixed Assets Journal instead.

    You'll need to use the Movement Journal (Item Journal) for inventory opening balances.
     

    Cheers,

    Burhan

  • Dolly Chauhan Profile Picture
    154 on at

    Hi H.M.Burhan  Thanks for the help, will follow the same approach as suggested above. 

  • Dolly Chauhan Profile Picture
    154 on at

    Hi @H.M.Burhan 

    • I was importing the vendor invoice using the invoice journal via DMF and its uploaded the data but single voucher number is generated even though there are multiple invoice lines and when i checked DMF entity there is no field to add the offset account this is the reason it created single voucher as journal name set up as In connection with balance for voucher number. 
    • and if i was using the excel-add ins i am getting below error however i have remove the financial dimension. 

      Please help to provide resolution for these issues so i can upload the invoice data. 

  • Verified answer
    H.M.Burhan Profile Picture
    496 Super User 2026 Season 2 on at

    Hi @Dolly Chauhan ,

    You can't upload multiple invoices from different vendors in a single voucher in the Invoice Journal.

    The following fields that you can use to specify the offset account for the data entity Vendor invoice journal line. I personally prefer to use the DMF to upload the opening balances.

    OFFSETACCOUNTDISPLAYVALUEOFFSETACCOUNTTYPE


    But your error seems to be related to the financial dimension values. Make sure you've selected the mandatory dimensions on the Vendor master and also specified them for the offset account.

    Cheers,

    Burhan

    If my previous answer and this one resolved your issue, please mark the answer as verified.

  • Dolly Chauhan Profile Picture
    154 on at

    Hi Burhan, 

    Thank you. I have successfully uploaded the invoices using the field "OFFSETACCOUNTDISPLAYVALUE "  for offset main account . 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 99 Super User 2026 Season 2

#2
Paolo Cecchelli Profile Picture

Paolo Cecchelli 79 Super User 2026 Season 2

#3
Aayush Tiwari Profile Picture

Aayush Tiwari 71

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans