Results 1 to 6 of 6

Thread: Options for emailing a report to a user

  1. #1
    Member
    Join Date
    Aug 2005
    Location
    Atlanta
    Posts
    259

    Options for emailing a report to a user

    We are on E1 9.0, tools 9.1.4.7.

    We have a request where the users are requesting that a new report UBE be emailed to an end user. I suppose we could use the embedded BI Publisher for that. We email ACH remittances in A/P, so I assume we could do the same with a simple report.

    Would appreciate any input on this option, or any other options available not using BIP where a UBE pdf output could be emailed to a specific email address.

    Thanks.

  2. #2
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,756
    Jimmymac,

    What system are you running? iSeries, Windows, Linux...

    (db)
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  3. #3
    Jimmy - John Danter has a whole thread on this. If you are open to a third party solution that involves no changes to your E1 system , look at LynX Output Manager. Link: https://www.aellius.com/lynx-output-manager/
    Regards,

    Hari Sharma
    Aellius
    EnterpriseOne: Integration (.Net, Web Services) | Output Management | Monitoring

  4. #4
    Senior Member Alex_Pastuhov's Avatar
    Join Date
    Jul 2001
    Location
    Australia
    Posts
    1,724
    We have a simple (but commercial) solution for this - AUTOPRINT, if you are interested. Which is all native JDE code and can be extended to accommodate any custom requirements.
    Regards,
    Alexander Pastuhov
    http://www.everestsoftint.com/

  5. #5
    Member
    Join Date
    Apr 2004
    Location
    Georgia, USA
    Posts
    119
    I found a way to do this using the Report Level Event Rules, End Report section. This may or may not be available for your TR release. You'll need to create a custom bsfn to get the UBE job number (there are multiple sources on the web on how to create this function) to help create the URL for the PDF or csv file you want to send. Then use bsfn B0500725 Email Merge Letter to send the file.
    Currently working on 9.0, Windows platform, Oracle DB

  6. #6
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    155
    I am actually in the process of implementing this for our customer statements and sales invoices. The customer statements work very well so far.

    The only problem I am having is trying to get the invoice UBE (R42565) to format properly so that the XML fiel being generated makes enough sense (format-wise) so that it is somewhat compatible with the RTF document. Having a little bit of an issue with the repeating sections as the R42565 does not do a 'normal' process and has a buld section and then uses a bunch of custom sections so the resulting XML file from the standard UBE looks like a mess.

    I like using the embedded BI Publisher method as it seems to work relatively well and gives us an integrated solution with JDE.
    It also allows for some some nice formatting (reports that actually look like they are not from the 1970s!).
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.1.4.4, Application RL 9.0
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.