Question

Add AR Customer Contact for Event Action to e-mail PDF REPORT CREATED (Interest Invoice)

  • 28 August 2020
  • 3 replies
  • 328 views

Userlevel 1
Badge +5

I have confirmed with IFS that Repeat media output in not supported for Interest Invoice for Apps8, so the PDF_Parameter_1 is not supported.  Noting that I will have to hardcode the email address in the event.
Since each Customer has their own email address, hardcode is not an option.

Does anyone know of a way that I can pull in the AR Customer Contact detail, at least the E-mail Value into Event Action for Interest Invoice, so that the email notification and Interest Invoice pdf can be sent to the individual customer contact?

 


3 replies

Userlevel 7
Badge +24

hi Renea!

yes you can do it.  But it means that instead of using the guided “Email” event action type, you need to use the more flexible “Execute Online SQL” action.

This way, you can fetch any field in the database and use it; including the AR email address you are looking for.

But it will require some script writing.

Badge +3

Hi Renea,

 

Paul is correct. Please message me if you need an example code.

 

Regards,

Namal

Userlevel 5
Badge +9

Have you looked at Report Rules?  We have Apps10 and I can’t remember if Apps8 supported email in Report Rules. If it does, that is another option.

Reply