About the Community

HiI would like to create an event using Execute Online SQL in sending a email. has any one done it before. Regards  

As the authorisation of work tasks is possible in two screens (PREPARE WORK ORDER and WORK TASK TRANSACTION), the authorisation is carried out differently.In the PREPARE WORK ORDER screen, the Jt_Task_Transaction_API.Authorize function is executed; in the WORK TASK TRANSACTION screen, the Authorise__ function with the 'CHECK' parameter is executed first.If my event is called from the PREPARE WORK ORDER screen, my programming works, from the other window does not work. This is because the new status "Authorised" is already saved in the NEW:ROWSTATE variable in the PREPARE WORK ORDER screen, but not in the other case. There it is still "Reported". Is there a way to find out where the event is being called from? Here is my script in the event: IF '&NEW:ROWSTATE' <> 'AUTHORIZED' AND '&NEW:ROWSTATE' <> 'TRANSFERRED' AND NOT ('&OLD:ROWSTATE'

Hello IFS Community,In my company we are using IFS 9.0.20.0 version. When we made quick report and tried this report we are getting an issue. When we use WildCard in PL/SQL query, we get this problem when we click the export to excel button from quick report. PL/SQL query is “SELECT order_no,       customer_no  FROM customer_order WHERE customer_no = '&[M----]CNO'”And this problem exists in the image Do you have a solution for this issue?  Thank you, Muzaffer 

Hello, I want to know in ifs page designer how can I setup a field to a specific value per default.Let’s say I want in a “production” context to set the Selection field to “All” by default for every user.Best regards 

Hello all, We would like to ask the question to the wider IFS community that are running IFS APPS 10 (Release 23);If you have been utilising the Human Resources - Expenses Module.(EE)Expenses ModuleWhat has your end user experience been like? Did the setup of the module require bespoke modelling and/or integration? Do you utilise an mobile application to upload documents, such as IFS Trip Tracker 10? If you are not using this IFS module what other solutions are you using and are these integrable with IFS?  We would like/love to move away from historic Excel spreadsheets.. Thank you all for your time and kind attention,Your assistance and feedback on this subject would be greatly appreciated. Kind Regards

Is anyone else experiencing a system outage with Enterprise Explorer? “Cannot download the application. The application is missing required files. Contact application vendor for assistance.”

Hello,Previously our Calendar drop list in our assystNET form would have the Calendar and Clock.There was a requested change to have just the Calendar, which was implemented.My question is where do we find the combo Calendar/Clock or Clock list now? Thanks in advance.C.

Hi, It seems I can’t start a new topic for assyst. I’d like to ask a question but when I choose question or conversation, I can’t see Assyst as topicIf I choose idea, then assyst becomes visible. Is there something wrong? Thanks Best regardsEric

we are currently using IFS version9, and want to upgrade to latest verwsion.please eleborate any prerequeset of Software or hardware .

Does anybody know how to create a clone environment from the running IFS 7.5 production environment?I want a step-by-step manual. Thank you so much!

The IFS documentation indicates that Server 2019 is the only updated version(Link). Any follow-up mentions for Windows Server 2022 since then? If such a possibility exists, is it mentioned in an acceptable recommended source?

Can multiple voucher lines be extracted at once

I am creating a Lobby element for end users but it is not behaving.I have created a data element based on an IAL and I can preview it and I get data results as expected. When I try ro select Columns though, I have to manually type the names. They do not appear in the drop down to select, but manually typing does workWhen I try to use the data elemend in a List display object, it refuses to show data. I just get a green cross and no data.The user has access to the data. I have tried creating an IAL and a quick information and a view direct into the IFSAPP schema but the Display element still will not show any data and none of the methods will let me choose the field names from the Colums sectio.Does anyone have an idea why Element willnot display results

Hello to all,I just start to test quick reports and try to use crystal reports as quick report. I got already a rpt file which is working well in IFS but when I upload it in quick report and try to see the report I get thisthe release we use is IFS 23R2 cloud version…Thank you in advance.frédéric

Hello, I am currently having trouble with the SLA on one of the ticket types. The process flow for this type of ticket is as follows: User raises a ticket Ticket goes to line manager for approval if approved, then a task is created and resolved After task is resolved, the ticket is assigned to the Site Head for approval if approved, then it finally goes to the CEO office for approval. The only place where the ticket stops SLA is when the ticket is with the line manager for approval and during the other steps (after step 2 is approved) the SLA clock is running.My Questions: Q1. Is there any expression that can be used or any other way to have the SLA clock of the main ticket stop during the approval processes ? Q2. Is there any expression that can be used or any other way to have the Site Head Approval (Step 4) assigned to the Site head based on the office location selected on the main ticket. 

Hi   I have installed IFS Cloud 23.2 but when installation is complete but i can’t use IFSAPP to login the error rais “Invalid Username and Password” but i try senario as be low.Log in user IFSAPP wiht cmd. “sqlplus ifsapp/[password]@<database>  - Can log in normal Change IFS password - After change and try to login but show same error. Unlock IFS user - After unlock and try to login but show same error. Use IFSADMIN to login - This user can log in to IFS Cloud. Check IFSSYS status - status is active Additionnal checking name of certificate - i found certificate name show “Kubernetes Ingress Controller Fake Certificate”

#hashtag test

Hi, I have created a custom tab (not standard) on the purchase order view. It now appears as last, how can I move to be first or second in order? thank you in advance!

The red box is the item table.The blue box is the item header.A table block has been included in the item header.(yellow)I want the blue header to appear on every page when I break a page, and the yellow header to appear only when the content changes.I would like to know if there is any way to control this.

Hi,In the IFS Academy portal, when I pay for a course Under “Payment” it has the option to enter a purchase order no.Can two users enter the same PO number for courses that are purchased?Me and a colleague are taking courses but we have different logins to the portal.Thanks 

Is there any guidance on the types of requests that can & cannot be made via the IFS Service Centre? We have raised many ‘advice & guidance’ cases as Service Requests and we receive inconsistent responses to them. Sometimes the case owner is very helpful & other times we are told that a Consulting Request is required.Incidents & Consulting Requests are generally bit easier to define (i.e. it was working previously & now isn’t or seeking expertise to advise on new functionality/capabilities) but there seems to be a bit of a grey area between the around what is/isn’t covered by a Service Request. Some guidance on the limits of support would be useful.

Custom event and action not triggering in UAT environment when i was trying to do it manually or automatically but remaining environments its working good ,workflow used in custom action could anyone please tell me the solution for this ? in serial object screen two fields should be triggered and updated. one field(a column) is only when new value added in some other table (1table). another filed(b column) should be updated when the data newly added or modified from that respective table(2 table) but its not happening .

Dear ALL,We have a query regarding Remote Deployment - Use Place Implementation recomendation,Management Server - - Can we use the same server for CFG/UAT & PRODMiddle-Tire - - Can we use the same server for CFG/UAT & PRODDatabase Server - - Can we use the same server for CFG/UAT & PROD Thanks in advance.Regards,Vivek NR.

System Exception Error - -2146697208

The latest support policy mentioned product retirements.It states that the community and others will be notified.Do you know where they are notified?  --Excerpt from Suppoer Policy--. IFS will inform Customers (through IFS Community or other mechanisms) in advance when a Release of an IFS Application Software product is due to be retired.ｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰｰ