DMT for VendPart?

Kinetic ERP
1

I’m trying to set the vendor for a batch of parts (76 individual parts, supplied by 2 vendors), which I believe requires inserting a record into VendPart.

I’m not seeing a VendPart DMT.

The Supplier Part DMT loads records into the PartXrefVend table, but that’s not what I’m trying to accomplish.

Any suggestions? Is there a DMT already there that I’m just not seeing?

(Note: the Vendors already exist in the Vendor table).

2

I believe the VendPart information is part of the Supplier Price List.

2 Likes
3

Sir, you are exactly correct. Thank you!

Why I didn’t immediately intuit that Supplier Price List is the name for VendPart, I just don’t know.

1 Like
4

and carful with that. Vendpart will not automatically populate the podetail.vendpartnum you need to put in the supplier part which is PartXrefVend

and unsurprisingly the field name in PartXrefVend is VendPartNum

to add to the confusion the vendpart.venpartnum never gets populated even if you have a supplier part added.

Another way the PartXrefVend table gets populated is is you add approved suppliers and add a supplier part to the part in part maintenance… I know sorry too much info…

In short you:

  • VendPart.VenPartnum = Supplier price list (no onscreen field is shown by default).
  • PartXrefVend.VendPartnum = Supplier Part which is accessible from the supplier price list supplier parts tab or the Approved Supplier/Supplier part in Part maintenance.

Another cautionary note. If you used the approves supplier option then you will only be able to enter PO lines of that part for the specific supplier.