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
|
|
Problem with table JournalEntryLine |
Author |
Message |
|
Posted : 2008-02-25 13:04:27 |
Hi There,
I am using the ODBC driver to select data from the table JournalEntryLine (see below).
SELECT JournalLineAccountRefListID, JournalLineClassRefListID, TxnDate, JournalLineAmount, TxnID FROM JournalEntryLine
My problem is that in some rows the JournalLineClassRefListID or JournalLineAccountRefListID is blank.
How do I correct this problem, get the Class Number or Account Number into that table?
Thanks in advance for the help,
Mark
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-25 13:35:35 |
Try looking at the actual journals using the QuickBooks User Interface to see what's wrong with the journals, however it's normal not to have a Class assigned to every journal entry!
If you need to update a class for a transaction, you need to use the JournalEntryDebitLine and JournalEntryCreditLine tables like this::
UPDATE JournalEntryDebitLine set JournalDebitLineClassRefListID = '50000-933272658' where TxnID = '538E-1197729775'
UPDATE JournalEntryCreditLine set JournalCreditLineClassRefListID = '40000-933272658' where TxnID = '538E-1197729775'
|
|
|
|
|
Posted : 2008-02-25 13:45:11 |
Thanks Tom, I will look into using those two tables. |
|
|
|
|