How do get the amount paid to vendor over time (YTD or over 12 month period) including the expense GLs used for that vendor for each payment
Page 1 / 1
Hello
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.