I am trying to run a MS query with QB that will give me the data for all checks written within a certain time period. This is for a report we will have to send to the bank for check verification purposes.

Needless to say, I am very new at this and while alot of the information on this forum has been very helpful, I've not found anything specific to my issue.

I have not been able to locate the data field in QB that will give me the actual payee name as it is printed on the check and I've had problems with setting the Transaction Date to a specific date.

Would I have to join tables to get manual checks and bill payment checks to show up together? And, where is that data field that will show the payee name, not the vendor name?

Thank you in advance for any assistance.

The checks table only contains checks that are NOT used to pay bills. To get a complete check register, you have to use a combination of the check table and the billpaymentlinkedtxn (where checks that pay posted bills exist).  Eventually we will combine them to get a complete check register.

If you are paying bills each day and printing or sending them in a daily batch to the bank, then you can try looking at:

SELECT RefNumber, Amount, TxnDate, Memo, PayeeEntityRefFullName FROM BillPaymentCheck
where BankAccountRefFullname='Checking' and IsToBePrinted is NULL and TxnDate={fn CURDATE()}

Thank you!! As I said, I'm new to this whole thing.. would it be possible to provide a little more detail on how I get the resolution you suggested into a MS Query? I did get it to work using only the Check Register Table, but as you know, that will not capture any bill payments and the vast majority of our checks are written through bill payments.

Thank you again so much for your time and patience..

Try running:

SELECT BankAccountRefFullname, RefNumber, Amount, TxnDate, Memo, PayeeEntityRefFullName
FROM BillPaymentCheck

and then determine what is it that you want to do?

Thank you... I will try that... but it won't give me manual checks... can you explain how to properly join tables? I gave that a go and was not successful so I must not have been doing something right. Also, I have noticed that it appears that the vendor name is the only data field that comes through on the tables, and I need the PRINT ON CHECK AS field, which I think is from the Vendor table?

Perhaps I need to get a better grip on how to join the tables properly?