Hi All,

SELECT JournalEntryCreditLine.TxnDate, JournalEntryCreditLine.TxnID,
JournalEntryCreditLine.JournalCreditLineAccountRefFullName,
JournalEntryCreditLine.JournalCreditLineAmount,
JournalEntryDebitLine.JournalDebitLineAccountRefFullName,
JournalEntryDebitLine.JournalDebitLineAmount,
JournalEntryDebitLine.JournalDebitLineMemo
FROM JournalEntryCreditLine, JournalEntryDebitLine
WHERE JournalEntryCreditLine.TxnID=JournalEntryDebitLine.TxnID
and ((((JournalEntryDebitLine.TxnDate)>={d'2007-05-16'}))
or   (((JournalEntryCreditLine.TxnDate)>={d'2007-05-16'})))

just change the date to suit.

Hi Tom,

Thank for the reply!

From the above query, we believe that we will get “GEN1” and “GEN2” transaction entry information in our example mentioned above.

But we are looking for a entry which said that Journal Entry Transaction “GEN2” is applied to “GEN1”. Like “CreditMemoLinkedTxn” table of QODBC, gives Credit Memo apply information i.e. Credit memo is applied to which invoices etc.

Hence can you please advice which table stores the entry for Journal Entry Transaction applied information?

Thanks in Advance!

Clifford

Sorry, there ins't a JournalLinkedTxn table. I'm assuming here that these journals are not within the one transaction because it's easy to find all items in a transaction by the TxnID, so I would start with:

SELECT JournalEntryCreditLine.TxnDate, JournalEntryCreditLine.RefNumber as CreditRef,
JournalEntryDebitLine.RefNumber as DebitRef, JournalEntryCreditLine.TxnID,
JournalEntryCreditLine.JournalCreditLineAccountRefFullName,
JournalEntryCreditLine.JournalCreditLineAmount,
JournalEntryDebitLine.JournalDebitLineAccountRefFullName,
JournalEntryDebitLine.JournalDebitLineAmount,
JournalEntryDebitLine.JournalDebitLineMemo
FROM JournalEntryCreditLine, JournalEntryDebitLine
WHERE JournalEntryCreditLine.TxnID=JournalEntryDebitLine.TxnID
and ((((JournalEntryCreditLine.RefNumber) like 'GEN%'))
or   (((JournalEntryCreditLine.RefNumber) like 'GEN%')))

and then look at the account I'm actually interested in.

Hi Tom,

Thanks once again for your reply!!!

Well, from the above query, we still get the “GEN1” and “GEN2” transactions entry information in our example mentioned above. We have an idea how we can to get such information using QODBC. As I said earlier, we are looking for an entry which gives us Journal Entry Transaction “GEN2” is applied to “GEN1”.

Now, let me explain how we have created “GEN1” and “GEN2” transactions in QB and then apply “GEN2” transaction to “GEN1” transaction with the help of screen shots. This will gives you basic idea of what information we required from QODBC.

1. First we have created “GEN1” and “GEN2” Transactions using “Make General Journal Entries” for customer “Intuit”. Please refer the below screen shots.

As you can see from the above screen shots, in “GEN1” and “GEN2” Transactions, we have used “Account Receivable” type of account and set customer Name “Intuit” in “Name” field against this account. Due to this QB has affected the customer balance of “Intuit”.

2. After this we have applied “GEN2” Transaction to “GEN1” transaction using “Receive Payment” entry. Please refer the below screen shot. As you can see, here we have used “Discount and Credits” button to applied “GEN2” Transactions to “GEN1”.

Now, please refer the below screen shot which shows apply information of “GEN1” Transaction. We want this information from QODBC. Hope this clears our requirement.

Please advice which field or table or store procedure can give us such information.

Thanks in Advance!
Clifford