About the Community

Issue: In the report designer, I have four fields. Only one field contains data; the other three are blank and do not display even 0 in the output. When I sum all four fields, the result shows NaN.Requirement: Remove NaN and display the sum as the value from the field that actually has data.

We cannot access the URL listed in the performance issue checklist attached to the article below.Please correct the URL and update the checklist. Checklists for Performance Issues: Best Practices | IFS Community CSXXXXXX - Checklist_For_Performance_02.docxCS234567-Checklist_For_Performance_01.docx

Hi,our project team has a problem with time reporting in a project. There is no problem to add work time on the 'Day' tab, but on the 'Week' tab the system does not allow to add time. I have given all permissions. I also have the same message on the IFSAPP user. Reporting work time on the 'Week' tab would be much faster. Now we have Update 17.Please help.RegardsDaniel 

Community, We are scheduling a Inventory Period Statistic Report, it is scheduled on the 1st day of each month. Our inventory statistical period is created on each month basis. We would like system to fetch dynamically on Parameter Period. If it is running on Dec.1, 2025, then 12 should be feched to paramter Period field. What function/SQL statement we should us in field Period? Thank you. 

Hi,The following code works in the database when run.select        COH.DATE_ENTERED,       COH.ORDER_NO,       COH.ORDER_ID,       COH.CONTRACT,       COH.CUSTOMER_NO,       COH.CUST_REF,       COH.C_DEPOT,       COH.STATE,       COA.addr_1,       COA.addr_2,       COA.addr_3,       COA.addr_4,       COA.addr_5,       COA.addr_6,       COA.address1,       COA.address2,       COA.address3,       COA.address4,       COA.address5,       COA.address6,       COA.zip_code,       COA.city,       COA.state,       COA.county from ifsapp.CUSTOMER_ORDER COH left join ifsapp.CUST_ORD_ADDRESS_2_UIV COAon COA.order_no = COH.ORDER_NOwhere to_date(COH.DATE_ENTERED,'dd/mm/yy') between to_date('&DATE_FROM', 'dd/mm/yy') and to_date('&DATE_TO', 'dd/mm/yy') and COH.ORDER_NO like 'H%'and COH.CONTRACT like '%' || upper('&SITE') || '%' However, when running the code in a quick report. I receive the following error:   

Starting from 27th November, all IFS Cloud remote customers who use Access Studio to manage security configurations within the IFS AI platform will no longer need to complete a separate login process.You can now launch Access Studio directly using your Lifecycle Experience Center (LEC) login credentials.

Hello,could you please advise me on how to perform a customer offset in IFS Cloud betweenan Parked customer payment (CUPOA) and an advance invoice?In IFS 10, I could use the job Customer Offset, but in IFS Cloud, in the job Customer Offset Proposals or Netting, the system reports that “Advance invoices are not allowed.”Thank you in advance.Jaroslava

Hi,Has anyone worked on the IFS Estimator tool and is there any guidance available readily for using the same.

HiI am using IFS applications 9. I am receiving the below error massage although control plan for the part is properly done and active. Understand that this issue came up only upon an update in the part BOM revision. Currently unable to create Shop order.Would like to seek assistance on how to resolve this issue. Greatly appreciated. 

Not sure if I’m the only one but I completed the prerequisites for AR and AP course in IFS academy but will not let me purchase the learning for these courses

Hi,  Does anyone know if it is possible to set Quick Report outputs to come out in csv file format rather than xlsx.  Thanks

We have used the OpenFile AgetnCall command to open files from a local folder, but it seems to open files from some folders while failing to open files from others. Could you explain the constraints of this command, as the documentation does not provide detailed information?

Has anyone discovered how to update the Won/Lost reasons on a Sales Quotation after it is closed?  The sales teams do not always know the reason at the time but want to track this data.  What is the logical explanation from IFS why this is locked down?

Hello, I have a materialized view that is populated by the following code (see the File attached However, in the table source  INVOICE_ITEM_TAB I can’t find the record where the creator =  ‘'CUSTOMER_ORDER_INV_HEAD_API’. Need Help Please , thank you

HiI am trying to set up default value for Price Unit field/Invoiceing/Servive contract but when I test to create a new service contract the value is not shown. Could someone help me with this?   We have 24RSU2, thanks. 

Hi all,In App9, we can see the full user limit in License Metrics. In my case is 170. How can we see this info in IFS Cloud? From License Metrics in Cloud, i can only see the “IFS users that consume a full license” instead of the total license we have.Thanks.Regards,Zhan Hao

I'm looking to enable or disable a command in IFS Cloud based on the rows selected by the user. Specifically, if the user selects multiple rows (e.g., 2 or 3), I want to check whether all the selected lines have the same value for a specific field, like the address. If they do, the command should be visible; if not, it should be hidden or disabled.Can anyone guide me on how to implement this in IFS Cloud?

The login page loads successfully, but after entering credentials, the browser stays stuck on the loading spinner — the IFS application never launches.  When accessed directly from the IFS Cloud host server, it logs in and loads very quickly. From local systems, it often hangs on loading after authentication.  

Hi There, Can someone please help here where we got this this issue on our IFS with 2 users.  This is the  Error  Dump Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.Explorer.Interfaces.FndFeatureNotFoundException: Navigation target  is not to be found in the dictionary   at PPJ.Runtime.Sql.SalSqlError.InitializeSqlException(Exception source)   at PPJ.Runtime.Sql.SalSqlError.Initialize(Exception source)   at PPJ.Runtime.Sql.SalSqlHandle.HandleException(Exception e)   at PPJ.Runtime.Sql.SalSqlHandle.Execute()   at Ifs.Fnd.ApplicationForms.cSessionManager.DbExecute(SalSqlHandle hSql)   at Ifs.Fnd.ApplicationForms.cDataSource.DataSourceExecuteSqlRecordList(SalWindowHandle hWnd, SalString lsStmt)   at Ifs.Fnd.ApplicationForms.cFormWindowBase.DataSourceExecuteSqlRecordList(SalWindowHandle hWnd, SalString lsStmt)   at Ifs.Fnd.ApplicationForms.cFormWindowBase.vrtDataSourceExecuteSqlRecordList(SalWindowHandle hWnd, SalString lsStmt)   at Ifs.Fnd.Appli

Can we add images to show  as new icons against the drop down in group header? 

Can we  show name and store location in the header in a page like below mentioned page or can we add fields in label

If "IAM Session and Tokens Configuration" "Sessions" and "Session Idle" of IFSCloud are changed to "62Minutes" and "Session Max" to "64Minutes"  logging in from 1, "Session Idle" is "62Minutes" and "Session Max" is "64Minutes" for logging in from 1, but they are not relevant for logging in from 2. Is the recognition correct?In the article "KB0065296", the following is described as "SSO_" as in "SSO_SESSION", but I would like to confirm that it has nothing to do with logging in from 2. "KB0065296"IFS Product - Not possible to alter the system parameter "Time a session is allowed to be idle before it expires"SSO_SESSION_IDLE - Time a session is allowed to be idle before it expires.SSO_SESSION_MAX - Max time before a session is expired. 

Hi,I would like to revoke the time reporting for Work tasks and Project in “My time registration”. Additional I would like t revoke the time reporting for attendance except Wage type “Information”. Goal should be, that it is only allowed to register attendence with wage type “information” in the mask “My time registration”     

We currently have an archiving setup in our MWM environment, and we would like to understand how IFS set up the archive. Any information on this would be much appreciated.Thanks, 

Hi,I want to put default value = Tax on Taxliability field in Business Opportunity lines but I don’t find Default value set up in Page designer. I have seen and done it on some other fields on other pages but I don’t find it in this case. Does someone know if there are other options to fix it? We have 24R2SU2, thanks.