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

Troubleshooting - How can I get daily Bill Payment information?

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 below query to get details about daily Bill Payment information.

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



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).