Q&A Discussion of IFS Solutions for our IFS Employees, Partners and Customers
Recently active
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 1745ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1751ORA-06512: at "IFSAPP.CUST_AGE_ANALYS
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 ….. Why not be honest and set a date when it can actually be d
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 SELECT '01/01/2025', '24/01/2025', 'Jan-25' FROM DUAL UNION ALL SELECT '25/01/2025', '21/02/2025', 'Feb-25' FROM DUAL UNION ALL SELECT '22/02/2025', '24/03/2025', 'Mar-25' FROM DUAL UNION ALL SELECT '
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.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions) at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions) at
Hi Community,Is there a way to convert a multi-company project transaction into a regular project transaction? If so, what steps are required to achieve this? Any guidance would be appreciated!We’ve created a correction transaction and changed the activity to a non-MCPR linked activity but it results in the following error.The error message seems to suggest that there is another view where the transaction can be converted from MCPR transaction to a regular project transaction.Our version is IFS Cloud SU 24.1.3.
Hi All, Is it possible to create a manual supplier invoice for an a project activity line ? ThanksDivya
Hi,I am seeking some general advice and insights regarding our transition from IFSAPP10 to IFS Cloud.Currently, we utilise all 10 of our defined code strings within our accounting rules. While I won't delve into the specifics of each code string, I can confirm that they are all essential for our business requirements (details can be provided if needed).We are concerned that this extensive use of code strings might pose challenges as we migrate to IFS Cloud. Therefore, I have a few questions that could influence our decision to either re-implement or upgrade:Is it possible to repurpose one of the optional code parts we have defined for future use? What impact does using all 10 code strings have on our system, aside from limiting future requirements? Is there a way to use more than 10 code parts (either standard or customized)? Are there any guidelines or recommendations on the number of code parts to define within a string?Any general advice and the importance of getting this right for
Hi CommunityIn the process for Clear Revenue/Cost Balance, IFS is currently configuring with the GP8 Posting Control based on a Fixed Value.We would like to use the “GC3 - Ledger ID” control type for add a 2nd option (One in case of profit, one in case of loss)I can’t figure out how create a new Ledger ID to use it correctly, could you please help me to solve this problem ?If you have another idea to solve this problem it would be perfect.Regards
Hi1) Is it possible to expose endpoints from Grafana and Kibana to external tools? currently the endpoint https://ifs.xxxxxxx.eu/grafana/datasources is used but only metrics for Memory are visible (CPU and filesystem are unavailable)2) Is there a way to quickly export and import dashboards from kibana and grafana to a file/files? The thing is that when updating certificates (at least once a year) it is necessary to reinstall Cluster Kubernetes and we have to install the namespace ifs-monitoring again together with the dashboards.Product Version: 24.1.5regardsDaniel
Hello, Is it possible to import and external supplier invoice as an advance invoice ? Best regards
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.