quickbooksqodbc

QuickBooks - QODBC Driver, Look up Item Serial Numbers

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!

Solution

  • 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"