Hello,
I need to create the following report:

AR Payment is received, so Vendor PO needs to be paid

Report needs to show:
Customer Invoice #, Customer Name, Date Paid, PO # we issued to Vendor, Vendor Bill Date, Vendor Bill #, Vendor Bill Amount

Totals at the bottom so we can issue payment.

Ideally this report would be scheduled to run each night so we know in the morning what payments need to be issued.

My problem is that AR and AP cannot cross information on the same report according to what I have learned so far. Any suggestions out there?

Thanks,