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 :
Finance | Project Operations, Human Resources, ...
Answered

All Vendors - Batch Export and Import

(0) ShareShare
ReportReport
Posted on by 10

Is there a way to export the Vendor account list, then we can make selected changes to the Vendor name (add DNU_ prefix) and Vendor Hold from “No” to “All” so that they become inactive and once completed, then re-import the list back into D365?  If there are no changes to the Vendor account number, this should in theory override the original name and change the Vendor Hold for these accounts.  We have 500 Vendors to do and don't want to do it one by one.

Categories:
  • Verified answer
    Vinay R Profile Picture
    9 on at

    Yes, this is doable without updating the records one by one.

    Steps:

    1. Export via Data Management workspace → Export, using the Vendors V2 entity (Excel/CSV).
    2. Edit offline — update only Name (add the DNU_ prefix) and Vendor hold (set to All). Keep the Vendor account number unchanged and configure the import to use the appropriate matching/key field so the existing records are updated rather than creating duplicates.
    3. Re-import using the same Vendors V2 entity and your edited file.
    4. Test with 5–10 records first before processing all 500, to confirm the updates behave as expected.

    If you need to perform this type of bulk update regularly, a Power Automate flow or D365 Finance & Operations integration/API approach could replace the export/edit/re-import process.

    One thing to check beforehand: if your environment has approval workflows or custom validations on vendor changes, the import may trigger them for each record. It’s worth confirming this before running the full batch.

  • Martin Dráb Profile Picture
    241,656 Most Valuable Professional on at

    You've asked in the general forum, but your question clearly is about a specific D365 product. Which one it is? Finance and Operations?

  • Verified answer
    FaiqaK Profile Picture
    28 on at

    @LS-06100224-0  , yes it's possible using Vendors V2 data entity. You can export through data management , make the changes and import again. 

     

  • Martin Dráb Profile Picture
    241,656 Most Valuable Professional on at

    Moved from Integration, Dataverse, and general topics forum to Finance | Project Operations, Human Resources, AX, GP, SL forum.

     

    In general, you can use entities this way to modify some fields. I'd have to check those particular fields. Name may be a bit trickier, because it actually comes from a different table, but it'll likely be handled under the hood.

     

    I recommend that you actually try it and see if it works for you. And if not, you'll ask about the particular problem here.

  • LS-06100224-0 Profile Picture
    10 on at

    Thank you for your responses.  Much appreciated.  

  • Anton Venter Profile Picture
    21,378 Super User 2026 Season 2 on at

    @Vinay R 

    Is your reply created using AI? It seems to be the case. Can you confirm?

    If or when using AI to answer posts, please remember to enable the "Mark reply as AI-assisted" checkbox before posting so that the source is clear to everyone.

     

    Responsible AI policies for the Community

    https://community.dynamics.com/blogs/post/?postid=56f26128-0b77-f011-b4cb-7c1e52193d79

     

  • LS-06100224-0 Profile Picture
    10 on at

    @Vinay R - This instruction is not working.  Under Export, there isn't any Entity Name called Vendors V2 in the dropdown box.  There also aren't any options that look to be relevant, as the Dropdown box lists Vendor Invoice options, Vendor Payments and other types of Vendor Transactions, but not the Vendor List itself.
    Your instruction was:  Export via Data Management workspace → Export, using the Vendors V2 entity (Excel/CSV).
    The only location that has the Vendors V2 as an option is when you are on the All Vendors screen and the Microsoft Office button on the top right has the option to download the Vendors List, which I can do but it won't allow me to Publish the changes that I made to two vendor accounts using Microsoft Dynamics link.

    @Anton Venter  - any ideas?
    Thanks, Leanne

  • Anton Venter Profile Picture
    21,378 Super User 2026 Season 2 on at

    @LS-06100224-0 

    Leanne,

    In addition to the comments of the other community members, the export and import using the Excel add-in, from the Vendors form, should work if you have the Export vendors and Import vendors security privileges. Or if you have the Administrator role. Under the menu Open in Excel you should see Vendors V2. I have not tested all the steps below properly but it should work and you should test it as Martin mentioned.

     

    Blocked and Name fields are available and the Publish button is enabled.

     

    The DMF export and import option using Vendors V2 should also work fine as well.

     

     

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

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

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

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 221

#3
Subra Profile Picture

Subra 166 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans