We are trying to make a BAQ that pulls the oldest lot at each site. We are able to find the oldest lot for each part but don’t know how to make it site specific.
are you wanting to have the oldest lot that is currently STOCKED in the site? To do that, you would need to look in the WAREHOUSES that have the part on hand… warehouses point to SITES. The best place to find this relationship is in the PlantWhse table. You can link it to the PartLot table, but you have to manually create the join.
Can you explain in more detail how we would get the oldest lot to show. We are trying to do Cycle Counts and we need to know the oldest lot number for our adjustments.
PartLot has a field called first reference, which is a date. This field can be used to get the oldest lot.