I am trying to build a tool that requires me to build a query that will return all lots in the system. the locations that carry lots that I have found so far:
The final format is a table with:
PartNum, LotNum, Bin, Warehouse, ProdClass, ProdGroup, Qty, Value
The locations I have been using so far:
PartLot (joined to Partbin)
PartLot (joined to PartWip)
RMArcpt (these are parts that are booked to GL but are not in the lot table. Odd)
Anyone know of any others?
I think that DMR might hold some as well.
The final format is a table with:
PartNum, LotNum, Bin, Warehouse, ProdClass, ProdGroup, Qty, Value
The locations I have been using so far:
PartLot (joined to Partbin)
PartLot (joined to PartWip)
RMArcpt (these are parts that are booked to GL but are not in the lot table. Odd)
Anyone know of any others?
I think that DMR might hold some as well.