How To Import Vendor Bank Accounts?

(0) Share

Report

Posted on by Momochi

1,038

Greetings dears!

I have many vendors with no bank accounts, and I would like to add bank accounts to these vendors.

I have no experiance in Data Management Module and I hope you can guide me in doing it.

Please correct me if i'm wrong.

I should export the following entities:

- Vendors V2.

- Vendor Bank Account.

Exporting only Vendor bank account will only export the vendors who have bank accounts.

So in order to add the missing the vendors, I have to export "Vendors V2" is that correct?

And then I have to identify the vendors ids in Vendors V2 that have no bank accounts in "Vendor Bank Account" entity and then add these vendors ids in the "vendor bank account" excel export and then add the account number and the other bank info?

And lastly import the updated "Vendor bank account" excel file that contains all the vendors now into d365?

Is this the correct approach or there is a better way?

Any advice is appreciated !

Thanks in advance !

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Prem Kumar Bachu 3,418 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Bank account field in vendor master(payment fast tab) shows the default bank account assigned to the vendor. There might be chances, there is a bank account for vendor but you have not mapped in vendor master as default in this case you only need to map that bank account.

I suggest below steps:-

1) Export vendor bank account entity, identify missing vendor bank accounts, add the data and import.

2) Export vendor v2 entity, identify the vendors whom default bank account is not mentioned. Then update the details through data management.

Was this reply helpful? Yes No
Momochi 1,038 on at

Like (0)

Report
Copy link

Link copied!

Hi Prem,

There are no bank accounts for the vendors, they were creating vendors without entering the banks.

So I have to populate the "Vendor ban account" excel export then import it is that correct?

Was this reply helpful? Yes No
Verified answer

Prem Kumar Bachu 3,418 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Below are 2 steps. Import the vendor bank accounts first and then define default bank account for vendor masters

1) Create vendor bank accounts- note vendor can have multiple bank accounts. Related entity for this is "Vendor bank accounts"

2) Define default bank account for vendor. Related entity is Vendor V2

Was this reply helpful? Yes No
Momochi 1,038 on at

Like (0)

Report
Copy link

Link copied!

in the import file, should I include the vendors that have already a bank account that were exported? or should I only include the vendors with missing bank accounts?

Was this reply helpful? Yes No
Verified answer

Prem Kumar Bachu 3,418 on at

Like (0)

Report
Copy link

Link copied!

Include only vendors with missing bank accounts.

Was this reply helpful? Yes No
Momochi 1,038 on at

Like (0)

Report
Copy link

Link copied!

Hi Preb, Thanks for your help.

But one more question if I may.

For the "VendorBankAccountId" field.

Which should be unique for each line.

How should I populate this?

Is bank short name with a serial number is enough?

Or there is a rule for this field?

Was this reply helpful? Yes No
Suggested answer

Prem Kumar Bachu 3,418 on at

Like (0)

Report
Copy link

Link copied!

Yes it is an unique identifier, you can use bank short name with number(maximum 10 characters). There is no rule for this field, you can enter as per business convenience.

Was this reply helpful? Yes No