Share
ReportWe have 7000 vendors that need to be inactivated and we have an option to do an integration but inactivating the CLASSID would be simpler.
*This post is locked for comments
You’re offline. This is a read only version of the page.
345
We have 7000 vendors that need to be inactivated and we have an option to do an integration but inactivating the CLASSID would be simpler.
*This post is locked for comments
I would juut run this script in SQL.
UPDATE PM00200
SET VENDSTTS=2
where VNDCLSID='YourVendorClass'
Make sure you have a backup just in case. You can substitute your vendor class ID into the where clause.
The vendors that have current activity under the classes we need to inactivate have been moved to new classes already. Right now there is no current activity on the vendors we need to inactivate. But if there is no way to inactivate a CLASSID, we are going to have to go with an integration to update the vendor status to INACTIVE for the records required.
Inactivating a vendor also takes into consideration any open activity with the vendor. There is no 'Inactive' button on the vendor class so there is nothing to roll down. You could create a SQL script that will flip the flag for you for the classes selected but you want make sure there is no open activity for these vendors. You could then add a little VBA code to prevent any activity for these classes of vendors.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (