IFS Solutions

How do you implement 2 data sources (views) into the lobby data source designer. I want the following code to return the count in the data source.select distinct(sp.catalog_no)from lora1app.sales_part sp, lora1app.sales_price_part_join splp where splp.catalog_no = sp.catalog_no and splp.SALES_PRICE_TYPE_DB = 'SALES PRICES'and sp.activeind_db = 'Y' and (splp.part_valid_to_date >=  (sysdate) or splp.part_valid_to_date is null)and splp.valid_to_date >=  (sysdate)       --currently I have gone about it the following way seeing that the data source cannot handle two views:select distinct SALES_PART.Catalog_NO from SALES_PART  where SALES_PART.activeind_db = 'Y' and SALES_PART.Catalog_NO  in (select catalog_no from  sales_price_part_join where  sales_price_part_join.catalog_no = SALES_PART.CATALOG_NO AND  sales_price_part_join.SALES_PRICE_TYPE_DB = 'SALES PRICES' and (sales_price_

Hi All,I’m working to better understand the fields and impact of the Supplier - “Contacts” & “Communication Methods” Question 1: What does the Communication Methods and Contacts help once set up… the only thing I can think of is:“Supplier Contact” field under the Tab “Purchase Address Info” which drive Emailing the Purchase Order, and Potentially the SRM Module if used.  Question 2: What is the benefit of populating the following fields: Communication Method:Default per Method Default per Method and AddressContacts:Address Primary Address Secondary Supplier Primary Supplier SecondaryThank you,Alex

Hello,In IFS CLOUD 23r1  am using a workflow which will trigger an API call to another system after the NewEmploymentHandling / EmployeeAssistantFinish(Objkey):StructSavedEmployeeDetails is called.This is working but, I’d like to improve it and include data enter into the EmployeeAssistant into the API call to the other system.Any advice?Kind regards,Josh

Hi,Is it possible to pull data from an API call that is being called to used to trigger a workflow?For instance when NewEmploymentHandling.svc/NewEmploymentSet is called take the SavedEmpNo and use it to make another API call within a workflow?Kind regards,Josh

Hi,In IFS Cloud Dispatch Console, is there functionality to assign multiple work tasks/ assignments to a Crew simultaneously, either via drag-and-drop or direct assignment?We are managing numerous similar tasks that need to be dispatched to a Crew efficiently. Additionally, assignments are expected to be handled individually within MWO for reporting.Bundle Tasks in 23R2 does not meet this requirement, as it lacks the necessary MWO functionality.

Hi All,Could you please can you advise the implications of ticking or un-ticking the Transaction Level check box. Please can you advise the impact if you have had the Transaction level check box ticked for several years, but then un-tick it. Will it affect existing Purchase Orders and Invoices? 

Is it possible to import data into Excel using Excell addin by the Search function - only rows with empty ( NULL) field ? In IFS (cloud version) we can show rows with empty fields only using filter “!<>”  Is it a similar solution for import rows into Excel ?  

Hi All, I have recently created some cost buckets for inventory parts relating to different product families. However when testing, I’ve found that one of the cost buckets still has parts in it that relate to the wrong product family. This is doubling up the cost when calculating the standard cost. I cannot see anywhere how I can remove the part from the cost bucket. I can’t delete the cost bucket and start over, either.  Has anyone experienced this before or does anyone have any suggestions please?Thank you, John 

Hello,We are trying to implement standard costing in IFS Cloud.We have created different cost templates for our different product families, each with their own sets of Cost Buckets and Cost Elements. It is set up this way because the different products absorb different amounts of overhead.The different overhead Cost Elements have been set up as percentages of 110 – Estimated Material Cost, in line with our costing model.Cost Elements with absorption ratesCost BucketsCost Templates 

Hello,  Is it possible to have a project with a financial origin and still do capitalization and revenue recognition for this project ? Best regards.

Hi All,I was following the below URL to use Excel migration job to insert/update Note field in BUSINESS_LEAD page in IFS. (IFS Cloud 24R1)https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/050_data_migration/002_migration_types/030_excel_migration/default.htm?_gl=1*1kzdxq4*_ga*MTI0OTMxMDg4OC4xNzA0ODM1MDgw*_ga_H7YJR9R7Q1*MTcwODUzMzQ2Mi45MC4xLjE3MDg1MzM0OTAuMC4wLjAAnd I got below error when trying to insert or update the Note field.I have attached the migration job I used.

We switch from IFS10 to IFS Cloud and are still testing IFS Cloud (currect 24R2).When we try to create a new Customer with Category Customer the system does not allow us to do so. When we try to create a new Customer with Category another category we can save the created customer. Where in IFS Cloud is the setup, that we cannot create a new customer with Category “Customer”? 

We have a customer experiencing an issue with MWO Service Notes on iOS that is not happening on AndroidAndroid – The Note display area expands to display the entire text and, once the entire screen is filled, it becomes scrollable. This allows the greatest possible visibility given the size of the device.iOS – The note only displays within a box with no outline, and the only way to read it is to scroll the text within that small box. This makes it easy to miss content and not get the full scope of work.These notes are used extensively to communicate scope of work and actions performed between the field and the office. The limited visibility of the notes on iPhones is a significant hinderance in being able to fully use these notes.The company policy is that field techs use iPhones to interact with the MWO. IFS is suggesting fixing this in 25R2.Product Version: 23R2.Has anyone else experienced this and have a so

Hi ​@Sangeetha Jayamaha  Good Day! I hope you are doing great I am looking for Process document to upgrade from IFS 10 to IFS cloud… Could you please help Mam Thanks,Srini 

Is there a possibility of service tech to do communication with the customer through MWO app?  Is there a data limit when it comes to attachments (image/video/documents?)

 Hello,On the Go-live the Sales Contract is partially Invoiced with AFP.  For the migration of open AFP Invoices - can I use a standard STDCIN1 or STDCIN2 migration template? Or is there any better tool dedicated to migrate those kind of invoices? Also - can I only migrate the Open AFP invoices? Or is it better to re-generate all the AFP invoices issued before Go-live, to have the proper progress set on Sales contract Items (proper value of certified work and proper queue of AFP invoices?I’d appreciate any information.Kind RegardsBeata

How are the order based lot numbers created/assigned for items produced on a production schedule????  It appears to be just using a counter somewhere!  But where is this set?

Hi,We are currently using IFS Cloud 23R2 SU14 alongside the IFS MWO Service app, and was wondering if we were able to hide/remove the Initialize button from our engineers through page configuration or another means?We are finding our engineers are clicking this button despite numerous attempts to communicate and prevent this, as we are aware by clicking this button it will remove all transactions from the device which have yet to be sync to the back office. Appreciate any feedback or suggestions.Thanks

Today when we create a PM Action we use the “PRIMARY TASK”. Can someone share a way to use multiple tasks in the same PM Action, is there a “SECONDARY TASK”?Is there any supportive document about this?Can someone share an example and good practice how to use multiple tasks?

Hi All, I have the below SQL statement which when I run in the SQL query tool, it works.But when I save in Quick reports, it returns an error. What is the correct format in quick reports? SELECT    p.project_id AS "Project ID",    p.name as "Project Name",     TO_CHAR((select SUM(a.Amount_Balance) * -1              from ACCOUNTING_BALANCE_AUTH a             where p.Project_Id = a.Code_F              and a.Account IN ('3011', '3014')             and a.year_period_key <= NVL('&Year_Period', '204012')), '999,999,999,999') AS "Revenue to Date (RTD)",     TO_CHAR(SUM(b.Net_Amount), '999,999,999,999') AS "Invoiced to Date (ITD)",     TO_CHAR((select SUM(a.Amount_Balance) * -1              from ACCOUNTING_BALANCE_AUTH a             where p.Project_Id = a.Code_F              and a.Account IN ('3011',

Community, any idea what is the root cause of this error? 

Community,how to understand below error message? what action is the user doing?this part has Availability Check checked at Inventory Part level.Thank you.

I tried this in both 23R1 and 24R2 environments with latest version of developer studio.Just trying to override crud_create and initialize a customized variable.Cant find any methods in sublayers.Any idea how to resolve this?

Hi all, I’m trying to configure a pie chart in IFS that groups Purchase Order Lines by Planned Receipt Date using a calculated column called Days, which bins records into segments like ‘Overdue’, ‘Next 7 Days’, ‘Next 14 Days’, etc.  Here’s the CASE logic used for the Days column:(CASE WHEN PLANNED_RECEIPT_DATE < TRUNC(SYSDATE) THEN 'Overdue'  WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE) AND TRUNC(SYSDATE + 6) THEN 'Next 7 Days'   WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE + 7) AND TRUNC(SYSDATE + 13) THEN 'Next 14 Days'  WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE + 14 ) AND TRUNC(SYSDATE + 20) THEN 'Next 21 Days'  WHEN PLANNED_RECEIPT_DATE BETWEEN TRUNC(SYSDATE + 21) AND TRUNC(SYSDATE + 29) THEN 'Next 30 Days'  WHEN PLANNED_RECEIPT_DATE >= TRUNC(SYSDATE + 30) THEN '30+ Days

How can I get the customer name that is against the address to pull through onto work orders/work tasks, instead of the account name in IFS Cloud?