I get an error when I try to switch from serial inventory to Lot inventory. The error reads " Some transactions have multiple serial numbers on a single line, but you can have only 1 lot number per transaction line. You must delete all but 1 serial number from each line before QuickBooks can switch to lot numbers". 

I attempted to find all the transactions and deleted the serial numbers, but when I query the database for purchases and invoices through advanced reporting, it still see the multiple serial numbers on that transaction line.  

Where do I look and what do I need to do to clear the multiple serial numbers.