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
Answer
Amount paid to vendor over time including the expense GLs used for that vendor for each payment
Best answer by Laura03
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
+19Hello
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
~ Laura Barber, WM Synergy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.