|
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
|
|
| JournalEntryLine and JournalEntry problems. |
| Author |
Message |
| Mark |
| |
| Group | : Members |
| Posts | : 1 |
| Joined | : 2007-03-26 |
|
| Profile |
|
| Posted : 2007-03-26 06:03:22 |
I am using QB Canada and importing tables into Access via QODBC and am experiencing the following problem.
A journal entry has been deleted in QB but the information has not been deleted in the JournalEntryLine and JournalEntry tables but it has been deleted in JournalEntryCreditLine and JournalEntryDebitLine.
Is this a bug or am I doing something wrong.
Thanks |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-03-26 09:32:14 |
|
The Canadian version of QuickBooks doesn't correctly show deleted transactions in the TxnDeleted table for us to update deletes in the optimized tables, so you need to fully resync your optimized JournalEntryLine and JournalEntry tables by running:-
sp_optimizefullsync JournalEntryLine
sp_optimizefullsync JournalEntry
Once you run each of these commands in VB Demo, the tables will be correct. |
|
|
|
|