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 a SerialNumber or LotNumber in the Invoice, then you need to refer to the InvoiceLine table.

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

SerialNumber Details:

LotNumber Details: