Knowledgebase: QODBC
[QODBC-Desktop] Troubleshooting - Where Item Serial Numbers or Lot Numbers are stored
Posted by Jack - QODBC Support on 04 December 2017 07:14 AM

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 NameColumn 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 NameColumn 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

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).