Finance | Project Operations, Human Resources, ...

Open Bank transactions migrate from GP to D365F&O

(3) Share

Report

Posted on by JP..

106

Hi Team,

Kindly suggest standard process to import/migrate open bank transactions from GP system. to D365F&O.

transactions including Bank outstanding checks, showing Check Number, Check Date, Vendor ID, Vendor name, Vendor Address, Check amount to migrate for testing.

Thank you in advance!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ramit Paul 22,809 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi JP,

There is no standard option to migrate Bank outstanding checks, showing Check Number, Check Date, however question to you, why do you need these data into new ERP?

Vendor ID, Vendor name, Vendor Address, are you asking about the Vendor master or these also part of check data?

Please share your requirement why do you need these and for what purpose?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 15,200 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,
In addition to Ramit's feedback, once you’ve created the migration file from GP, you can use the Data Management Framework (DMF) in D365FO to import the data.
Specifically, you can use the General journal data entity to import transactions directly into D365FO for each legal entity. This method is commonly used during the migration phase to import:

-Customer and vendor open transactions
-Opening balances

It's a flexible and reliable approach, especially when migrating historical or opening data from legacy systems like GP.

1 people found this reply helpful.

Was this reply helpful? Yes No
JP.. 106 on at

Like (0)

Report
Copy link

Link copied!

Hi Ramit Paul & Alireza Eshaghzadeh,

Thank you for the response.

We have requirement from business, where unreconciled or open bank transactions in GP system should be migrate to D365 which includes Bank outstanding checks, showing Check Number, Check Date, Vendor ID, Vendor name, Vendor Address, Check amount.

we have migrated Vendor & customer master, AP,AR Open transactions and Trail balance using Data management.

now business is looking for open bank transaction migration from GP.

Thank you

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

You import the open bank transactions as General journal vouchers using DMF, with Bank account as the account and the respective bank main account as the offset account so there is no general ledger impact when posted. You'll have to pick available fields to record the details you wish to capture. Financials tags fields could be used here.

Was this reply helpful? Yes No