Solved

Hello, How can I update data in one column without using UPDATE statement? In this column I have some date values in format for example 01-DEC-24, or 03-JAN-23 but also some NULL values and I want to change those values to null with using SELECT statement, but I am not sure how can I change the data in existing column. My SQL command works but I am not sure if I can update existing column in entity configuration through + icon. Thanks

Hi, We are experiencing a DB_SWITCH issue similar to another posted earlier and marked resolved except that in our case, there is a minor a minor difference in the error message, instead of ORA-01017 we get ORA-00022. We've tried the solution proposed in the other topic without success, all our accounts are granted connect. The issue is intermittent and after one or more attempts, our users are usually able to get in. Although i say it is intermittent, the error is experienced quite frequently and we have yet to identify the cause for this error. Here is the full message message: Any help would be greatly appreciated.

Good day.  When adding Expenses on a TR/Expense Sheet, two of the fields that are available are Price and Quantity: However, when you Add an Expense, nowhere are these fields available to populate: An example of a type of Expense where this would be useful is Accommodation - let’s say 3 nights @ X amount, and for the total to then be calculated. Anyone who can help in this regard? Thank you. Anya

Good day.  Is it possible to add a note as to why a TR was Rejected?  We have set up Detail Approval on the TR Configuration.  However, once the Manager has approved/rejected the TR, it disappears from the page without being able to provide a reason/note/comment.  Any suggestions in this regard? Thank you. Anya

Will there always be MRP make entries in MRP Part Information and Inventory Part Availability Planning for phantom parts? I guess they are needed for the correct explosion of demands to the next level, but users think it is confusing since they will not create any shop order requisitions.

I am having the below issue in Edge.  I am up to date on Edge updates.  I have this issue on multiple computers and in all of our environments.  Another user has the same issue and a third doesn’t.  Does anyone know of what may be causing this issue?  I do not have the issue in Chrome.   

Hi any idea what would be the api we need to write to pull data when the stop code is “resolved “ im able to pull data when the stop code is “waiting for parts”  with the below , but dont get any jobs with resolved stop codes. Thanks in Advance. <root xmlns:dt="urn:schemas-microsoft-com:datatypens"><session email="" alias=""><state bc_name="service_order"><action name="execquerynolimit"><attribute in_var="" out_var="QueryOutVar" entity_name="service_order" query_name="service_order_scrl"/><attribute dtype="string" in_var="" name="cust_company_id" value="test" operator="="/> <attribute dtype="string" in_var="" name="last_stop_code_id" value="PARTS" operator="="/> </action></state></session></root>

I have this load error ‘ The bank account xxxxxx is not valid for Supplier xxx in Company xx.’Anyone know which part went wrong?

Hello, We are facing a huge issue, in our test and config environments, we cannot inspect workflows anymore, even if they only have a simple projection call in it. When inspecting, we just get the “loading” popup that never goes away. This is on 23R1 and so far, it seems like no one else has been experiencing this other than us. What could be causing this? We’ve refreshed the caches in hopes of resolving this issue but so far nothing has been working. Any and all insight would be very much appreciated. Thanks,Bryan

We are in the middle of completing our first Service Update. We got to the part where we are now waiting for the Sanity Build to be completed.The next steps in our training guide mentions “usual delivery process” after the Sanity build is complete, however we have not done a delivery before.I am trying to find documentation or steps that we need to do during the “delivery process” after a service update.Do you know where I can find that or what the “delivery process” is after a Sanity build is complete for a Service update?

In any version, is it possible to determine if a shop order was the result of a comprehensive shop order split?

How can I set a conditional formatting with the condition “is empty” in the cloud (23R2)? What is the correct syntax here?Thank you!Catherine

Hi,I am developing an integration where the service user connected to and IAM client needs access to all projects in IFS Cloud, restricted or not. Don’t know the project module in IFS Cloud that well but is there another way of granting access, other than the below steps?Creating an employee connected to the service user Adding that employee to a Team Adding all projects in access definition of that Team Setup an event action/workflow that adds access for every future project created I’m using standard projections. 

