Cash Account Generic Inquiries

Hello,

Have you tried the Cash Flow Forecast Inquiry included in Banking module?  Select Company, Select Bank account, select Start Date. Options to include/exclude entered/non-released, non-posted transactions. 

There is a related setting, “Default Date Range” in Cash Preferences.

Balance as of today is included, through one week because the Default Date Range is set to Week in this example. 

(AR and AP is included in the Cash totals by day, but isn’t shown as a separate line.)

HTH.

Laura

Thanks ​@laurabarber45 

ya, I thought that would be a helpful screen. But for me it separates for each customer or vendor and I really just want a total across all. 
 

Did you try the checkbox that says, “Show Summary Only”?  Seems like the results will be reduced to one line per Cash Account, still not listing AR and AP Due as a sum total separate from posted cash balances.

​@laurabarber45 

When I check my summary box, it only gets rid of all the date columns and all the rows stay the same. 
which does not seem helpful. 
 

Maybe mine is somehow built incorrectly?

I’m sure it’s built fine. I wasn’t entirely sure from the Help, what the summary version provides.  I’ll keep thinking about this and update you if possible. 🤞