How to find products without a supplier (TBD)

Epicor ERP 10
1

Question,

Is there a way to populate a list of all products that don’t have a supplier selected? It would show as “TBD”

Thanks in Advance!

Tim

2

Show it where? In a report?

1 Like
3

PartPlant table houses the VenderNum and UrgentVendorNum fields that are assigned on the Part > Site > Planning form.

Not sure if that’s what you’re looking for.

1 Like
4

That’s certainly where @snook789 would look to find the current supplier for that part plant record, def a start.

Just not sure where @snook789 is looking to see “TBD” show up.

5

I assume they created a generic supplier called “TBD”. We did that to assign to various subcontract operations, haha.

2 Likes
6

yeah that makes sense, well then this is pretty easy if they already have that filled in, or even if it’s left blank.

@snook789 what are you asking for here? subcontract ops that don’t have a supplier yet? BTO parts on the fly that don’t have a supplier yet? regular parts that don’t have a supplier assigned in the part plant record like @dcamlin commented?

7

You would have to create a dummy Supplier called TBD (or whatever you want to name it), since the field in question can ONLY display a Supplier ID and name.

The easiest way to populate all the PartPlant records that don’t have that informaiton would be to: (1) create a BAQ to get those records, and (2) run a DMT to update them.

1 Like
8

Thanks for the replies everyone!

If we don’t have a supplier selected for a product, it is listed as TBD.
I want to go through all the products we have and make sure their is supplier attached to it.

Does this explain it okay?

9

Yeah, so if you’re still working on this, I would just do a BAQ based on the above.

PartPlant, include PartNum, VendorNum, and/pr UrgentVendorNum.

Just set a table criteria for VendorNum = “TBD” and it should return those corresponding PartNums.

1 Like