Solved

Automate Purchase Order PDF Email

5 years ago
December 11, 2019
30 replies
5999 views

+11

GPIE
Hero (Customer)
113 replies

Hi all,

In IFS10 UPD4 I have developed an automated process to take an authorised Purchase Requisition, convert it to a Purchase Order, release it and then email the requisitioner with the order details. I would like to attach a PDF copy of the PO (or send one from another Event Action) but have not managed to figure out how to do it.

I have an Event configured against the PURCHASE_ORDER_TAB table that triggers when the PO is Released and then an Event Action E-mail to inform the requisitioner, but there are no Event linked attachments available to attach.

Does anyone know how to code the printing and emailing functionality?

Thanks in advance,

Ged Pierce.

Best answer by GPIE

This code can be run to both generate the PDF parameters and send the PDF in one hit, to either negate the need to create the PDF parameters or to override the existing PDF parameters. Note the expansion of the ATTR_ data.

Now it would be nice to be able to change the email subject and body.

DECLARE
 LAYOUT_NAME_ VARCHAR(2000):='PurchaseOrderPrintRep.rdl';
 REPORT_ID_ VARCHAR2(2000):= 'PURCHASE_ORDER_PRINT_REP';
 REPORT_ATTR_ VARCHAR2(2000):= '';
 PARAMETER_ATTR_ VARCHAR2(2000):= '';
 DISTRIBUTION_LIST_ VARCHAR2(2000):= '';
 INSTANCE_ATTR_ VARCHAR2(2000):= '';
 PRINT_JOB_ID_ VARCHAR2(2000):= '';
 PRINT_ATTR_ VARCHAR2(2000):= '';
 PRINTER_ID_ VARCHAR2(2000):= 'PDF_PRINTER';
 PUR_ORDER_PRINT_OPTION_ VARCHAR(2000) := 'Order';
 --PUR_ORDER_PRINT_OPTION_ VARCHAR(2000) := 'Order Work Copy';
 ORDER_NO_ VARCHAR2(2000):= ORDER_NO;
 RESULT_KEY_ VARCHAR2(2000):= '';
 ATTR_ VARCHAR2(2000):= '';
BEGIN
 REPORT_ATTR_:= 'REPORT_ID'||CHR(31)||'PURCHASE_ORDER_PRINT_REP'||CHR(30)||'LAYOUT_NAME'||CHR(31)||'PurchaseOrderPrintRep.rdl'||CHR(30);
 PARAMETER_ATTR_:= 'ORDER_NO_LIST'||CHR(31)||ORDER_NO_||CHR(30)||'PUR_ORDER_PRINT_OPTION'||CHR(31)||PUR_ORDER_PRINT_OPTION_||CHR(30);
 ARCHIVE_API.NEW_CLIENT_REPORT(RESULT_KEY_, REPORT_ATTR_, PARAMETER_ATTR_, DISTRIBUTION_LIST_, PRINT_ATTR_); 
 ARCHIVE_API.GET_INFO(INSTANCE_ATTR_,PARAMETER_ATTR_,RESULT_KEY_);
 ATTR_:= 'PRINTER_ID'||CHR(31)||PRINTER_ID_||CHR(30)
 ||'SETTINGS'||CHR(31)||'!FNDINF.SEND_PDF
 $SEND_PDF=TRUE
 $SEND_PDF_TO=gerrard.pierce@unipart.com
 $APPLY_DEFAULTS=FALSE
 !PDF
 $PDF_ARCHIVING=TRUE
 $PDF_EVENT_PARAM_1=
 $PDF_EVENT_PARAM_2='||myline.vendor_no||'
 $PDF_EVENT_PARAM_3='||myline.contract||'
 $PDF_EVENT_PARAM_4=
 $PDF_EVENT_PARAM_5=IFS APPLICATIONS
 $PDF_EVENT_PARAM_6='||myline.order_no||'
 $REPLY_TO_USER=IFSAPP'||CHR(30);
 PRINT_JOB_API.NEW(PRINT_JOB_ID_,ATTR_);
 CLIENT_SYS.ADD_TO_ATTR('PRINT_JOB_ID',PRINT_JOB_ID_,INSTANCE_ATTR_);
 CLIENT_SYS.ADD_TO_ATTR('RESULT_KEY',RESULT_KEY_,INSTANCE_ATTR_);
 PRINT_JOB_CONTENTS_API.NEW_INSTANCE(INSTANCE_ATTR_);
 PRINT_JOB_API.PRINT(PRINT_JOB_ID_);
