Knowledgebase
[QODBC-Desktop] Troubleshooting - How can I get daily Bill Payment information?
Posted by Jack - QODBC Support on 09 March 2016 12:52 PM

Problem Description:

How can I get daily payment bill information? And How can I get daily Bill Payment information using QODBC, and How can I get these details?  

Solution:

You can use the query below to get details about daily Bill Payments.

For Example:

SELECT DueDate, VendorRefFullName as Vendor, RefNumber as Ref, AmountDue as "Amt. Due" FROM Bill where IsPaid = 0 and DueDate <= {d'2007-12-25'} order by DueDate

Note:  QODBC Support Wizard is used only to test QODBC SQL queries and is not a development tool.

 

Or

You can go straight to the BillToPay table like this.

SELECT BillToPay.BillToPayDueDate as "Date Due," Bill.VendorRefFullName as Vendor, BillToPay.BillToPayRefNumber as Ref, BillToPay.BillToPayAmountDue as "Amt. Due", BillToPay.CreditToApplyCreditRemaining as "Credit Remaining" FROM BillToPay, Bill where BillToPay.BillToPayTxnID = Bill.TxnID and BillToPay.BillToPayDueDate <= {d'2007-12-25'} order by BillToPay.BillToPayDueDate



(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).