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)

Suggested answer

divyeshchitte 950 on at

Like (0)

Report

RE: Mass Update Vendor Numbers

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
Suggested answer

YUN ZHU 89,835 Super User 2025 Season 2 on at

Like (0)

Report

RE: Mass Update Vendor Numbers

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

Nitin Verma 21,595 Moderator on at

Like (0)

Report

RE: Mass Update Vendor Numbers

Hi,

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

Was this reply helpful? Yes No
Suggested answer

JAngle 113 on at

Like (0)

Report

RE: Mass Update Vendor Numbers

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

Dallefeld 193 User Group Leader on at

Like (0)

Report

RE: Mass Update Vendor Numbers

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

Was this reply helpful? Yes No