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