My question is "If we remove Vendor ID records from PM00200 and run Reconcile on the Purchasing data, will all data related to those now removed Vendors be removed as well"
We have a Vendor database of over 17,000 Vendors and most of them have no transaction record in the PM00400.
Your input is going to be helpful.
Hi Bill,
You cannot remove a vendor with any records existing in the open and history as you know, the reconcile will not remove any existing vendors as well, it is only correct the discrepancy between summary based on details although it will remove some distribution or tax or key record if it finds partial records among tables . If you believe there is no transaction record for the vendor, Your challenge is to find those 17000 vendors with no records in PM, I think you can have an Excel file exported from Smartlist, may be a customized Smartlist by using Vendor without transactions, you can use PM00200, PM20000 & PM30200. Once you have the list of vendors needed to remove, you can run a SQL script to remove it from PM00200 & PM00300 against the company you want to remove them.
Rob
Hi Bill-
Were they vendors from another system? Or just vendors accumulating over time? Just curious.
I wouldn't delete them -- just filter them out of the lookups and reports. Either by checking the inactive box on the vendors (or running a mass update on PM00200 to set the INACTIVE field to 1). Or possibly putting them in their own vendor class of "Inactive" or something like that.
Then use SmartList to filter the lookups to just active vendors and create report favorites that are only looking at active vendors.
Joe
Hello Bill,
Thank you for your post. If you choose to go about this by removing the Vendors out of the PM00200, there really would not be any process to remove the associated records in Dynamics GP. I tested this out by removing a Vendor out of the PM00200 table that did not have any transactions in the system, and then I ran Check Links against the Payables Vendor Master Logical File option under the Purchasing Series. The Check Links process did remove the associated Email information for the Vendor, but then when it got to the Address Information in the PM00300 table, instead of removing the Address record, it added the Vendor ID back into the PM00200 table, effectively negating the removal that I just performed.
Have you considered just creating a new Vendor Class for these Vendors (Purchasing home page | Setup | Vendor Class)? You could then update the PM00200 table for all of the Vendors that you are looking to delete with the new Class ID that you have created in the VNDCLSID field. Once you have updated them with the new class, you can just use the Mass Vendor Delete option under Utilities (Purchasing home page | Utilities | Mass Vendor Delete). You can choose the new Vendor Class ID in the Range after selecting the 'by Class ID' option and then click Process.
That process should remove all of the information associated with the Vendor that you are deleting.
Hopefully that helps!
Thank you,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,029
André Arnaud de Cal... 871 Super User 2025 Season 2
Sohaib Cheema 582 User Group Leader
