Solved

Dear community I am trying to use the Query Designer in IFS Cloud to create a list of Users and the Group they belong to, and this to facilitate our user management process.We are using IFS Cloud 23R2 and this screenshots shows the fields I want to output to the list: User Identity, eMail and GroupI’m struggling to define this query using the Query Designer. Any help would be very much appreciated.Thank you 

Hello, We are having a lot of active units of measure in our solution that we want do deactivate or hide for users when they are creating purchase orders.When trying to do that the error message “The field [Used in Application] is not valid for update for user defined codes.” appears.  Can we not get rid of these user defined codes? Please advice,Johan 

Hi,We are hitting 404 Not Found page while trying F1 help. Wondering if someone knows the solution? Thanks in advance

Hello everyone!I'm  display data from survey_result table on the request screen in a seperate tab,I'm able to fetch the data from survey_result and display it successfully on the request screen using UI Designer,But the issue is iam getting  all the data from survey_result for that Request ID. where as i want to display only some rows from that survey_result table based on survey_idHow can we add a filter condition on UI Designer by which we can get survey_result data for a specific survey_id on the UI Designer I've tried searching for solutions online, but I haven't been able to find anything that works for my specific scenario.If anyone has experience with filtering data in a mobile survey based on survey ID, I'd be so grateful for any advice or guidance you can provide.Thank you in advance for your help! I appreciate your time and expertise.

In the Units of Measure page there is the ability to create records in the Alternate Unit of Measure tab in the sub-panel, but how is this to be used, what is the intent of this feature? This is not related to the information found in the Unit Relationships - Conversion page.There is nothing in scenario 1.1.1.2 that mentions this feature.It’s a mystery.

Hello,We are looking to include a signed URL in our customer invoice emails so customers can securely go to the link to access our banking information.Wondering if anyone is aware if IFS can support signed URLs within the Body of an email?Any help is greatly appreciated.Thanks,Kyle

Hello everyone, Does anyone know if it is possible to invoice a maintenance intervention from the MWO? Best regards

We want to check whom has which page. We wrote this piece of code to get it.SELECT t.identity, person_info_api.get_name_for_user(t.identity) person, po_.*FROM fnd_user_role_runtime_tab t, (SELECT pog.po_id, pog.role, po.pres_object_type, po.pres_object_type_db, po.module, po.description, po.allow_read_only, po.layer_id, po.change_info, po.change_date, po.info_type FROM ifsapp.pres_object_grant pog, ifsapp.pres_object po WHERE pog.po_id = po.po_id) po_WHERE t.role = po_.role AND t.identity LIKE nvl('&USERNAME', '%') AND po_.role LIKE nvl('&PERMISSION_ROLE_NAME', '%') AND po_.po_id LIKE nvl('&PAGE_NAME', '%')ORDER BY t.identity, po_.role, po_.po_idBut, the description column is in English. We want to get page names in Turkish. I found FND_USER_R

Hi Community, A mistake has been made and a unit was scrapped using the available process in Inventory Parts in Shipment Inventory.The transaction description for this is: “Scrapped at shipment location” (transaction code PICKSCRAP - Scrapping in Shipment Inventory)Which is different from the transaction description the when you scrap from the inventory parts in stock screen: “Scrapped” (transaction code INVSCRAP - Scrapping in Inventory) On that last one, we have the ability to use the UNDO SCRAP INVENTORY PART to correct users errors. But seems that there is no options to UNDO from scrap from Invent Parts in Shipment Inventory (or similar). Is their possible to revert/undo when by mistake scrap a part/serial from Inventory Parts in Shipment Inventory? Thanks.Guillem

Is it possible to change the currency of the MAIN price book after customer have been assigned to the price book? 

Hi TeamI created a service contract with the below invoicing parameters;  However, I want to create a single invoice for the five selected periods below, but it always creates five separate invoices for each period.  Can someone tell me if there is any possibility to create a single invoice for the above period? If so, what functionality or settings should I enable?​​​​​​​

Hello there.DK Denmark.SK Slovakia.I have come across a challenge that I just can't solve.On the same site, we have a coordinated calendar with public holidays and holidays for PROD DK (PDK_HOL) and one for PROD SK (PSK_HOL).The individual WCs for DK and SK respectively are assigned their respective calendar.SK has decided around the summer holidays to only be closed for one week (29), but when I try to set the Need date on a specific SO to 12.07.2024, it moves the date back to 10.07.2024? 12.07.2024 is closed in DK calendar.All operations on the specific SO are WC in SK, so what it measures, I haven't been able to find out, so can anyone give an explanation?

