Skip to main content
Solved

Adding vendor last payment date to a generic inquiry

C
Jr Varsity II
Forum|alt.badge.img

Hi

I am trying to get the last payment date for vendors on a generic inquiry.  Does anyone know where that field is stored or the best way to pull that date into a generic inquiry.

Thanks!

Coleen.

 

 

Best answer by dcomerford

Join the APPayment table to the Vendor and then Group by the VendorID and use the Max of the DocDate as the Aggregate function. See attached 

View original
-Coleen
robk20
1 person likes this
  • robk20
    robk20
Did this topic help you find an answer to your question?

2 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • 646 replies
  • Answer
  • June 2, 2023

Join the APPayment table to the Vendor and then Group by the VendorID and use the Max of the DocDate as the Aggregate function. See attached 

1 Attachments
Dermot Comerford
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
C
Jr Varsity II
Forum|alt.badge.img

@dcomerford  - Thank you that is what I thought, appreciate the response.

-Coleen
Chris Hackett
dcomerford
2 people like this
  • Chris Hackett
    Chris Hackett
  • dcomerford
    dcomerford

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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