E9.2 JDE Send email based on Who's who Electronic Address Category

[fandih]

Hi,

I have issue while sending email.
The issue is everytime I run a report, it will send to all email that registered at who's who.
I would like to each time I run a report, it will only send email spesifically to an email that has tag on Electronic Address Category at who's who.
for example: I run PO report, I only send email to the email that has "PO" code on Electronic Address Category.
So is it possible that JDE done that?
If it yes, then could someone help to guide me.

Regards,
Fandi

 

[Rauf]

I guess this is a custom report. You can just check the Cat code and send the email based on this code.
Please let us know which BF you are using to send email.

 

[fandih]

Hi Rauf,

Thanx for the reply.
yes it is custom report and I did not use BF to send email. I am using standard RD (Report Definition) to call the Email and I applied it on the report version.
I only applied the settings as my image (RD_Email_Configuration.jpg) attach on my previous post.
May i know which cat code you are reffering to?
is there any configuration that I missed there?

Regards,
Fandi H.

 

[w2vijay]

Hi Rauf,

Thanx for the reply.
yes it is custom report and I did not use BF to send email. I am using standard RD (Report Definition) to call the Email and I applied it on the report version.
I only applied the settings as my image (RD_Email_Configuration.jpg) attach on my previous post.
May i know which cat code you are reffering to?
is there any configuration that I missed there?

Regards,
Fandi H.

Hello Fandi,

The ER logic to retrieve email id for Electronic Address category "PO" should be as below.

==================
// initialize Variables.
VA evt_LineNumber_LNID=0
VA evt_ElecAddType_ETP='E'
VA evt_ElecAddCat_ECLASS='PO'

F01151.Select
BC Address Number - Ship To = TK Address Number
VA evt_LineNumber_LNID = TK Who's Who Line Number - ID
VA evt_ElecAddType_ETP = TK Electronic Address Type
VA evt_ElecAddCat_ECLASS = TK Electronic Address Category
F01151.FetchNext
RV EmailAN8 <- TK Electronic Address
===============

Thanks,
Vijay Vattiprolu
Sr Consultant - JD Edwards
E1 9.2 ,TR 9.2.0.3 , Oracle 12C , IE 11
formerly 9.1,8.12,8.11,8.0, Oracle 11G, SQL 2014,12,2008

 

[fandih]

Hi Vijay,

Thanx for the respond.
For the part you show it to me actually I already try to implement that.
the result is, it can only send 1 email with the same address book (F1151.AN8) and PO categorize.

Actually I would like to send many email under the same address book (F1151.AN8) that has PO categorize.
as example as image below.

Currently for the work around,
I seperate them. So for Auto send PO, I create new another supplier number (An8) with same supplier name only for auto send PO by email

I have info from oracle support, currently they did not have that feature yet.
They said, this is enhancement project.
here is the Oracle Bug ID:
Bug 11031154 : BI PUBLISHER EMAIL FUNCTIONALI - SAR: 8950463


Regards,
Fandi H.