Cashflow Budgeting - Future Payables Report by Month and Vendor Department

We get long dated terms for several of our vendors, and we are trying to predict cashflow more accurately for several months into the future. Hoping to find a way in sage to produce a report that includes amounts owing per month that are dictated from the invoice due date upon receiving and entering into the system. We have our payables split into departments so also trying to see if that can be accommodated in a future payables report like this.

Any help or advice on this would be appreciated! 

Dane