0

I know this may be a stretch, but does anyone know where to look in the QuickBooks tables for an inventory item's serial numbers?

I have looked through all documentation I can find and can not seem to find the table that holds the serial numbers. Any advice is greatly appreciated.

Additionally, any information on where/how to pull an items Average Cost would be awesome too!

Phil
  • 4,029
  • 9
  • 62
  • 107

2 Answers2

2

SerialNumber is only available in the ItemFixedAsset table.
AverageCost is available on the ItemInventory and ItemInventoryAssembly tables.

Here is some useful documentation for the SDK that may still help you. Intuit On Screen Reference And here is a reference for the QODBC Table Schema. Using these two references I found...

The OSR ItemQuery Response shows all the different item types and their fields but the data in QODBC is broken out by item type. I found the fields here and confirmed they are on the individual Item- tables in QODBC.

Hope this helps for this and future research.

GMan80013
  • 536
  • 4
  • 13
1

Additionally, you can refer QODBC-Desktop knowledge base - Where Item Serial Numbers or Lot Numbers are stored

or

you may visit QODBC Table Schema and click "ALPHABETICAL LISTING OF ALL TABLE'S DETAIL", this will list out all the tables and fields, Just search for "SerialNumber"

Rajendra Dewani
  • 176
  • 5