Small and medium business | Business Central, N...

Mass Update Vendor Numbers

(1) Share

Report

Posted on by IU_Hoosier

187

Is it possible to update the Vendor Numbers en mass without creating new vendors? Using a Configuration Package or Edit In Excel do not work because it creates a new vendor instead of updating the existing vendor. I know I can manually go to a vendor card and update the existing vendor number. Is there a way to do that en mass instead of 1 at a time?

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

There is not without have a developer write a custom routine.

Was this reply helpful? Yes No
Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

Custom routine is the old skool way. New skool says use Power Automate. Save an excel file with the current numbers and the new numbers in an excel table. You will need the first column to be the Id value. You can get this via power automate with the find entries action. I mocked up a demo version working on 1 record only.

mid you replace the find entries (eventually) with an excel file saved in O365 then you can loop through those (that’s the apply to each bit) and pass the update action the Id value as the identifier. Put in the “number” field your new value

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

as Kim mentioned please consult with your development partner for doing this activity

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,913 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

As mentioned by several experts above, this requires development.
And I don't recommend it very much, because you want to update the primary key of the vendor, please note that the associated table should also be updated.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 970 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I wont recommend this change , as the vendor No is the primary key and used at all places in the system.

If you still want to do it , do it in presence of expert developer who knows the system.

Was this reply helpful? Yes No