You can create your own inquiry with Inquiry Designer using the Start Level "AP - Check".  Ours includes the required fields of Check Date, Check Number, Payee Name, and Check Amount as well as the Bank Account so we can separate the file and upload each bank accounts checks separately.  Conditions are added to specify the bank accounts that we want included in the inquiry and the check date (or date range).

You can create your own inquiry with Inquiry Designer using the Start Level "AP - Check".  Ours includes the required fields of Check Date, Check Number, Payee Name, and Check Amount as well as the Bank Account so we can separate the file and upload each bank accounts checks separately.  Conditions are added to specify the bank accounts that we want included in the inquiry and the check date (or date range).

Thanks for the response! I have a Reports Designer and a Financials Designer, but I've never heard of an Inquiry Designer. Is that a separate Sage 300 Module that needs to be purchased? Would love to start making custom run inquiries.. 

Yes, it is a separate module that you would have to purchase.  I just noticed you said Sage 300 and I am using Sage 300 CRE.  I'm not sure if its available in Sage 300, but if it is its unbelievably helpful.  I use it all the time and it is easier than Report Designer.  If you are familiar with Report Designer you will not have any trouble with Inquiry Designer.

Use MS Query in Excel.

Thanks Jim!!! Perfectly worked for what I needed!!!