Knowledgebase: Tutorials
[QODBC-Desktop] How can I find QuickBooks deleted record information from QODBC?
Posted by Jack - QODBC Support on 05 August 2014 01:33 PM

How can I find QuickBooks deleted record information from QODBC?

Problem Description:

Is there a stored procedure that provides all deleted transactions? I.e., Voided/Deleted Transactions Detail?

For Example:

If an Invoice gets deleted from QuickBooks, does it get physically deleted? Otherwise, which field(s) would tell me that fact?

Solutions:

You can find Voided/Deleted Transactions details from QODBC "TxnDeleted" and "ListDeleted" tables. Please refer to tables "TxnDeleted" and "ListDeleted" to see the data you are looking for.

For Example, I have an Invoice in QuickBooks whose Invoice# is 1114  

http://support.flexquarters.com/esupport/newimages/QuickBooksdeletedrecord/Step1.png

Now we are verifying the same Invoice from the QODBC Invoice tableBy using the below query:
SELECT * FROM Invoice where RefNumber ='1114'

http://support.flexquarters.com/esupport/newimages/QuickBooksdeletedrecord/Step2.png

 

Now we are deleting the Invoice from QuickBooks, whose Invoice# is 1114: 

http://support.flexquarters.com/esupport/newimages/QuickBooksdeletedrecord/Step3.png

Now we are verifying the same Invoice from the QODBC Invoice table to see if it exists in the QODBC Invoice tableBy using the below query:
SELECT * FROM Invoice where RefNumber ='1114'

http://support.flexquarters.com/esupport/newimages/QuickBooksdeletedrecord/Step4.png

Now we are checking the same Invoice from the QODBC TxnDeleted table to see if it exists in the QODBC TxnDeleted tableBy using the below query:
SELECT * FROM TxnDeleted where TxnDelType='Invoice' 

http://support.flexquarters.com/esupport/newimages/QuickBooksdeletedrecord/Step5.png

 

We can find Deleted Transactions (i.e., InvoiceSalesOrderTimeTracking, etc..) details from QODBC "TxnDeleted" tables.

We can find Deleted List (i.e., Customer, Item, etc..) details from QODBC "ListDeleted" tables.

 

(1 vote(s))
Helpful
Not helpful

Comments (1)
Justin Holmes
03 March 2018 09:56 PM
can one remove delete transactions in the TxnDeleted table.
reason i'm asking is I've used 3rd part applications to remove old data (reduce my file size) but it does not change.
Or should I be using qodbc to delete transactions directly from the tables
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).