Learned the hard way that ‘Approved Supplier’ has at least 3 distinct meanings in Kinetic. Apparently if you set to true on a price list row, that part is now restricted on only ‘approved suppliers’. Which is something different than a supplier having Approved Supplier box ticked. Clear as mud.
Basically we loaded all our price rows with that box checked and now I want to uncheck them ideally without running DMT 4 hrs so I was gonna try asking for a datafix.
In DMT it’s VendPart.AprvSupplier but that field doesn’t seem to exist in VendPart table.
Does anyone know if this means support cannot provide a datafix for this?
Not sure how everything links up, but I think when a vendor is “approved” for a given part, etc. a record is added to the AprvVend table.
Perhaps query that table and see if you can make any correlations.
There is an “Approved Supplier” DMT template which I think maps to that table. You may be able to run a BAQ query against AprvVend, export a set of records to excel, then run that in your DMT using the “Delete” option and see if it clears those rows.
This may delete the “Approved Supplier” references against those parts.
I would definitely test this in Pilot and make sure it doesn’t break anything.
Thanks David. The Supplier Price List DMT works it just takes forever so I was hoping for a datafix. You bring up a good point though, perhaps they can provide a fix: DELETE * FROM AprvVend instead of UPDATE VendPart SET AprvSupplier = FALSE