|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| No records found in TXNDELETED table |
| Author |
Message |
| Mike |
| |
| Group | : Members |
| Posts | : 1 |
| Joined | : 2006-03-21 |
|
| Profile |
|
| Posted : 2006-12-13 11:33:05 |
When I run this SQL query:
Select * from txndeleted in the VBdemo application I get the list of fields that are in the txndeleted table, but no records.
I went into the sample company and deleted a cheque to make sure I had some deleted transactions.
I am using QODBC ver 7.00.00.199 on Australian 2006/07 version of QuickBooks. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-12-13 12:07:53 |
The TxnDeleted table is currently only supported by the USA versions of QuickBooks. To update you, this bug issue has been reported to Intuit's IDN for the deleted records issue. They verified it is broken in the UK version of QuickBooks. They (Intuit) have an open bug for CA (Canadian) version so they added our UK info to the CA bug report.
So before this will ever work for us in Australia, it will need to be fixed by Intuit Canada for QuickBooks 2008, meaning it won't happen until May, 2008 at the earliest. |
|
|
|
|
|
| Posted : 2007-09-01 07:31:57 |
| I also don't get any rows from 'Select * from TxnDeleted UNOPTIMIZED' query. I have USA edition of Quick Books Premier 2006 edition and QODBC V 7.00.00194. The Audit Trail in Quick Books does display the transaction as Deleted. What do I need to do please? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-09-01 09:39:48 |
| From memory, the TXNDELETED table only holds info for the last 90 days only and you need to update to 7.1.0.231 |
|
|
|
|