IFS Solutions

Hi all,I’m working with IFS Cloud and trying to retrieve the Commodity Group 2 field from the Purchase Requisition Lines page. However, I can’t find it in Data Source Designer within the PURCHASE_REQ_LINE_ALL view. From the Debug Console, I see the following details: • LU Name: PurchaseReqLine• Projection: PurchaseRequisitionLinesHandling• Entity Set: PurchaseReqLineSet• Entity: PurchaseReqLine• View: PURCHASE_REQ_LINE_ALL• Component: PURCH I’ve checked the columns in the PURCHASE_REQ_LINE_ALL view, but I don’t see Commodity Group 2 listed. Is it possible that this field is stored in another table or fetched dynamically through another projection? If it’s in a different table, would anyone know the correct join conditions or an alternative where query to access it?Or is this field perhaps derived from a different entity that I should be using? Any advice on where to

When trying to recalculate Price/Currency it works fine within the custom order then selecting the line and RMB recalculate Price/Currencybut when i try to do this from the customer order line view it errors.on investigation i have found that there are 2 Currency columns in the customer order lines viewWhen i look at the system info one sql column is CODE_G  the other column: when i query  customer order line in SQL i get the following resultsselect co.code_G,co.CURRENCY_CODEfrom ifsapp.CUSTOMER_ORDER_JOIN cowhere o

FSM to PSO via SmartclientWith multiple datasets in PSO, it seems that PSO is changing activity type colours/colors from one dataset to another. We want consistent activity type colors across all datasets. Looking at activity types in PSO, there aren’t any color customizations. This is an Install in one dataset, colored by Activity Type in the Gantt: And this is an Install in another dataset:There are no colors set in PSO for Activity Types:Guessing there is a simple explanation, something just got missed somewhere. Does anyone know why PSO is showing diff

I’m trying to migrate some inventory locations into IFS Cloud but seem to come across one issue. But, I can’t figure for the life of my see why it’s happening.  This is the error that I’m getting, but every other location with the same location group is working fine. Has anyone else seen this issue and found a solution?

Hi all,We are having some issues regarding PSO activities AutoDuration.We have defined the following PSO parameter:           AutoDurationEnabledByDefault = FALSE In the PSO menu "Activity Types", we have defined the tab Auto Duration Enabled as FALSE for all activity types.   Despite having these parameters configured correctly, PSO is still adjusting the activities' durations, making them shorter or longer.Is there a parameter we might have missed? If not, can anyone help us understand why the durations are still being altered? Thank you, everyone.

Is it possible to rename a Group in IFS by SCIM after creation? I want to rename some Groups in IFS

Hello All,Is there a proper list of modules, platforms and functionalities that the replication solution will be applicable?Are there any recent documents , F1 documents any materials i can use to get an idea of Replication Solution?Thank you in advance.Best Regads,Vinu

IFS Cloud API Discovery Process:Identify the Entity: Begin by locating the relevant entity within IFS pages. APPs 10 pages are recommended for faster searching. Construct the API Name: Data Retrieval & Manipulation: For fetching data, create, delete and update, the API name typically follows the pattern: <EntityName>Entity. Data Actions: For performing special actions, the API name is usually: <EntityName>Service. Verify Category: Ensure the API's category is "integration." Acknowledge Exceptions: Be aware that deviations from this naming convention may exist. Example Entity: PurchaceOrder

Hi All,Do we have any tables that stores info about the deleted custom fields and events?Also, will custom objects be affected by the UPD update (Modified or Deleted)?Thanks in advance

Hi,I would like to know the example or steps to create Custom events with application message action to send a file using SFTP IFS Connect connection. Thanks,Sachini

Hi, I would like to generate a report and send it to another SFTP location using IFS Connect SFTP connection. Generating report and send it to SFTP location should be happened using a custom event as when some filed is changed this should be happened. I would like to know how to use custom events for this with application message action. Thanks,Sachini

I am trying to run cust_age_analysis_rpi.Cust_Detail_Age_Analysis in pl/sql to generate the archive data for it, and then I am going to pull it into an SSRS report. I had done this years ago at another customer and this code worked, but not sure what I am doing wrong now. Getting this error.“end;Error report -ORA-20111: Archive.FND_RECORD_NOT_EXIST: The Archive does not exist.ORA-06512: at "IFSAPP.ERROR_SYS", line 140ORA-06512: at "IFSAPP.ERROR_SYS", line 366ORA-06512: at "IFSAPP.ARCHIVE_API", line 845ORA-06512: at "IFSAPP.ARCHIVE_API", line 849ORA-06512: at "IFSAPP.ARCHIVE_API", line 235ORA-06512: at "IFSAPP.ARCHIVE_API", line 240ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1285ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1294ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1327ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1331ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1745

We tried to setup the PO Change Industry Lobby KPI but it looks like the workflow IndustryLobbyKPIProcurementPOChange is always failing with following error in the BPA_ASYNC_SYS_AUDITBpaBaseException--BPA_RESULT_SET_LIMIT_REACHED_EXCEPTION_ERROR Same error occurred when we try to debug the workflow using same parameters It looks like the error is with the Get Total Value of Purchase Order Change Orders projection call.This call  doesn’t have any parameters so it fetches ALL the change order details.The same applies for Get Total Value of Purchase Orders task as well since it also doesn’t have any parameters.Will IFS provide a usable version of this workflow in a future release?IFS Cloud version: 24.1.8 Best Regards,Damith

Hello, in the fact_customer_order_line_bi . I cannot see the correct amount if I have a credit that was made at the order level following an RMA. I can just see the amounts on the order line side and not on the invoiced line side and that creates an imbalance at the sales level.Exemple : Customer Order line  Side :fact_customer_order_line_bi : in power bi  fact_customer_order_lineCustomer invoiced Line side :  The  question : is there a way to resolve this issue and get the customer order line amount correctly

Hi,I’m trying to save and publish a report to the IFS Cloud environment, but getting the below error. Kindly help me to resolve this. Error when saving the report in ifs cloudRegards,Deepal.

Just a rant for whoever experiences the same.I'm trying to get IFS to fix exporting and importing ACP's with event actions of type Execute online SQL where the statement has more than 4000 characters.And the ticket turns into a discussion about why I'm not using workflow and if I can supply a list with issues which caused me to use sql instead of alternatives.Excuse me what?The fact here is with the implementation of the workflow in our company we had a huge list of issues and design flaws which I had to call out and struggle to get corrected. And by no means I'd say that in the current state in the version we're about to go live it's a stable solution. I don't get thanks for this, I get to pay to get things fixed and struggle to keep tickets open as well.For me the problem with IFS in this regard is that they have the balls to say this SQL feature is deprecated while fully knowing that the alternative is a steaming pile of ….. 

This issue is encountered by one user only and there were no permission changes recently .They mentioned that when they click view button normally the Document would then appear in a separate application / window but this is no longer happening. Need your kind input on this issue.ThanksUdanee

Community, Does Shipment Order can be functioned as transport task or distribution order, which can be automatically created in the system?  Thank you. 

Hello everyone,The task at hand is to send picklist report in email without physically printing it to the printer.I have a report rule that kicks off and send email only if Printed column in Report Archive has value 1. I tried to use Set Property, preselect Property and default Property to print the report on a No PRINTOUT logical printer but that does not help until user click on ‘Print Pick List’ menu option and OK on the print dialogue box.In our shipment type we have Print PickList set as an Auto function.What's the best way to achieve this task without forcing the user to print picklist on a noprintout printer which is couple extra clicks and one extra step in the process to remember. Thanks

PSO shows the resources incorrectly as available when they are not. PSO Region filters are not respecting the availability times.  It shows resource in Region if ANY past or future-dated availability exists. Current functionalityWe have 4 resources assigned to region AA1A. One resource is only available from 5/5/2025 – 5/25/2025. (This is filtered by adding the ‘valid from’ and ‘valid to’ dates in the scheduling resource regions). In PSO we are filtering the resources assigned to region AA1A and available for the next 7 days. The result still shows the resource who is only available in May as well, which is incorrect. The same issue exists when we use availability patterns as well.  Current time filter only applies to the resource shifts. This needs to be fixed so it will consider the availability of the regions as well, if filtered by the region

Hello, I would like to know which custom expression to use in order to schedule a database task to run at the end of each month at a specified time. I am currently using the custom expression LAST_DAY(sysdate+1). Is there a way to add a time into this expression? We are running IFS Aurena 10.  

In PSO 6.13 and now 6.14, we are noticing that when recurring (daily, weekly, etc.) unavailabilities are created in PSO, the info and display on the Gantt is consistently skewed by 33m52s.  Has anyone seen this or can anyone offer ideas as to where this might be coming from? Thanks,Richard Gantt info Unavailability on resource

I matched three invoices in the Supplier Check window and successfully created a Supplier Check. However, when I navigated to the matching details of the Supplier Check, all three invoices were visible, but the Voucher Type and Voucher No fields were not displayed.Could you please clarify why this is happening?Application Service Update: 24.1.4Framework Service Update: 24.1.8Please refer to the attached screenshot for reference.  

Hi everyone,I'm trying to create a bar chart forecast in IFS Lobbies that shows the total net amount of planned spares (SUM(UNIT_PRICE_INCL_TAX * QTY_INVOICED)) grouped by custom delivery periods rather than standard calendar months.We have predefined customer order delivery months (e.g., "Jan-25", "Feb-25"), each covering specific date ranges rather than full months. I need to map planned delivery dates to these periods for proper grouping and display them on the X-axis of the chart. Here’s the query structure I’m using: -- Name: Customer Order Forecast Per Month-- View: &AO.CUSTOMER_ORDER_LINE-- Where:EXISTS (    SELECT 1     FROM (        SELECT '01/01/2025' AS start_date, '01/01/2025' AS end_date, 'Year Opening Period 2025' AS period FROM DUAL        UNION ALL SELEC

Hello again,I’m trying to create a Persistent Custom Field (Boolean) in Preliminary Supplier Invoice screen to identify some feature for a newly created invoice. The process goes smoothly, CF is published without errors, but when trying to create a new record with the checkbox ticked for this CF, system displays the error: In DetailsServer error messages:809f34f0-4b7d-4301-a0a3-6578e0a9262dIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01410: invalid ROWIDFailed executing statement (ORA-01410: invalid ROWIDORA-06512: at line 16ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 699ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 578ORA-06512: at line 10)   at Ifs.F