Solved

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.

Hello,I am currently trying to run IFS Business Reporter and learn some of the basic, but when I try to pull data from my information sources, I have nothing returning. However, in IFS Cloud there are balances and data in the sources I’m pulling from. I’ve tried multiple different account type but always return a zero value. Is there some permission or setting somewhere in IFS that I need to update? Also, whenever I am putting in row repeaters, the only way that I can get any data at all to return to me is if I select the ALL checkbox on my Design Row Options. This isn’t what is described in the IFS Business Reporter training. Lastly, whenever I am trying to use the sheet repeater, a report that was otherwise working will break and no new sheets are created. Even if it’s an information source that I have already confirmed returns a value in other testing. 

Hello community, I have a question about family configuration management. I would like to know if in IFS, is it possible that we define options that condition the choice of other options?  As an example, supposing that we have 3 configutared parts for a phantom part (upper level) with a family configuration of 3 caracteristics; Color → options value C1 and C2Size→ options value S1 and S2Door→ options value D1 and D2 Part A→ with characterictics rules C1 and S1 and D1Part B→ with characterictics rules C2 and S1 and D2Part C→ with characterictics rules C2 and S2 and D2 What i want is, as soon as i choose value C1 for color, IFS do not display me anymore S2 and D2 as values to choose on other caractestics(size and door) in configuration creation menu by noticing that there is no such an option possible. Do not hesitate if my question is not clear enough. Thanks for your answers in advance Best regards  

Hi,I try to return a loan using the assistant “Create Return Material Authorization”, but I can’t see the line to be returned. I used this feature to return the asset at a different site with the new functionality in IFS Cloud. Note that it doesn’t work neither when we use “Return to Own Site” option.I wonder if the assistant is enabled to rental returns, and if the mentioned enhancement has been limited to sales only and disabled to outbound rentals.  

Are there any steps for migrating excel data into customer order line using latest IFS excel migration.

 I’m trying to create an object transformation between work task and business opportunity to display business op documents on the work task in IFS Cloud.Connection between BO and JtTask is defined as below.Added a custom field in JtTask to fetch the related BO No. Many thanks for your inputs on this issue.Best regards,Uvini

Do other operators have a way they prevent the purchase and receipt of banned parts? Specific inventory at the P/N and S/N level.

Dear community, I wonder if the following is possible? any ideas would be great. Create PR and Convert to PO for non-part line Create WO on serial object Connect PO created in Step 1 to Work Order so costs can be captured on the Work Order?I know you can peg the Material Req demand to existing PO “manual pegging” but this is for non-inventory part or non part coded items. Any help would be great. Thanks.David