Troubleshooting - Where Item Serial Numbers or Lot Numbers are stored

Problem Description:

I'm having trouble finding where an Item's serial numbers are stored in the QuickBooks database. I have gone through your table schema online here http://doc.qodbc.com/qodbc/usa/, but I cannot find where the serial numbers for a given inventory item are stored.

Can you please advise?

Solution:

You can find SerialNumber or LotNumber from the Transaction module you have assigned.

For Example, if You have assigned SerialNumber or LotNumber in the Invoice, then you need to refer InvoiceLine table.

Below is the list of table & column which contains the serial number.

SerialNumber Details:

LotNumber Details: