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
|
|
adding debit/credit lines |
Author |
Message |
mwr |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-12-18 |
|
Profile |
|
Posted : 2008-12-18 13:58:54 |
I will be porting data from a legacy system into QuickBooks using QODBC. My plan is to import the transactions as JournalEntryCreditLine, JournalEntryDebitLine and JournalEntry records. First questions are there any other potential targets for importing this data to? Secondly, the records that I will be importing balance on each month so the sum of credits minus sum of debits equal zero for each month. However, the problem is i'd need to perform as many as 1000 inserts before I could set FQSaveToCache to 1 to force the commit. I am wondering if there is a practical limit when doing n-number credit/debit lines for a given header line. Thanks for the help. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-12-18 16:43:34 |
I think you should talk to your accountant first. These no reason to import all this information, just the consolidated data, or better still the open balances. As far as QODBC is concerned, the time required to process a transaction line insert gets worse the more lines there are. At all times you should not go beyond 500 FQSaveToCache INSERTS. |
|
|
|
mwr |
|
Group | : Members |
Posts | : 4 |
Joined | : 2008-12-18 |
|
Profile |
|
Posted : 2008-12-19 02:01:02 |
if I am able to take your suggestion and only import consolidated data would I still want to use the journalentrycredit/debit tables for this or would it be better to add this data to another table? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-12-19 10:54:42 |
Most of us just transfer the customer and vendor details, set up the chart of accounts, enter the opening balances, and import all the unpaid invoices and bills. |
|
|
|
|