About the Community

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 

Hi IFS TeamI was thinking, say, when someone searches through the IFS Community, can the KBs also show up? I am referring to the search results in this link. Knowledge Base - Service CenterIt would be great if you can make them linked. At least for known errors, it would help us, customers, that a fix is planned in a SU for a future version. Thanks,Asela 

I would like to create a quick report that allows multiple WO_NO entries.Unfortunately, I get the error message‘You may only specify a single value for the Report Parameter: Work_Or’.I have tried thousands of variations, but nothing works.However, the condition ….AND woco.wo_no in (54046, 54037) works.

Hello all.Hey everyone, my former colleague who has left out company had a macro that allowed him to scroll up and down in the dropdown menu without having to click on each item. He said his former boss made a macro for him. Can anyone tell me where to change this?I know already you can hold down ctrl and then up/down arrow. I find it more convenient to use mousebuttons.   

We have identified a performance issue for a customer, FACT_PROJECT_CONN_DET is taken 3 + hours to do internal IFS data mart refresh. The Refresh for FACT_PROJECT_CONN_DET is taking 3+ hours to run on each refresh. They have set a separate refresh category to run this overnight, but as they informed it is now impacting their month end process as they cannot run data mart jobs in parallel. With the timely manner performance issue got worse up to 9+ hours with the growing data load of 7+ million in the environment.Note:Highest time-consuming SQL query running when refresh data mart for FACT_PROJECT_CONN_DET.INSERT INTO PROJECT_CONN_DET_MVTSELECT * FROM ( SELECT F.*FROM PROJECT_CONN_DET_MVS FWHERE ((F.PROJECT_ID) IN (SELECT P1.PROJECT_ID FROM T1512369F9074D569E0635904F_TAB P1))OR ((F.ACTIVITY_SEQ_KEY) IN(SELECT A1.ACTIVITY_SEQ FROM S1512369F905BD569E0635904F_TAB A1))OR ((F.ACTIVITY_SEQ_KEY,