|
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
|
|
| How do I locate my Undeposited SalesReceipts that have not been deposited to a Bank Account? |
| Author |
Message |
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-08-05 10:30:20 |
To isolate all the Undeposited Sales Receipts that have not been deposited to a Bank Account we have to do a LEFT OUTER JOIN with the DepositLine table and find out if there's no bank deposit account like this:
SELECT salesreceipt.TxnID, salesreceipt.CustomerRefFullName,
salesreceipt.Refnumber, salesreceipt.DepositToAccountRefFullname,
salesreceipt.TotalAmount, DepositLine.DepositToAccountRefFullname
FROM {oj salesreceipt LEFT OUTER JOIN DepositLine
ON salesreceipt.TxnID = DepositLine.DepositLineTxnID}
Where salesreceipt.DepositToAccountRefFullname = 'Undeposited Funds'
and DepositLine.DepositToAccountRefFullname is NULL
|
|
|
|
|
|
| Posted : 2009-02-06 17:03:27 |
FYI, this seems simpler, and works in QuickBooks Pro 2008 (USA) with QODBC version 9:
select TxnID, TxnLineID, TxnType, CustomerRefListID,
CustomerRefFullName, TxnDate, RefNumber, Amount, FQPrimaryKey
from ReceivePaymentToDeposit
but I have not yet figured out how to link in the SalesReceipt in order to determine the Payment Method (which would allow grouping Visa/MC separately from AmEx).
Ann |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2009-02-06 17:59:25 |
Not really, ReceivePaymentToDeposit lists all of the Payments Received to Undeposited Funds; ready for Deposit, not just Sales Receipts.
See also: How do I write Deposits using QODBC? |
|
|
|
|