How an application program can retrieve invoices from a spooled file, convert those spooled files to PDFs, and e-mail them to the relevant customer?

195 pts.
Tags:
AS/400
AS/400 Spool Files
PDF
How an application program can retrieve invoices from a spooled file, convert those spooled files to PDFs, and e-mail them to the relevant customer? Reff: Pg 1, https://www.redbooks.ibm.com/redpapers/pdfs/redp4324.pdf
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
It can be done, but there is a bunch of set up that needs to take place. You may need to change your spool files to break on customer so you can send the entire spool to one address. We use PDFing software with great success. Basically you need to have a map of your spool so the app know where the PDF is to be sent. This may be something like embedding the email in the spool file it it’s going to individual customers. If it’s something like a specific report you can do it something like this
IF         COND(%SST(&PDFING 84 10) *EQ 'PRDCODENET') +  
             THEN(DO)                                    
CHGVAR     VAR(&EMAIL) VALUE('EMA=MRBILL@SNL.COM') 
SNDTCPSPLF RMTSYS(*INTNETADR) +                          
             PRTQ(&EMAIL) +                              
             FILE(SAPRNT) JOB(&JOBNR/&USRNM/&JOBNM) +    
             SPLNBR(&SPOOL) DESTTYP(*AS400) +            
             TRANSFORM(*NO) INTNETADR('10.10.80.11')       

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • azohawk
    What is your question?
    4,055 pointsBadges:
    report
  • WoodEngineer
    We do the same using one of the tools from Gumbo Software. The tool is reasonably priced. Good support from the Gumbo folks.
    In the utility you specify where the invoice number is found in the spool file plus a program you want to call for every invoice number found. Your program can then lookup the required information about the invoice and return the e-mail address for that invoice. It works great. Minimal programming. It will save you a lot of time.
    8,225 pointsBadges:
    report
  • ToddN2000
    Some of the purchased PDF tools will let you map the spool data into a custom form you design. It takes some initial set up but has excellent results. We currently process customer invoices, statements, purchase orders and employee direct deposit forms using this method to name a few.
    134,700 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: