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.
Answer
Adding vendor last payment date to a generic inquiry
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
-Coleen
+15Join 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
Dermot Comerford
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.