| Difference between Quickbooks 2002 and 2006 |
| Author |
Message |
|
|
| Posted : 2007-01-23 10:53:32 |
Hi,
Does this message belong in the forum maybe not.
I have to an application where on one side there is quickbooks 2002 Premier which is used to export from a custom made application, so can not be changed or updated to a later version of Quickbooks.
The import is to be used in a Quickbooks 2006 Premier Edition. The QB file in question is the same for 2002 the original for 2006 the by QB upgraded one.
I run the following query in VB Demo application.
SELECT TxnID, JournalCreditLineAccountRefListID, JournalCreditLineAmount, JournalCreditLineMemo, JournalCreditLineEntityRefListID
FROM "JournalEntryCreditLine" "JournalEntryCreditLine"
WHERE ("JournalEntryCreditLine"."TimeCreated">={ts '2005-01-01 00:00:00'} AND "JournalEntryCreditLine"."TimeCreated"<{ts '2005-01-31 23:59:59'})
ORDER BY "JournalEntryCreditLine"."TxnID"
That returns in the 2006 version 1856 records
And in QB 2002 only 698 records.
Studying the data it returns the last record if it should have 4 credit lines in Journal.
Btw the debit lines do give the same problems.
Do you have any idea what is the problem. It is not possible to upgrade the 2002 application and I need the right data.
I could try to change the query, which I did at first by querying the corresponding debit and credit lines for each journal but that is not acceptable slow.
Peter |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-01-23 13:46:48 |
I'm guessing that you using two different versions of QODBC here? You should be using QODBC v6.0.0.176 or v7.0.0.204 (or later) on both systems. The results should then match up.
There was a bug with JournalEntryDebitLine, JournalEntryCreditLine prior to QODBC v6.0.0.143. We also added a JournalEntryLine table in QODBC v6.0.0.176 that shows both the debit and credit entries. |
|
|
|
|
|
| Posted : 2007-01-30 08:06:54 |
Tom,
I updated to version 7.00.00.207 and tested the query but getting the same results.
FOr the record I tested the Journal lines and with qb 2002 I get 800 rows returned and with QB2006 2870 rows.
Is there something I do wrong?
Peter |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-01-30 08:26:02 |
What are the number of records returned for:
SELECT * FROM JournalEntryLine unoptimized
and
SELECT * FROM JournalEntryCreditLine unoptimized
for both systems?
Please Note: Effective April 30, 2006, in accordance with Intuit's QuickBooks Sunset Policy, QODBC is no longer actively supported on QuickBooks 2003 (or earlier) and QuickBooks Enterprise Solutions Version 2.0 & 3.0.
|
|
|
|
|
|
| Posted : 2007-01-30 08:30:32 |
Tom,
I will test tomorrow. I have to go on site.
With the "Please note" you are warning me already, I could be out of Luck in getting the working ? ;-)
Peter |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-01-30 08:52:01 |
You should also increase the "Interator or Chunk Size" in the QODBC setup screen to 5,000 (and make sure "Use Interators (when using 2006 and above)" is unchecked for your QuickBooks 2002 system.
|
|
|
|
|
|
| Posted : 2007-01-31 03:05:47 |
Tom,
Thanks for all the help but I can not report a positive result.
I made all the setting but that did give the same results.
When running unoptimized and no WHERE statement I get the right count but not the right information. If there are 4 credit lines I do get 4 lines but all with the same info. I just wanted to dump all and sort it out myself but is not possible.
Then I tested with several where statements but all does not work. I get one result row if I use a where on one TxnID.
I tested with JournalLines and JournalCreditLines.
So I am pretty much stuck.
Any other ideas.
Peter |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-01-31 08:37:57 |
| Sorry, you're stuck with the problems of Intuit's qbXML SDK v1.1 used by QuickBooks 2002. Not many of us were doing much with journals back then. Another approach may be to copy and convert the 2002 company file to QuickBooks 2006 (as required) and export the transactions from there and then import the transactions to your other company file. |
|
|
|
|
|
| Posted : 2007-01-31 12:06:52 |
Tom,
I was getting afraid for this message. Yes I will have to go trough quickbooks 2006. I can not install quickbooks 2006 on that computer. The quickbooks version is attached to an other program.
So my only way would be to install quickbooks 2006 on a computer, and write a batch file to copy the 2002 database from the server, open it in QB 2006, convert it to the latest format (and that sometimes does crash) and then export the needed rows.
!@#$%^!%@#&$^% ;-)
Peter
|
|
|
|
