Solved

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

  • 20 September 2023
  • 1 reply
  • 69 views

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

icon

Best answer by Laura02 20 September 2023, 03:03

View original

1 reply

Badge +18

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved