About the Community

Dear Heroes,I want to create an Execute Online SQL type Event Action to a particular table. I want to fire the event when the Rowstate column value equals to “Cancelled or Returned” both. How should I give the Conditions.I gave this like below. But it’s not workingNEW:ROWSTATE = Cancelled;Returnedhow to do this???

Hi,I tried to hide a colum “Proj Activity Seq No” in Page Configration so it applys to all user at my company but I can not find where to configure in Page Desinger in this pop upp window.  The column you find in Posting Proposal/ klick on View Cost Postings then pop up window call Cost postings. I opened Page Designer from Posting Proposal and tried to find where I can configure the pop up window but need help to find, thanks. Please note that we know that we can hide from Cloumn chooser but since this is valid only one user, we want to push to all user so that why we want to do this in Page Configration.  We have 24R2SU2. 

i want the tool thank you

Hello everyone,I'm experiencing an issue using the JSch library to establish an SFTP connection with an OpenSSH server configured on Windows. The error returned is com.jcraft.jsch.SftpException: Bad message.Here are some details about my setup:SFTP Client: JSch version 0.1.54 SSH Server: OpenSSH for Windows version 9.5Complete error message: com.jcraft.jsch.SftpException: Bad messageInterestingly, I can successfully connect to the same OpenSSH server using GUI clients like FileZilla and WinSCP, but the issue arises specifically when attempting to connect from our middleware server using JSch. Has anyone else encountered this type of error or have any suggestions on specific configurations to check or modify on JSch or OpenSSH?Thank you in advance for your help and suggestions.

dear All,any help?I want to calculate 8 fields and display the total in another fields

 The Q1 results for the IFS Community have been outstanding, thanks to the incredible contributions from all our members. We’ve achieved over 1.1 million page views, and our average answer time has improved by an impressive 30% compared to Q4 2024.🌟 Outstanding Contributors: Our community engagement metrics, which include points for posting replies, earning likes, and securing the 'best answer' label, highlight our long-time superhero ​@Mathias Dahl  leading the way, followed by ​@Alexander Heinze  and  ​@Abdul .🔝 Most Likely to Respond: ​@Mathias Dahl tops the list with 168 replies, followed by ​@Alexander Heinze  with 137 replies, and ​@Abdul  with 97 rep

Hii have question about app 9How to use IFS Middleware Server Admin Console in APP 9 ?how to setting ?What is it used for ? Thank you 

Can we stored emails as documents in IFS cloud ?  like say xxxxx.msg or 

I was wondering what the correct syntax is for the “starts with” operator. In the technical documentation, I’ve only come across the operator shown in the screenshot below.Does IFS Report Designer support “starts with” and “doesn’t start with” operators?I need to add a visible condition to exclude any records where CHARACTERISTIC_DESC starts with "B36", so they don’t appear in the report.Here’s what I’ve tried so far, but none of these worked:contains(tns:CHARACTERISTIC_DESC, 'b-36')  starts-with(tns:CHARACTERISTIC_DESC, b36)  starts-with(CHARACTERISTIC_DESC, b36)   I would appreciate any tips.Operator Description and Logical-and or Logical-or not() Negation = E

I have successfully created a datamapper and channel in ETM 11.8 to try and update the user Contact Manager, however, although it appears successful when I run the import, but nothing is updated and all I get is ‘Record to Update’ value not found.The datamapper is like this, although I have tried various derivatives and still get the same result - can any one advise me what I am doing wrong? Thanks 

Hi,I am having an issue when adding a Global Command using Page Designer for an overview (table) window in IFS Cloud. (24R2)When I add the command to the header section, it still requires me to select a record for the command button to be enabled.My goal is to have the command button visible and enabled at all times, regardless of whether a record is selected or not. I also tried adding the command within command groups, but that didn’t work either.Has anyone managed to achieve this? Any guidance would be appreciated.    