END;

View original

Did this topic help you find an answer to your question?

Show first post

Page 2 / 2

+12

SimonTestard
Hero (Customer)
256 replies
7 months ago
August 12, 2024

Mounika wrote:

SimonTestard wrote:

Hey,

It would be done with this part of the cursor:

-- Doc Man
for doc_man_rec_ in (

select i.doc_class, i.doc_no, i.doc_sheet, i.doc_rev, e.file_no, e.user_file_name, e.doc_type, s.file_data
from ifsapp.doc_issue_tab i 
left join ifsapp.edm_file_tab e on e.doc_class = i.doc_class and e.doc_no = i.doc_no and e.doc_rev = i.doc_rev and e.doc_sheet = i.doc_sheet 
left join ifsapp.edm_file_storage_tab s on s.doc_class = i.doc_class and s.doc_no = i.doc_no and s.doc_rev = i.doc_rev and s.doc_sheet = i.doc_sheet and s.doc_type = e.doc_type
where i.rowstate = 'Released' and s.doc_type = 'ORIGINAL'
fetch first 1 rows only 

) loop

When you get the Purchase Order to Print, through the PDF_REPORT_CREATED event, you’ll get several parameters like result_key, print_job_id, etc.

From those parameters, you can retrieve the Purchase Order_No

Typically I do it like this:

From the Order No, you can then check documents attached to header/lines through the DOC_REFERENCE_OBJECT view/lu, based on the KeyRef:

Example here is for PurchaseRequisition but can be changed to PurchaseOrder or anything else to grab any attachment to any IFS Object.

This will give you the Document Keys to use to filter in the main cursor to grab documents attached to a given PO Line/Header

Hi @SimonTestard

This code is to fetch the documents. But how can we send them to the printer?
For example, as soon as we send the PO report to physical printer, then we should also send these documents to print immediately along with the report. Is this possible?

I’m not exactly sure as this is to fetch and EMAIL Documents, if you want to send them to a printer, you’d need to add code to send them to a particular printer if what you’re after is a physical print :)

Are you actually after a PHYSICAL print of the attached documents ? This entire thread was about automatically emailing documents so I’m a bit confused.

You don’t need to PRINT attached documents if what you’re after is emailing them.

Mounika
Sidekick (Partner)
31 replies
7 months ago
August 12, 2024

Hi @SimonTestard ,

Yeah, you understood it right. I want them to be sent to physical print that too immediately after the order report print, so it is almost like attaching the documents to the report and printing them all at once as a single report.

This post is about emailing documents, but I hoped that since you worked on logic to fetch the documents, then may be you might also know about printing them.

+12

SimonTestard
Hero (Customer)
256 replies
7 months ago
August 12, 2024

Sorry, can’t say I’m familiar with which API one would use to send a document management revision to a particular print agent, if it’s even possible.

The Print Job and Print Job Contents LUs are basically linked to result keys and therefore to Operational Reporting, so I don’t think you can use those to request a file print to a logical/physical printer through the print agents, but I could be wrong or not know how to do it

You could possibly do it through an Application Message using Routing Rules / App Message Queues and so on, but that’s not something I’ve done before

Mounika
Sidekick (Partner)
31 replies
7 months ago
August 13, 2024

Hi @SimonTestard ,

Understood. Thank you for all the info you shared so far!

+16

hhy38
Superhero (Customer)
318 replies
4 months ago
November 12, 2024

@SimonTestard Thank you for the script. It is beneficial

Linkedin Profile: https://www.linkedin.com/in/hhy34/

Page 2 / 2

Reply

Rich Text Editor, editor1

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

Cookie settings

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos

Reply

Related Topics

Automate printing of Purchase Requisition pdficon

SENDING THE REPORT (WITH TRIGGER) AS MAILicon

Custom Menu for Multiple rowsicon

Sending a automatic print job from an eventicon

How to config a IFS printericon

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings