Sorry, here is some more information.
1st, there is no data within the receivetodeposit table
I am trying to locate all payments and charges on an account. I do not care how they were applied, I just need to raw amount for each type. In theory if I can locate all payments and charges, the running balance should equal QB.
The problem is when I run my export utility, a few customer account balances do not match the QB balance. When I look at one of the accounts, I notice there are missing payments from the data I exported. I am getting the payments from the depositlineamount and receive payment tables.
If I look at the InvoiveLinkedTxn table, there are references to the payment records I am looking for (based on the reference and amount applied), but I cannot locate the actual payment record.
I mistated the EFT comment in my original question, but the common thread to all missing payments does have EFT as the type of payment, although there are others on the account that did export.
Owners History...
Payment not exported..
DepositLine query, ordered by TxnDate, where DepositLineEntityRefListID = CustomerListID
ReceivePayment query, ordered by txndate, where CustomerRefListID = CustomerList ID
As you can see, there are several payments not in either query, 1/2/03 = 107, 2/2/03 = 107, (2) 3/31/03 = 107.
Thanks in advance for your help!
|