Email AP Remittance using APR

nstorm · November 4, 2024, 9:53pm

Still no luck. Does it look like my table join is correct?

Chris_Conn · November 4, 2024, 9:54pm

Yes, your join seems correct.

nstorm · November 4, 2024, 9:58pm

Any other suggestions as to why the VendCnt table doesn’t show up in the routing?

Chris_Conn · November 4, 2024, 10:05pm

I notice your Vendor table isnt in their either. Perhaps all of the tables to get to the end table are needed. I am not sure, but I know it’s finicky. Sorry

nstorm · November 4, 2024, 11:02pm

I had to make a table relationship between the APTran table and the Vendor table. It works now.

ReneZ · January 6, 2025, 8:35pm

I copied the Report Data Definition (ApCheck) and added the Vendor and VendCnt table and the report relationships (CheckHed - Vendor and Vendor - VendCnt).
I used the VendCnt.RoleCode field to filter which Contacts will receive the Payment remittance.

Tparson · March 19, 2025, 12:04pm

Thanks for this post it has been really helpful, I can get it to work but only if the primary contact is checked. Does anyone know another way to have the correct contact be selected. We are using the primary contact for another purpose and have a contact called remittance advice that has an email address of where we need to send the invoices. I have tried to use name and email fields in the RDD Vendor2VentorCnt but it won’t return a true value.