A published BR report in IFS Cloud 23R1 contains 2 parameters for Date_From and Date_To. These are defaulted to #START_OF_LAST_WEEK# and #START_OF_THIS_WEEK#. Executing the report in the BR client this works as expected - the date range is rendered as expected. However, ordering the published report through Info Services, these default values does not show - and are not allowed. Similarly result for Global BR Parameters.  Is this how it is supposed to work in core ?I.e. that Context Substitution Variables are not available / implemented for reports of type BR reports ordered / scheduled via Info Services.

Hello,I am looking for a way to modify the colors utilized by my lobby elements in IFS Cloud.  For instance, in the below example, I would want Urgent cases to be red, Low cases to be green, etc.  I can change the Color Style, but that does not change the actual value colors, just the background.  Is there an existing method for making these changes, or is this a planned change in the future?  I greatly appreciate any assistance or info you can provide, thank you!

Hello, I have a question regarding stopping users from making transactions in a prior period after the date as passed.Ideally, I'm looking to see if IFS can support stopping any back-dated transactions in a prior period like a Shipment after the date has pasted in that period.Example: If the current date is 6/1/24 and the period ends on 5/31/24. Any shipment that is attempted to be dated with a 5/31/24 date or earlier should not be allowed.We would like to prevent any inventory/labor/shipment etc. transactions from taking place after the end of the period, while allowing for Journal entries to continue as needed.Wondering if there is a Company or Accounting setting I could be missing or if this level of granularity exists in IFS Cloud.

Hi All,Can anyone help me to find reason for this Pop Up Message in APP10Error Message : The Job Hours have to reconcile with the Attendance Hours before it is possible to confirm the time  

We have been trying to use the substitution keywords to get a mailto link to send to customers through an action template that sends an email to our mailboxreader/etm This is mostly working, we can get the  event reference in the subject line,  but cannot get the substitution keywords to populate the body of the mailto. we have tried a few things and its so close but just doesnt put the subject/body in the right place, seems to not be picking up the ? correctly if we do  this it works great, without a body of the email<vtl>#set($eventLink = "mailto:XXX@test.com?subject=Approved Ref:")</vtl><a href="$eventLink$new.event.formattedReference">approve</a> to try to get the body in we tried<vtl>#set($eventLink = "mailto:XXX@test.com?subject=Approved Ref:")</vtl><vtl>#set($eventLink2 = "?body= Approved%0A%0DAdd%20Additional%20comments%20below%20if%20required")</vtl><a href="$eventLink$new.event.formattedReference$eventLink2">approve</a&

Does anyone what is indicated by these small vertical bars in different colours?  

Hi Everyone,Would anyone have experience implementing the STMP Gateway in iPaaS?I’m referring to this:IPaaS SMTP Gateway - assyst11-8Wiki (axiossystems.com)IFS provided me a username and password for the gateway - however I have no clue how to input all of my MS Graph API connection credentials details for my email box.There are screenshots of configs fields in the wiki that need to be filled out - but WHERE do I input them?Thanks!Martin Provost

Good morning.  If the Customer pays travel allowances based on number of nights away from home, what is the correct Allowance Calculation method?  Only options on the system = Calendar/Duration/None.  Thank you.

On FSM 6u16 what is the recommended Visual Studio version for RDLC reports? Reason is, for example, the REQUEST rdlc prints in landscape irrespective of parameter settings. On Visual Studio 2022 which is what we currently use, the XML format seems to be a completely different XML layout

Dear IFS Community,I have calculated the cumulative lead time for all the parts. When I generate a plan for a manufacturing part in the project deliverables module, it calculates according to manufacturing lead time. Is there a way to make it generate according to cum lead time instead? For instance,  

How do we activate auto-allocation on service orders? This part is in stock in the chosen warehouse, but we need to Source to get it allocated on the order 

Hi Experts,Can someone please share 23R2SU5 Service update details. RegardsLokesh

Hi All,I have a requirement which I want to confirm whether or not it can be done using a workflow.When the user selects a value for Purchase Group based on certain logic the field Supplier should be automatically field.This needs to happen before clicking the save button Thanks,Dananjaya Misso.