Hello, I have a custom menu which runs a crystal report via a quick report passing it a parameter.  Is it possible to do the same and add an extra step which will send an email to the user requesting the report.Thanks

Hi I have to upgrade IFS Application 10 to IFS Cloud when install completed . I found  all namespece status is pending . Please suggest how to check root cuase.Please see as attachment. Database convert from non-cdb to cdb and plugin pdb database. Run install.tem for change to upgrade version.

Does IFS Cloud provide any SFTP as SAAS service?It does not make Sence to use external SFTP server when I am using IFS cloud services, I would be expecting that it should be an additional service that is running on IFS cloud infrastructure. Thank you

Hi,A question about Academy SCM Knowledge Check, what is the status of Inventory Transaction Report Status? I currenly only work on APP10, so I guess the IFS cloud changed the status.from the question selection, “Created”, “Printed”, “Processed”, “Cancel” are the options available. Thank you.

Hi allMy Lobby data source always provides the results for the current and the previous calendar week in the Lobby element.Now, when you click on a row in the Lobby element, the respective calendar week should be considered as the result.If you enter 'actual week' in the navigator filter, it doesn't work, because it always filters only the current week, but never the previous week.How can the navigator filter be set so that it always refers to the row of the selected calendar week? In IFS10, this could be done using 'to_char(field, 'iw').Thanks and br

Good day, I review technical installation document for installaiton of IFS Cloud and would like to know if it is possible to install IFS Cloud on other Kubernetes flavour than microk8s such as regular Kubernetes or Azure Kubernetes Servers (AKS). ? Best regards

Hi everyone, I am experiencing some issues integrating Power BI into the IFS Cloud, I am new to using IFS and Power BI so any insight would be much appreciated.I am hoping to understand if the issues that I raise are either based within IFS or Power BI.Below, I will add images to show my process and where potential issues are coming from. [Image 1] - Inputting the URL.Have I correctly inputted the URL with the additional suffix? [Image 2] - Sign in button.Should this page come up if I am already signed into Power BI?

Howdy, Receiving this error when trying to record time to a project.  Position code for XXXX(employee id) is not valid for this account date.  Completely stumped! New to IFS! Any ideas? Thanks 

Hi allSome data field values are updated automatically without any user interaction, while others require manual confirmation by the user.Why is this behavior different, and is it possible to globally configure this behavior across all fields, so that an interaction is always necessary?Thanks and br

We are a new customer of IFS Cloud ERP.  I have a developer team that I want to register for IFS Developer and IFS Cloud.  How do I register these users?  Customer ID: 6000090886  

If my customer is using IFS App10 and still happy with version and did not want to upgrade to Cloud.  After 27 Mar 2025,do customers need to pay extended support, if they don’t need any support from Global Support. Kindly make it clear, so I can deliver the right information to customer. Rungtip M.

After I batch create users, I would like to find a way to mass update those user’s email. Does anyone have a suggestion or know how that can be done?

The following IAL query is accepted by the Developer, but I cannot schedule the update in the Configuration tool.  SELECT COMPANY,           CONTRACT,           INVOICE_ID,           ITEM_ID,           SERIES_ID,           INVOICE_NO,           DEL_IDENTITY,           DELIVERY_ADDRESS_ID,           VAT_CURR_AMOUNT,           NET_CURR_AMOUNT,           GROSS_CURR_AMOUNT,           ORDER_NO,           LINE_NO,           RELEASE_NO,           RMA_NO,           RMA_LINE_NO,           CATALOG_NO,           DESCRIPTION,           INVOICED_QTY,           SALE_UM,           INVENTORY_UM,           CALC_UOM_VOLUME,           SALE_UNIT_PRICE,           ACCOUNTING_PERIOD,           ACCOUNTING_YEAR,           COMP_CUST,           PART_PRODUCT_FAMILY,           OBJSTATE,           OBJSTATE_HEAD      FROM IFSAPP

I cannot respond to most of the thread on the forums :(  I used to be able to respond to any community post but I don’t see that option anymore