Hello @Sahan Udana Thanks for your reply. I have media arching setup - however the CLU’s that I am trying to move to Azure have not moved despite me setting the job as follows: Should I be using another method such as Data Archive Objects ??
Issue has now been resolved
Hi @dsj, Yes, that works - I am using the &PDF_FILE_SENT_TO attribute.The issue that I am getting is that the user is getting two emails - the newly formatted one and the system default one.
Hi @dsj Code below:
Hi @dsj When I use the report rule route the email address was not available for me to update my custom table.I am at a loss as to where to go with this now, I am a novice at this as you can probably tell.
Thanks @dsj What you have described is exactly what I am after.How do I code the following ?In that situation, you could use the Print option and select the Printer NO_PRINTOUT from the printer list. It will generate the PDF and trigger the PDF_REPORT_CREATED event and could avoid the additional email.
Hi @Buddhika Kurera Thanks for your response. What you suggested is what I did and it works well to update my custom table. I have also included code to rename the PO attachment and send the email.The issue that I am now getting is that I am receiving 2 emails:The renamed PO attachment email and the system generated email.How do I stop the system generated email ?? Thanks in advance
Hi @dsj Perfect, fixed my issue
DECLAREinfo_ varchar2(200) :=null ;email_addr_ VARCHAR2(2000) :=null ;file_name_ varchar2(32000) :=null ;email_body_ VARCHAR2(2000) :=null ;error_message_ VARCHAR2(32000) :=null ;attachments_ ifsapp.COMMAND_SYS.ATTACHMENT_ARR;CURSOR get_invIsSELECT po_ref_number, invoice_id, company, invoice_no, ifsapp.purchase_order_cfp.Get_Cf$_Buyer_Name(ifsapp.purchase_order_cfp.Get_Objkey(ifsapp.man_supp_invoice_api.Get_Purchase_Order_Ref_Number(company,invoice_id))) Buyers_name, ifsapp.purchase_order_api.Get_Buyer_Code(po_ref_number) Buyers_code, dr.doc_class, dr.doc_no, dr.doc_rev, dr.doc_sheet, edm.file_data, edm.doc_typeFROM ifsapp.POSTING_PROPOSAL_INV_OVERVIEW pp Left Outer Join ifsapp.doc_reference_object dr On dr.Lu_Name='ManSuppInvoice' and dr.key_ref = 'COMPANY='||company||'^INVOICE_ID='||invoice_id||'^' left outer join ifsapp.edm_file_storage edm On edm.DOC_CLASS= dr.doc_class and edm.DOC_NO = dr.doc_no and edm.dOC_SHEET=dr.doc_sheet and edm.DOC_REV=dr.doc_revwhere message_id='No
Hi @dsj
Hi @dsj ,Thanks for you comment, however I am unable to access this link as it is for selected users. Need assistance for sending emails with attachments triggered by an event. (23R1) | IFS Community I have written the code and it appears to mostly work, however if a PO does not have a document to be attached it adds what was on the previous email. Is there a way to clear the attachments array after the email have been produced and sent ? Thanks in advance
This is now resolved
Hi @Marcel.Ausan I did do that, but my first event action kept failing
Hello @ashen_malaka_ranasinghe I have the following events:This one logs who the PO has been emailed to Email the PO to recipient Thanks
Hello all,Silly mistake I have found the problem
I have found the issue, I had a with statement which I have removed
I have found that I can do this using the following syntax which returns a date, i also want to add the time 0600 hours is that possible ? ifsapp.accounting_period_api.Get_Until_Date_For_Year_Period('102',ifsapp.accounting_period_api.Get_Acc_Year_Period('102' ,Add_Months(to_date('10/'||(extract(month from sysdate))||'/'||(extract(year from sysdate)),'dd/mm/yyyy'),-1))) + 4
Hi Avindu, Thanks for the response.I have created the field as suggested but when I come to add it it still is not showing - do you know why this would be ?? ThanksJannette
The screen is the purchase receipts history as shown in the original message screen shots
Hi Imalka,I tried that and then got the original error message
Hi ImalkaWhen I did that, I now get this error message :
Hello, I have the following code that works with no issues in Apps8, however in Apps 10 gives a mutating trigger on VOUCHER_TAB. How can I overcome this please ? Declare account_ number; count_ number; BEGIN select count(*),LISTAGG(account, '; ')WITHIN GROUP (ORDER BY account) into count_, account_ FROM ifsapp.voucher_row where company = '&NEW:COMPANY' and accounting_year = '&NEW:ACCOUNTING_YEAR' and voucher_type = '&NEW:VOUCHER_TYPE' and voucher_no = '&NEW:VOUCHER_NO' and (substr(account, 0, 4) = '9000' or account = '13009000') and '&NEW:APPROVED_BY_USERID' not in (select pia.user_id from IFSAPP.company_pers_assign cpa left outer join ifsapp.PERSON_INFO_ALL pia on cpa.emp_no = pia.person_id where cpa.valid_to >= sysdate and cpa.pos_code in (select cpp.pos_code from COMPANY_POS_PROPERTY_ALL cpp where cpp.property_code = 'VOUCH_APP' and cpp.PROPERTY_VALUE = 'TRUE')) and '&NEW:APPROVED_BY_USERID' <> 'IFSAPP'; if co
Please see attached my issues
Hi Daniel,Thanks for your response, how do I make the part as ‘In Inventory’ ?Cheers
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
