How to set Data selection for launch UBE Api.

[nectarsoft]

Hi List!,

We want to send an automated mail to our entire customer with ageing report individually using R03B4201B.

Problem statement:
R03B4201B generates for all customer, we want to send out automated mail for each customer. Which means, R03B4201B need to be run for each customer and generate pdf. Using launch batch application we can attaining this and pick the job number from F986110 and fetch the pdf file. Use business function B0500190 to send mail.

Where we need help is to put a data selection for each customer for in R03B4201B.

Process we defined is:
1. Develop a driver UBE and set the data selection as defined in R03B4201B and fetch reach customer and lauch UBE for every customer and generate UBE
2. Pass the additional Data selection when Launching R03B4201B for customer.
3. Fetch the job number and locate Pdf name and use B0500190 to send email.

Need your support!

Thanks and Regards,

Ravi

 

[TomAbbott]

Hi Ravi,
Your company might want to check out Create!form. This can take a single UBE with all of your customers, and automatically break it into individual PDF's, then automatically e-mail or fax those PDF's out. You can then put this on a scheduler and forget about it - so to speak. It's pretty slick. It beats having to run your UBE thousands of different times to get out a single statement to all of your customers.
No, I don't work for Create!form.

Tom

 

[nectarsoft]

Hi Tom,

Thanks for your creat!form.is there is any work around in JDE to do this ??.

thanks,

Ravi

 

[craig_welton]

Hi Ravi,

Perhaps you could add AN8 to the report data structure R03B4201B. Add data selection in the version:

WHERE AN8 = RI Address Number

When you call the UBE from the driver, pass the selected address nunber.

Craig

 

[nectarsoft]

Craig,

problem is: how to identify the right pdf and send automated mail to
customer. as long as split the pdf of each customer this works fine.
2nd stage is an issue.

Rgds,
Ravi


Quoting craig_welton <[email protected]>:

 

[Larry_Jones]

Use a little work table to pass the customer info.

 

[Chan Rana]

Ravi,
You can get the job number from Launch UBE API. Use this job number to fetch record in job table and get pdf
and you can do whatever you want with the pdf.

Hope this helps

 

[nectarsoft]

Yes chan, I could get job number from launch UBE Api. using a work file to store and retrieve customer number and job number, link with job control master to fetch pdf to send mail. Test going on

Wish me luck!

Thanks,

Ravi

 

[Chan Rana]

Thats nice to hear. All the best!!!