Hello, We have defined an Event that sends an email in Spanish with accents.The mail is sent, but all the accents disappear in the message.How can we show the accents in the message?. Below the Event Action:DECLAREv_From VARCHAR2(80) := 'aaa@XXXX.com';v_Recipient VARCHAR2(80) := 'bbb@XXXX.com';v_Subject VARCHAR2(80) := 'Nueva evaluación de proveedor';v_Mail_Host VARCHAR2(30) := 'smtp.XXXX.com';v_Mail_Conn utl_smtp.Connection;crlf VARCHAR2(2) := chr(13)||chr(10);msg VARCHAR2(1000):=NULL;BEGINmsg:='Se solicita realizar la evaluación de la orden de compra &NEW:PO_REF_NUMBER, con código de proyecto &NEW:PROJECT_ID. ' ; v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 25); utl_smtp.Helo(v_Mail_Conn, v_Mail_Host); utl_smtp.Mail(v_Mail_Conn, v_From); utl_smtp.Rcpt(v_Mail_Conn, v_Recipient); utl_smtp.Data(v_Mail_Conn, 'From: ' || v_From || crlf || 'Subject: '|| v_Subject || crlf || 'To: ' || v_Recipient || crlf || crlf ||
Hello,I would like to define a different path for each project we create in IFS and open the folder that corresponds to that path from IFS APP 9.Can we create a hyperlink?. I have created a custom field in the Project Menu to assign the path, but hyperlink option is only available for web or e-mail addresses.Due to I haven`t seen any option for hyperlinks, I would like to create a Custom Menu, “PL/SQL Block” type, to read the path defined in the custom field and open the corresponding folder.Which is the command in PL/SQL for opening a folder?. Best regards,Amaia
Hello,We want to post a customer invoice with withholding tax, but when we release it, the status sets to “printed” and we don’t see the way to post it.We don’t have this problems if we release a customer invoice without withholding tax, in this case the status sets to “ContabAuth”. This is correct. This is one example: We are working with IFS9.I will appreciate any kind of help.Best regards,Amaia
Hello,I want to cancel a manual supplier invoice that is posted. I use the “cancel invoice” option from RMB , but I get the following error message: How can I cancel it?. Thanks in advance,Amaia
Hello,I would like to register automatically purchase costs in the “Project cost registration -Non personal” window.When an expense sheet is authorized, automatically it is registered in the “Project cost registration - Personal” window. But, when a purchase order is invoiced or posted, it is not registered as a cost in this window.I could create an event, but I wonder if there is another way to get it.Best regards,Amaia
Hello,Working with events, I’m trying to get the value of a date type attribute and the result is a number, instead of a date.I’ve tried for different date type attributes and with different logical units and tables, and the result is always the same.For example:Logical Unit: ExpenseHeaderTable: Expense_Header_tabAttribute: CONFIRM_DATEWhen the event is executed, I get “1994” as a result, but it should be “16/10/2020”. Does anyone know how to resolve?.Thanks in advance,Amaia
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.