Knowledgebase: Data & Table
[QODBC-Desktop] Troubleshooting - Serial Number/Lot Number Quantity On Hand does not match with the report in QuickBooks.
Posted by Jack - QODBC Support on 19 January 2018 09:09 AM

Troubleshooting - Serial Number/Lot Number Quantity On Hand does not match with the report in QuickBooks.

Problem Description:

I recently ran into an issue when querying the inventory on hand for each lot number. In QuickBooks, there is a report called "Lot Numbers in Stock". On that report, you can click on the Lot Numbers, and it opens a Quick View that shows the On Hand QTY for each Lot Number

I've searched through the tables with the help of QODBC and the only table I could find that appears to offer the information was the "BuildAssembly" table. However, the Quantity On Hand does not match at all what shows when I run the report in QuickBooks

Could you please point me in the right direction to where I can query this information using QODBC?

Solution:

I am not sure How "Lot Number In Stock" or "Serial Number In Stock" report is showing QuantityOnHand & which table it is using. You can verify QuantityOnHand from BuildAssembly through QuickBooks UI & QODBC which will be same.

The BuildAssembly table will show QuantityOnHand details when Assembly was built. It will not show current Quantity as shown in the report.

Also, I'm sorry to inform you that the "Lot Number In Stock" or "Serial Number In Stock" report is not available through the Intuit SDK, so they are not available through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn’t expose one feature to the application in SDK, QODBC could not do it either.

Refer: How to export QuickBooks data not available in QODBC

(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).