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 cannot seem to 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 in which you have assigned it.
For Example, 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:
Table Name | Column Name |
BillItemLine |
ItemLineSerialNumber |
BuildAssembly |
SerialNumber |
BuildAssemblyComponentItemLine |
SerialNumber |
CheckItemLine |
ItemLineSerialNumber |
CreditMemoLine |
CreditMemoLineSerialNumber |
CreditCardChargeItemLine |
ItemLineSerialNumber |
CreditCardCreditItemLine |
ItemLineSerialNumber |
InventoryAdjustmentLine |
InventoryAdjustmentLineQuantityAdjustmentSerialNumber |
InventoryAdjustmentLine |
InventoryAdjustmentLineSerialNumber |
InvoiceLine |
InvoiceLineSerialNumber |
ItemFixedAsset |
SerialNumber |
ItemReceiptItemLine |
ItemLineSerialNumber |
SalesOrderLine |
SalesOrderLineSerialNumber |
SalesReceiptLine |
SalesReceiptLineSerialNumber |
TransferInventoryLine |
TransferInventoryLineSerialNumber |
LotNumber Details:
Table Name | Column Name |
BillItemLine |
ItemLineLotNumber |
BuildAssembly |
LotNumber |
BuildAssemblyComponentItemLine |
LotNumber |
CheckItemLine |
ItemLineLotNumber |
CreditMemoLine |
CreditMemoLineLotNumber |
CreditCardChargeItemLine |
ItemLineLotNumber |
CreditCardCreditItemLine |
ItemLineLotNumber |
InventoryAdjustmentLine |
InventoryAdjustmentLineQuantityAdjustmentLotNumber |
InventoryAdjustmentLine |
InventoryAdjustmentLineLotNumber |
InvoiceLine |
InvoiceLineLotNumber |
ItemReceiptItemLine |
ItemLineLotNumber |
SalesOrderLine |
SalesOrderLineLotNumber |
SalesReceiptLine |
SalesReceiptLineLotNumber |
TransferInventoryLine |
TransferInventoryLineLotNumber |
|