I'm trying to create a report where we show bills/invoices paid and include a column that shows what GL account the bill was allocated to.
So far I've created a report that shows the Date, Date Closed, Payee, Amount, but the GL account is the payment account which is always our AP account. I'm hoping that it can find the GL account for the actual bill, and not for the payment. If anyone can let me know if there's a way to do this I'd greatly appreciate it.
Thanks!