Knowledgebase: TroubleShooting
[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 do refer table "TxnDeleted" and "ListDeleted" to see the data you are looking for.

For Example: I have Invoice in QuickBooks whose Invoice# is 1114  

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

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

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

 

Now we deleting Invoice from QuickBooks whose Invoice# is 1114: 

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

Now we are verifying the same Invoice from QODBC Invoice table to see if it exist in QODBC Invoice table or notBy using 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 QODBC TxnDeleted table to see if it exist in QODBC TxnDeleted table or notBy using below query:
SELECT * FROM TxnDeleted where TxnDelType='Invoice' 

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

 

We can find Deleted Transactions (i.e. Invoice,SalesOrder,TimeTracking 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).