Solved

Hi allI am strugeling with the TOP-N Function. I have a list with the quantity of some product families orderd by the highest quantity. The hole list is also filtered to different sites, where the parts are available. Sometimes there are mor then 10 product families per site. But I want to show only the 10 product families with the highest quantity. In a bar Chart or a pie Chart it’s possible to enable the TOP-N function. I have tried to get the wanted result in PL/SQL. I’ve found two ways to set the TOP-N function correctly in PL/SQL. Both of them won’t work in IFS.In the first Option i’ve put the hole query in a SUBSELECT and set a filter on the ROWNUM. In the Datasourcedesigner I havn’t a Option, to enter a SUBSELECT over the hole query.In the second Option i’ve use the FETCH command at the end of the query. But I can’t add this command in IFS.Are there any other Solutions, to select only the 10 product families with the highest quantity and display the hole result in a list? Thanks

I am able to run script below in SQL (the select part of it) and it returns the results as expected; however on Mobile the line-code field is greyed out and won’t allow selections.  I have confirmed that user_def1 is passed down to mobile.This is something i’m doing in order to filter out select line codes from appearing on Mobile screen.populateListFromQuery("non_part_usage", "line_code", "select description, line_code from line_code where npu_code = 'EXP' and line_code_type <> 'CYL' and line_code_type <> 'R'and user_def1 <> 'PR' order by sequence asc", true);

I am trying to see if a Part that i have on a MMR is currently on a PR i tried to use the below column SQL but keep getting a error message that missing expression, did i do this one wrong (CASE WHEN (SELECT COUNT(mmr.PART_NO) FROM &AO.maint_material_req_line mmr WHERE mmr.IS_CLOSED = 0  AND mmr.PART_NO = &AO.purchase_order_api.Get _Part_No(order_no))  >0  THEN 'MMR' ELSE 'NO MMR' END)  

Hello, Thank you for taking the time to read my question. Essentially, I have a customer that records duty charges (historical fixed values) on the supplier for purchase part which then gets applied to the purchase order accordingly. However, Duty Charges come through as a deffered statement from the HMRC and not as a form of a supplier invoice. These duty charges need to be matched as when the PO is received, the charges will sit with the PO value in the GRNI until it can be matched. The issue is that the HMRC are not providing a full breakdown and only provide a weekly final figure - which is tricky to match against as we don't know which lines need to be matched. Have you ever come across this situation and how the standard process normally work. I would have initially gone back to the actual submissions to the govt, but the customer has a third party logistics company do this for them. Any help would be appreciated :) Thank youMish

Hi,I would like to receive a price list from a supplier.I have a BizApi for that, but I think I need to receive XML as a message.Is it possible to get that incoming message from an e-mail? And how is that setup?I have a Connector Reader called MAIL_READER1. If I setup an inbox here, where will I then find the messages?I’m on IFS9.BR Kresten

Hi. What is the best way to generate and send a Sales call to the schedule board in FSM for allocation to a technician. Can this be done through the Opportunities function?

Dear all,In FSM (version 6.5) we have images stored in the metrix_image table as Byte[] Array (on the image field).Does anybody know how to get this image bytes from the record by using the endpoint API?Thank you very much for your support,Istvan

There are three columns on the Integration schedules screen, Trigger, Last Run and Next Run. If you schedule the task running daily, those columns do include HH:MM data. I’m wondering in which time zone those fields are?? Also, Integration Scheduling Wizard includes HH:MM field. Local Time zone?Here is a picture clip which causes confusion: 

Would it be possible to schedule a task to deactivate a list of users for a specific time and activate again.

I want to restrict the account codes available as part of the pre-postings when employees raise purchase/material requisitions.  Although I have created a saved search, I do not appear to have the option to set a default, showing only a few of the options. 

HiCan you tell me how I can setup scheduled reports in FSM 6. I would like the ability to send out various reports automatically at pre-set timesRegards

Is it normal that IFS (Apps8) does not make any live control on the lot/batch number when receiving parts into stock from a RMA ?IFS should suggest the different lot/batch no related the customer order line. Today, we can enter a lot No totally different from the shipment.Is there a way to do so ? 

Hi,Enviroment: Apps 10 Update 8In our test environment we have just completed the following:Clone of our Live enviroment Updated Oracle from 12c to 19cOnce complete we have started testing and found we cannot get any Crystal Reports to run, when we do try we get an error “No PDF report returned from Crystal Web Service”.Due to the clone I have made sure the system parameters are pointing to the test environment.I have also turned on logging, see a log below…I have highlighted the error in red: 11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[DecryptPassword] Decrypting Password : 11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetDbInfoFromXml] Decrypted.11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[DecryptPassword] Decrypting Password : 11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetDbInfoFromXml] Decrypted.11/24/2020 11:04:21 AM[IFSCRWebSetup_CST1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSCST Ap

Hi All,How can we check the IFS version in Aurena?In IFS EE, we use the About page. Cheers!Damith

How to pass values of target key reference to my custom method as parameter.

I am creating a scheduled MIG job, which I want to output onto a particular server folder. This doesn't appear to work as I expect and I have noticed that you can perform an LOV lookup and I have some file paths already set.How can I add a new one to that list? I cant seem to find the screen in IFS to do this? 

Users are attaching documents to Purchase Order headers and we have figure out how to control who can see the attachment and who can view an attachment. Our problem is, anyone who can see the attachment can ‘detach’ it from the purchase order.   How can we disable the detach option from the right mouse button menu? thanks

When user is in Business Opportunity 120 and carries out RMB > Send To > Mail Recipient as Link The email created has the Subject Business Opportunity 120 - 120. Would it be possible to change this so that instead of the 2nd 120 (after the - ) the Description is used instead e.g. if Description = Supply Pipes the email subject would display: Business Opportunity 120 - Supply Pipes Thank you. 

Object Connection Transformation provides the means to support object connections to be accessed from business objects other than the ones to which they are connected. In order to do so we have to specify an object transformation method. For some scenarios it is not possible to map the target and source columns due to the fact that the source columns are not included in the target database view. Therefore how can we use custom Database methods for Object Connection Transformations ?

We created a test database using RMAN duplication. On trying to log into our test database users are receiving the following error: Failed to retrieve security informationAccess to forms will be restricted.  Can anyone please advise.  

Hi,I would like to know if you can make CF in the Project Invoices LU ?It is build on INVOICE_TABI can create CF’s in the Invoice LU, and that is also build on INVOICE_TAB, so I don’t understand why this is not an option.BR Kresten

Hi folks,Does anyone know if Rnd decided to remove the functionality that was available until IFS APP10 UPD7, that we could change assignment status of an employee after transfer to mobile before the user download it. After UPD8, It’s not possible any more. Could anyone help please? The situation of my customer is that it has some external employees that they do a work but don’t have license, therefore the planner needs to assign a task to them and report time using the status change of the assignment.They send to mobile because the have some users that have license.UPD 07 UPD08 and 09 - Not available anymoreTks a lot

Hi people,Does anyone know why I’m getting the faield transactions sometimes “Entity not found”?The customer is using mwo app10 upd8.It updates everything, the steps, assignmet, pictures, but the method to save the status of the work task does not update. could it be the quality of the customer’s internet, something in mobile server or other reason?Tks

Hi,does anyonde already got this error?pm action calendar plan has already been removed by another userIt happens if I copy a work task that came from a pm action with task steps.As i try to change the status of the task step, the problem occurs.tks  

Hello, We currently use the IFS approvals feature, but one of the issues we are facing is that users have no way of knowing who requested their approval on a given item. Often times they may have a question about the approval and they have no way of knowing who actually generated the request.I’ve looked through the system, but I do not see any native function that will tell them who created the request. Is there any way to achieve this through a custom field or is there another way to obtain this info? Any help would be greatly appreciated.