Data Migration-Transactional data

(0) Share

Report

Posted on by Community Member

How to i migrate transactional finance data like GL Balances , vendor balances etc into d 365.

Thanks,

I have the same question (0)

All responses (5)

Answers (1)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

You can use data management for importing opening balances .There are lot of Out of the box entities present which can be used to import data . Refer below post where some entities are suggested to import data.

community.dynamics.com/.../importing-opening-balances-in-dynamics-365-using-data-management-tool

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sukrut,

Thanks for the reply. wanted to know if there is any particular steps that needs to be followed during this process... like first create a dummy account and then do balancing etc...i am new to this data migration thing... any help is appreciated.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi pothapu,

What do you mean with a dummy account here? Do you mean an account to use as offset for the opening balances?

Usually, I did first import all open transactions from vendors, customers, etc and used an "conversion balance" account as offset. On the opening balance with GL details, instead of using the customer, vendor accounts and other subledger accounts, the conversion balance was used. This balance account should then be zero is everything was posted correctly.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello pothapu,

It seems that you are looking for a detailed step by step guide to migrate your data.

Providing such a detailed guide is not straightforward because it depends on a lot of things; among others your country/region (because of taxes/tax migration), the modules / functionalities that you use (for transferring customer/vendor/project...) data, etc.

Can you possibly provide more information and what do you expect here exactly?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi Pothapu,

Here is blog which explains to move opening balance with template, you can use same for transactions:

exploredynamics365.home.blog/.../

Was this reply helpful? Yes No