How to create new vendors in bulk?

(5) Share

Report

Posted on by FB-30032328-0

Hello,

I have to create over 100 new vendors and just wonder if we can do that in bulk.

On the Vendors page - i can go Edit in Excel and add the vendor details such as vendor no., phone number, etc. and then publish. However, I cant see where i can add the payment method, BSB and account number.

Does anyone know where i can add the vendor's bank details in bulk on an excel sheet too? Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Valentin Castravet 28,361 Super User 2025 Season 2 on at

Like (2)

Report

How to create new vendors in bulk?

Hope this helps as well - How to Import Data Using Configuration Packages in Dynamics 365 Business Central - Dynamics 365 Business Central Insights

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 90,019 Super User 2025 Season 2 on at

Like (0)

Report

How to create new vendors in bulk?

Configuration Package is the most commonly used approach.

More details: Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 18,966 Super User 2025 Season 2 on at

Like (1)

Report

How to create new vendors in bulk?

Adding mor details: You can bulk-create vendors using Edit in Excel on the Vendors page, but bank details are in the Vendor Bank Account (Table 288). So, you need to add vendor bank account details first or import both together. You can do this using the Configuration Package.

Please check this. https://help.xe.com/hc/en-gb/articles/17504022439697-How-to-bulk-upload-vendor-information-to-the-Vendor-card-in-Business-Central

Was this reply helpful? Yes No
Verified answer

Mansi Soni 8,427 Super User 2025 Season 2 on at

Like (4)

Report

How to create new vendors in bulk?

Hello, In Business Central, you can bulk create vendors using the Edit in Excel feature from the Vendors list page. However, vendor bank details such as BSB and account numbers are stored in the Vendor Bank Account table, not directly on the Vendor card. So for that you can use Configuration Packages to import both Vendor and Vendor Bank Account data while ensuring correct table mappings.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 12,116 Super User 2025 Season 2 on at

Like (2)

Report

How to create new vendors in bulk?

Hello,

You can use the Configuration package to Bulk upload the Vendors and Vendor Bank Account Data because in Edit in Excel you can add the details of Vendor Table only and not for related tables.

Was this reply helpful? Yes No