"Quantity in Inspection

Is there any quantity on hand?

Regards,

Travis

Hi Karen,

Lot control cannot be toggled if any on-hand amount exists either in inventory or in an inventory nonconformance in any site within the company.

If you’re handy with SQL, try the following two queries to check. Let me know what you find. In the code, you will need to change firstpart and so on to the names of your parts (make sure those apostrophes stay on either end of the part number). I’d love to hear what you find. :)

--Get on hand quantities of select parts.
select p.TrackLots, p.PartNum, pb.WarehouseCode, pb.LotNum, pb.OnhandQty
from Erp.part as p 
	left join Erp.PartBin as pb 
		on p.company = pb.company and p.partnum = pb.partnum
where p.PartNum in ('firstpart','secondpart','thirdpart')
order by p.PartNum, pb.WarehouseCode, pb.LotNum

--Get open nonconformances of select parts.
select p.TrackLots, p.PartNum, nc.TranID, nc.LotNum, nc.Quantity
from Erp.part as p 
	left join Erp.NonConf as nc 
		on p.company = nc.company and p.partnum = nc.partnum
where p.PartNum in ('firstpart','secondpart','thirdpart')
order by p.PartNum, nc.TranID, nc.LotNum

Yours,

Ben Connelly