[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 Now we are verifying the same Invoice from the QODBC Invoice table. By using the below query:
Now we are deleting the Invoice from QuickBooks, whose Invoice# is 1114: Now we are verifying the same Invoice from the QODBC Invoice table to see if it exists in the QODBC Invoice table. By using the below query: Now we are checking the same Invoice from the QODBC TxnDeleted table to see if it exists in the QODBC TxnDeleted table. By using the below query:
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.
| |
|
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