185
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?
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.
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
Hi,
as Kim mentioned please consult with your development partner for doing this activity
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (