Solved

Hello experts,I created a new custom LU with couple of fields. One of them is checking duplicate values.These are my custom LU columns. Please see the SQL code for DUPLICATE column. When I run query on SQL query tool I got the number. Please see below  But on custom page the number is 0 although the query is the same. What could be wrong.  thanks

I need to do a validation, There is a method in SECURITY_SYS.Is_Role_GrantedI need to validate if user belong to specific Roles if not provide and error when updating project definitionI have created the Custom Event to trigger the workflow.wondering how to perform it via BPA SQL METHODCUSTOM EVENT 

Hi IFS Community,  I face an issue with the connection of Excel Add InIn the config, Excel is installed on a rebond machine hosted by the customer.  Version of Excel is MS Excel LTSC Office Long Term Servicing Channel Microsoft® Excel® LTSC MSO (16.0.14332.20546) 64-bit  I managed to set up everything manifest, permission set … but when i try to connect Excel Add In i have the following message.ADD-IN ERROR Content blocked because it was not signed by a valid security certificate. Any idea how this can be fixed ?  Best Regards, Eric

Hello, everyone!Anyone familiar with IFS Cloud 21R2's Send Document File By Email feature in Document Revision window? I have installed the Aurena Agent and when I am trying to send the document, it neither opens the email nor gives any errors.I hope somebody can give us a word of advise on this matter.Your help is much appreciated.Thanks

Hi Everyone, Context: 3 Azure VM’s (Management - Windows, Database & Middletier - Linux) all in one Virtual Network. Issue: When trying to Deploy Middle Tier, I get the following Error,  10.80.50.5 is my Database server’s private ip address. And I couldnt find a port 10250 in the Database Server either. And when I googled it seems the 10250 is a port of Kubernetes. Would someone be able to clarify:Should the dial tcp command actually be trying to reach <<db_host>>:10250?And if soShould the DB server have a port 10250? When does it get configured and opened? PS: I was able to do ‘prepare database’ and ‘deploy ifs application database code’ steps without any issues. Log files were okay as well. Any help in this regard is appreciated. Thanks.

hi It it possible to have attachement by default sorted by creation date in V9. the document were sorted by creation date? In ifs cloud the document are not sorted by default in document panel Regards

Hi All.is it possible to create the same site ID but in different company?E.g.:Site 02 Company 07Site 02 Company 01I’m getting a message that the site already exists for the company. Br.

Hello everyone,  What is the purpose of the ‘Alternate Tool ID’ field on the Manufacturing Tool screen? We have tried to use it so that when our main tool is down APB would use the alternate tool ID for scheduling, but we have been unable to get this to work. Additionally, we were wondering if the alternate tool ID could be used for overflow demand (if we need to produce 100 parts could the alternate tool ID be used along with the main tool ID to speed up production)? We are currently on Apps10 UPD12.  We appreciate any help!

I came across a visual product roadmap deck somewhere in the community, but cannot find it.  Can someone please point me to a resource which defines when Apps 10 will go out of support?

Dear ExpertsI have found the following Business Event SOCLOSE+/- connected to a posting control  M40 and M59the reversal of this transaction would be the UNSOCLOSE+/-. if i check the posting types which are connected to this posting type there are none available. does that mean this event doesnt exist anymore? 

Hello , I need to prevent the creation of a new customer invoice if the customer is not approved .I tried to create a custom event to control that , But it does’t stop  the creation of a new customer invoice .I applied the custom event on CustomerOrderInvHead (LU) and INVOICE_TAB and here is the script of my event action : DECLARE lu_name_ VARCHAR2(1000) ; key_ref_  VARCHAR2(32000) ; result_ VARCHAR2(32000) ; --approval_status_ VARCHAR2(1000) ; BEGINlu_name_     := 'CustomerOrderInvHead'; key_ref_   := 'CUSTOMER_ID=&NEW:IDENTITY^'  ;                     result_ := approval_routing_api.is_approved(lu_name_,key_ref_);    IF (result_ = 'FALSE') THEN      Error_SYS.Record_General(lu_name_, 'APPROVAL_ROUTING: This invoice cannot be created. The customer is not approved') ;end if;END; Does anyone have an idea what could be the problem ?  Thank you ,Hanane  

Hello,I can see this topic has been discussed before, but I cannot see a definitive solution that I can follow to rectify the problem.Can anyone please assist? ThanksCory

Hello to everyone!Recently, some pcs in the company where I work started to give us the error 0x800736b3 when We tried to start the application. Do you know what is it? How to fix it?  This is exactly the error that ifs throw:DETALLES DEL ERROR    The following errors were detected during this operation:    * [22/8/2023 09:13:28] System.Runtime.InteropServices.COMException        - The referred assembly is not installed on your system. (Exception of HRESULT: 0x800736B3) - Origin: System.Deployment

Hi All, We are trying to collect debug information for integrations and added trace messages using Log_SYS.Fnd_Trace_ However, ifs-trace node only appears like below when mentioning the ?odata-debug=json in the projection call which is authenticated with client credentials If the same call is made with an end user, then the ifs-trace contains the trace informationMy question is, how can we enable trace for integrations? Is there any projection which needs to be granted or is there any other way? /Damith

Hello All, I am testing the group consolidation functionality and I believe I have set up all of the basic data required.  When I try to Consolidate Balances from the Consolidation Status screen I am getting this error message  there is no place to enter the period of transaction.  I assumed that it would default from the period entered for the consolidation status. Has anyone seen this before?

Hi Team,How do you download a Fixed Asset Disposal Details. attached is a report I found and it looks like using a result key.I need to download detailed disposal details. there’s a report under Order report but that does not give the details only the summary in PDF format.

Hi,I’m trying to create a customer order record using below REST API call via POSTMANhttps://cutomer-test-env/int/ifsapplications/projection/v1/CustomerOrderService.svc/CreateCustomerOrder {    "OrderRequest": {        "CustomerPoNo": "AKMTEST002",        "Customer": "**TES536",        "OrderType": "ASN",        "Site": "RODDA",        "Coordinator": "*"    }} But I’m getting ‘Metadata not found’ error continuously when trying to create a Customer Order via POSTMAN. Little bit background of this.We have recently request to enable ORDSRV component for this customer and solutionset.yaml file delivered to this customer environment recently.Can anyone have idea about this? 

Hi  I have a question can we have visibility to SYSTEM  in incident/Service request form https://wiki.axiossystems.com/assyst11-6Wiki/index.php/System_Theory

 How to bring the events created by me from AssystNet to show in AssystWeb@All Events Logged By me ?Same Type of event, when logged from AssystWeb, its showing in All Events Logged By me but when logged from AssystNet, its not showing in AssystWeb @ All Events Logged By me.

Customer showed me that this window is populated very long (there are over 600000 rows). Because populating action is started automatically when user opens this window this makes a problem for him. Can We suggest sth for him?

Trying to change the default Action Group for an Employee. Or doing any changes at all (here, trying to add a note). Never experienced this before: 

Some alerts are for backoffice, some are for SAs. And some are for both. Any way to filter who gets them?Or do we use Alerts for SAs and Notes for backoffice?

I have set up my user as scheduling resources with access to mobile.  When I login to mobile with my user id/password, I get the following screen without the tiles. I tried to follow the troubleshooting guides in the tailoring guide and video training on Mobile access, and this issue is not mentioned anywhere.   Does anyone have a clue to help me out. 

How to enable/ disable “New Work Order”,  "Pool Work" and "Work to Prepare" tiles from home screen of in IFS cloud MWO maintenance  application? 

On the Document Management\Approvals screen in Aurena, we are trying to clean up the list of entries to show just the records with a null Approval Status...ie those that are waiting for an approval or a rejection. We can see these entries when the full screen is populated. But we cannot filter for null or not eq rejected or approved. Is there any way to do this filter? Our current version of IFS is  Thank you,Lorraine