Paid Invoices by Business Unit


Active Member
Does anyone have a foolproof way to report on all vouchers by business unit, summarised as paid and unpaid, including invoices that have been processed through voucher logging? The standard JDE reports only address open AP items and the link back to the business unit to which the expense is booked seems to be lost by the time the payment is made.

I've made some progress by joining the F0411JD to the F0911 by document number and then excluding matches where object account is the logging control to remove the duplicates. Can't help thinking that there must be an easier way and that many other companies out there must have the same requirement for cash control.

Any ideas welcomed!