Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
2189 day(s) ago   #146
Name: TechZone
Category: Technical
Location: India
Date: 2014-05-28 23:00:58
Replies(6)

Status:
  #146

Send Report Output Directly to Email in JDE E1

There was a requirement where it is needed to email the pdf of UBE output as an attachment.
We have a Business function to send an email, however, the challenge here is to get the path of the email attachment, as there are many reports executed at the same time and we need to get the name of the attachment.

In order to achieve this, code needs to be written in a specific order. Please follow the steps as mentioned below -
  1. Call the report whose output needs to be emailed as an attachment through a Business Function "Launch Batch Application" (B91300C). This Business Function will return the job number.
  2. Retrieve the Batch Server so as to Set the F986110 Data Source. Use the BSFN "Retrieve Computer ID and Job Number" to retrieve the Batch Server.
  3. Now pass the Job Number and Batch Server to F986110 and retrieve FNDFUF2. FNDFUF2 is the name of the pdf or csv file generated.
  4. Now we need the print queue path, where the pdf or csv file is generated. This can either be achieved through BSFN "Read INI" (B980055) or it can be hard coded as per the different environment.
  5. Now concatenate the FNDFUF2 to the print queue file. Also concatenate the extension of the file (.pdf or .csv) to the entire path.
  6. Pass this path into the Send Email BSFN (B0500190).


Prerequisite:
  • In the jde.ini the mail server needs to be defined.
  • The print queue path needs to be shared.
  • Use trim to remove spaces from the file path retrived from print queue before passing it to Send Email BSFN.

Thanks
JDE E1 Technical
1734 day(s) ago   #207
Name: anumolu
Category: Technical
Location:
Date: 2015-08-26 21:11:49
Replies(6)

Status:
  #207

Send Report Output Directly to Email in JDE E1

jde developer
1557 day(s) ago   #218
Name: Dpa
Category: Technical
Location:
Date: 2016-02-19 03:06:56
Replies(6)

Status:
  #218

Send Report Output Directly to Email in JDE E1

Need infomation on how to send the pdf/csv output to mail
1555 day(s) ago   #219
Name: admin1
Category: Technical
Location: Singapore
Date: 2016-02-21 18:14:33
Replies(6)

Status:
  #219

Send Report Output Directly to Email in JDE E1

Hi Dpa,
Thanks for your query!
Detailed steps alreaady given in the post above. Let us know if you encounter any issues.

Thanks
1303 day(s) ago   #240
Name: Robertslalk
Category: Technical
Location:
Date: 2016-10-30 19:55:02
Replies(6)

Status:
  #240

Send Report Output Directly to Email in JDE E1

What鈥檚 Happening with Newspapers? how to self publish a book custom packaging boxes With the J Press 720 being the very first of the kind, fitting into this new niche in production inkjet printing, it could actually well position Fujifilm to become a more impressive player inside the market. The company certainly believes so — and Boer believes that in five or a decade, the name Fujifilm could hold an alternative power within the printing world. ,What Role Do Your Sales Professionals Play? Randy Freeman, vice chairman of business development, said for a drupa media briefing that QuadTech`s broad goal should be to hasten the arrival of 聺lights out聺 printing with solutions created to 聺eliminate the ambiguities and also the bottlenecks聺 of print manufacturing. Soma Patel, technical manager for application, noted that this annual installing $1.6 billion in web offset equipment creates a niche opportunity that QuadTech is ready and desirous to cultivate.
1243 day(s) ago   #248
Name: AhjthonyExono
Category: Technical
Location:
Date: 2016-12-29 22:26:21
Replies(6)

Status:
  #248

Send Report Output Directly to Email in JDE E1

who want to get a greater and perfect...
1139 day(s) ago   #262
Name: Aanlodwes
Category: Technical
Location:
Date: 2017-04-12 00:54:05
Replies(6)

Status:
  #262

Send Report Output Directly to Email in JDE E1

...
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in