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
View originalHi
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
View originalJoin 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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.