APR RDDs can we add tables

Kinetic ERP
,
1

HI everyone,

We’ve moved from Document sender over to APR and I am trying to tie up all the print functions from old to new process.

With regards to AP Process Payments there are 2 tables being used in the Report Data definition. CheckHed and APtran. Neither of which house the email field that I want to draw from
image

I have tried to add the table that I need in Report Data Definition but it just doesn’t get included into the table drop downs no matter what I do.

Is this something that is possible? Or Am I attacking this in the wrong way

2

Did you join the table you added to one of the existing? Did you mark that table as an output?

Another approach would be to look at the linked tables and see if the field you need is in one of them.

3

Hi Mike. It is definitely possible. We did exactly that when we wanted to automate the emailing of AR invoices to our primary billing contacts. We needed to add the CustCnt table so that we could pull the email addresses that we wanted.

4

Btw, please consider voting for the following related idea:

Modernize Report Data Definitions to include contact email addresses for all externally distributed forms.

5

Thanks Guys, I just needed to know that I needed to persist with it.

It was indeed the Output selection on the join. I was sure I had tried and saved alternatives on that.
Obviously I hadn’t saved it correctly or something. Computers work in wierd ways around me.