Does anyone know what table I can find the primary bin for a part in the primary warehouse. I’m trying to write a baq to display it and I find the Primary Warehouse in the PartPlant table to can’t find the Primary Bin.

It’s PlantWhse


Join PartPlant to PlantWhse


1 Like

Don’t forget about field help. It’s invaluable when trying to find what table a field is located in. Click on help/field help, then go to the technical details section. When that is up, it will show information on whatever field you last clicked on. It will usually give you enough hints that you can find the field in a query.

(but I see this is one of those exceptions where the field help isn’t all that helpful)