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