Hello experts in the Community,I have a requirement to create an “Application for Payment (AFP)” from a ‘Sales Contract Revision’ that has 2 lines with two different “Item Sales Currency’ values (CAD and USD). Expectation is to create the AFP with CAD where USD line to come in with CAD converted equivalent values.  When attempting to create an AFP via “New AFP” dialog box IFS makes it mandatory to select a ‘Currency Code’. In following example, I selected “CAD” as the “Currency Code” as I want to create the AFP in CAD. In the resulting AFP (Application for Payment) only the line #2 and respective Item has made it across to the AFP, which had the “Item Sales Currency” set as “CAD”. Whereas Line #1 and the connected item that had “USD” as the “Item Sales Currency” has fallen off from the Application. I am not 100% if this is working as designed or I am missing a setup/configuration to get to the desired result. Thanks a bunch for your support! :) Background InformationIFS Version: IFS Cl

Hi team,Is it possible to add a custom field to below screen. The entity shows as CreateReturnStruct. But it cannot be searched in IEE entity details.   If possible, please let me know how I can add the CF to this screen. Thanks much.

I am trying to import an IFS REST - Partner Connector Operation I am receiving a “Unable to browse connector: Projection not found, or not Included in Compatibility Application Type”.Our Connector is currently using OAuth 2.0. Although. I have also tried using basic authentication and I am getting the same error.I have also tried using “GET” and “QUERY” but both are giving me the same error.I’ve tried the call in Postman and it works perfectly fine.I’ve also checked the API Explorer in Cloud. I found the UserHandling projection. It’s status is “Active” and I don’t see an option to “Include in compatibility Application Type” which is what I used to do when activating an Aurena API for our APPS10 instance.Is there another step that I am missing?

Hi everybodySince yesterday at midday, all ours printings in direction of one specific printer stay systematically in Remote Waiting.Notice that :- the printer is a network printer and works perfectly (it's possible print from another application).- the printer agent has been restarted few times, and run.- PDF reports are correctly generated.- We remarked that the printer in default, stopped works after it was in error of printing, resulting of version change of the printer during the printing.Thank you in advance for your help. 

Hi Community, If we calculate the currency revaluation for the whole year at the end of period 12 instead of monthly, is there any system issues? Would the system allow it? I had couple of testing and noticed that for Balance sheet accounts total balance is revaluating.Appreciate your support on this. Best regards,Thakshila

Hello community, I have a question please about Payments, we have a list of migrated invoices, and we want to update their statuses in bulk to 'Paid'" statuse, is there a way to do that ?Thank you in advance !

In shop order operation using IFS Apps10 we have assigned the operation to 2 employees with different labor class. I found that in estimated cost for the shop order the labor cost is taken from the labor class of operation line level and not from assigned employees. how this point can be resolved?Thank you.

Hi , Can we check who created the quick absence in system any log screen is available ?  ​@ADDMARIAE 

We are currently using IFS Apps 9. After updating one of our users' laptops to Windows 11 Pro, we noticed that the text boxes in IFS Apps have changed. The borders are now grey and underlined, instead of the traditional black outline they had previously in windows 10. Windows 11:Windows 10  Is there a way to revert this change and restore the original appearance of the text boxes in Windows 11?Thanks in advance!

Hi everyone,I’m currently facing an issue with Excel migration where empty values from the Excel sheet are overwriting existing data in our IFS application. Specifically, I want to prevent fields from being updated with empty values. For example, if the “DUNS No” field (column F) is empty, I don’t want it to overwrite the existing value in the application.Here’s a simplified example to illustrate the problem:Example Data: ID Name Address City Country DUNS No 1 Company A 123 Street Kraków Poland 123456 2 Company B 456 Avenue Warsaw Poland   3 Company C 789 Boulevard Gdańsk Poland 789012  In this example, for row 2, I want to update the application with the data from columns B-E for the corresponding ID, but leave the “DUNS No” field unchanged if it is empty, regardless of whether data exists in this field in the application or not.Has anyone encountered a similar issue or have any suggestions on how to handle this in the migration process?Than

I have a condition on my or gate, when value is not null then …The condition is not respected, any idea why please?   Thank’s in advance

Hello I am trying to Uncheck the “Use Predefined Pack Size” field to have my configuration but it’s not editable in this view. Path: Procurement > Receipt > Receipt > Details > Print > Print Barcode Labels