Amount paid to vendor over time including the expense GLs used for that vendor for each payment

Hello @jmcginley ,

You may find amounts paid to a vendor within a certain timeframe using AP Payment register report.

To report the expense accounts used on lines of paid bills, you will need a custom report or Generic Inquiry that joins from APPayment table (checks) to APAdjust table (relationship between check and bill) and then from APAdjust, join to APBill, and from there to APTran, to display expense account numbers.

Laura