IFS Solutions

We have designed Order Report Excel Output, when we are running the report error is coming "PDF Not Generated" in Aurena & "Stream was not readable" through the IEE. It's a Data Rendering Limitation. If we are limiting the data less than or equal to 58,000 report is generating. Also, if we are designing the report through the designer then report output is coming in PDF for whole required (Pages 15,000 approximately. I am attaching the screenshot in a sequence for reference

Hi,I’m getting following error when trying to activate a data mart,The following error occured while refreshing Information Sources; "Error while refreshing Data Mart Source (GL_TRANSACTION_MVT) - resource busy and acquire with NOWAIT specified or timeout expired"Is there a way to stop the previous job?

 We have one user that receives the below “Could not load metadata for CustomerOrder” error in 2 of our environments.Typically I’ve seen this error tied to issues with Page Designer or with the security User Group related to a Page Designer context, but in this situation there are other users with the exact same User Groups/Contexts who are not having this issue.What else could be causing this issue? Below is what we have tried:Checked the Page Designer configurations for this page. (There is 1 change to the Global context, and other changes to a context called NAF that is tied to a security User Group called NAF. This user is part of a different security User Group, so it should be defaulting to the Global context. This page loads normally for all other users with the same setup.) Changing the user’s security User Group to NAF Clearing the user’s projection cache Logging in/out Using a different browser Debug log is empty for this error I had the user open Page Designer -- this did ca

I am on Apps9 UPD17 and trying to create an external file output to use similar to ACH, but I need to add one additional field from the supplier record to the output.  There is little to no documentation to do this.  I have tried setting up a new payment method and payment format from the AchFormat and can get it to create the file, but it is the same file as would be the ACH.  I am trying to find out how to change the output, would this be from the FILE TEMPLATE and OUTGOING FILE TEMPLATE on the payment format?  And if so, there is no documentation on how to set this up to include all the needed info.  Anyone have experience with this or know where I can get documentation or example file templates etc?Thanks!

We have multiple situations where shop order pick lists are being generated and the operation is missing leading to components not being picked. All structures have operations connected to them, but these are not being pulled through onto shop orders. I’m wandering whether this is because the product structure that they are called up in is planning method P (phantom)? For information: Pick Lists are created per Work CentreAll shop order material parameters are %Max orders per pick list is 1Include Unconnected material is toggled onPlanning Methods Used for manufactured parts - A and PPlanning Methods Used for purchased parts - B   

Hi,Report Studio is for me still big disapointment. I’ve asked IFS Academy for informations about any training to see it in action. This is their response:Good day! Currently, there are no courses that fully focus on Report Studio. The courses mentioned under 'Report Studio: New Features' cover the latest additions in each release of Report Studio but do not provide a comprehensive course on the subject. Regarding the '24R1 Document Automation – Report Studio: New Features & 24R2 Reporting & Analytics – Report Studio: New Features' self-paced eLearning course:This courses primarily cover new features such as Configuring Report Fonts, Configuring Report Images, and Configuring Custom Attributes. It is specific to the 24R1 OR 24R2 track and does not provide a comprehensive overview of Report Studio. Additionally, our 'IFS Cloud – Report Designer Development' (Virtual Blended Course) only includes a basic-level explanation of Report Studio. Unfortunately, as of now we have no avai

Community, Which window can do below configuration? Planning tool handling Ignore, Drop, or Rollout behavior on sales quotation line when Planned Due Date is passed. Thank you.

Hi,is it clear somewhere which standard FMEA is based on in IFS?e.g. ISO 31000, ISO 31010 or DIN 60812:2018Best Regards,Milanko 

When approving a single expense sheet, I receive a warning message if there’s an outstanding advance for the employee.However, when approving multiple expense sheets at a time, I do not receive any warning messages for any outstanding advances.Does anyone know why it will only warn me when approving a single expense sheet and not when approving multiples at a time? 

When Printing instant Invoice we get bellow Error 

IFS Cloud 23.2.9We are managing standardized parts which are certified by an accredited certification.This involves, after qualification, a freeze on the configuration of those parts and only one person in the company is empowered to modify any data on such a part. So, the objective is to freeze (block modifications) all the data we have on master part, inventory part, product structure, routing, purchase part, SFPP and sales part considering that many people can interact on these projections for classic partsAny idea to manage access/rights on many projections but only for some parts ? or is someone already got this need ?Thanks for your help

Anybody ever created a dynamic rolling 12-month report in Business Reporter for balance sheet items (including the Period 0 activity)? I’m running into issues, and wanted to know if someone had a better idea or an idea to tweak what I have. I have 23 column designs. The first is for the wanted YearPeriod. The next 11 are “previous YearPeriods within the same year (currently filtered to 2025)”. The next 11 columns I’m attempting to have the same conditions, but in the previous year (again, filtered to 2024). When I run the report for January, it’s perfect, it gives me 12 different months. For every month past January, it gives me an extra “December”, as my current filtering is telling the report to give me all of 2024. Example, if ran for March 2025, I will have 3 December 2024’s, 1 wanted and 2 extra columns, due to the filters of =2024 and 2 YearPeriods behind 202505 is January 2025. Any thoughts/suggestions/ideas/constructive criticisms are greatly appreciated!

Hi Experts, I have a customer scenario as follows.A customer order comes for package part S which consists of part A, part B and part C.Now since one of the component of package part S is discontinued , there is another package part with composition of part A, part B and part D.and we want to send this new package part T instead of package part S.but to a customer order where they ordered package part S. how can we achieve this in IFSCloud.Any suggestions would be appriciated.Thank you. 

Hello IFS Community,My team is looking to gather insights and best practices regarding Release Updates (RUs), specifically how other customers manage them. We're particularly interested in your approaches and strategies for handling bugs that are not identified or picked up by the Update Analyzer tool.We're in the process of refining our internal "how-to" guide for the RU process, and your experiences would be incredibly valuable.Specifically, we're hoping to learn: How do you proactively identify potential issues or regressions in RUs that the Update Analyzer might miss? What processes or tools do you use to test for and manage bugs that aren't flagged by the Analyzer? Are there any specific "gotchas" or common pitfalls you've encountered with RUs and unexpected bugs? Do you have any recommended best practices for the overall RU process, especially concerning quality check and bug detection? Any insights, tips, or shared experiences would be greatly appreciated. Thank you in adv

I originally shared this on LinkedIn — Smarter Permission Set Design in IFS Cloud — and it seemed to resonate with a lot of folks, so I figured it was worth a share here as well. Hope you find it useful! Feel free to connect with me on LinkedIn and swap ideas.Most ERP teams don’t think twice about how they structure permissions — until the week before go-live or the day the system breaks.If you've ever worked on an IFS Cloud implementation and suddenly hit a wall when assigning roles to users, you’ve may have encountered the Oracle role limitation. It’s a quiet constraint — but a critical one. Each user can only be granted around 48 roles, including both END_USER and FUNCTIONAL permission sets.In large, complex organizations, or even just well-designed implementations, it's surprisingly easy to hit that ceiling.After navigating these challenges on multiple projects, I want to share a framework that’s helps us stay organized, scalable, and within Oracle's limits — without compromising a

I am used to a different form of SQL from another ERP…I am finding some reports that have been written already for us have strange syntax  what does this sumbol do :  “for example:select “ field2,           'Draft' field3,        ''  engagement_id, I have tried to do a search on IFS quick report selects with “ in the code but nothing is returned.To that point - is there a nod page - whereby we can see all the additions / allowable features as I also found the use of (+) which is a short cut to left outer join. How can I know the full list of such ‘syntax features’ for use in my quick reports/understanding existing written queries in IFS SQL please.Thanks

We’ve been getting some strange errors recently when creating quick reports.  They seem to happen when the SQL for the report includes a subquery.The SQL is valid in that it runs fine in Oracle but IFS reports an internal error.  The IFS debug log shows: 11:46:25 ERROR - Command error: (INTERNAL) - Internal error. Invalid server response, expected JSON., details: [] undefined Oddly, we  have found that if we change the order of columns the error doesn’t happen.  This has worked for a couple of completely different queries.  We’re using Cloud 23R2. Has anyone else seen something similar? 

I work in IFS Cloud - updates 22.2.8.  When updating planned delivery time in customer order line to a later date than first promised, first promised is also changed.  We have printed the order confirmation first and checked in order details that this is the case in Documents shared.  Any one experiences the same now?

Hello  dear colleagues. We have in our Project the following Situation:Customer is having an issue in triangular transaction. As stated in the intrastat guide in intra community triangular transaction, the VAT number of the recipient of the goods must be entered into the intrastat line. Not the VAT number of the invoiced customer!!! However IFS always enters the VAT number of the invoice address/invoiced customer into the intrastat line. Furthermore, if the VAT number of the recipient of the goods is unknown, then the country code of the invoiced customer + 12x the number 9 must be entered (e. g. FR999999999999). Also, in the intrastat line, the checkbox for Triangulation is not set to True. I think some settings are missing, and this issue could not be solved by our support. It seems like this logic is not yet implemented in IFS.As a workaround this can be handled by doing manual updates on the Intrastat lines to assign the Opponent Tax ID that is referring the recipient of the goods,

Hello, we added some CF with percentage on ProjectMargin; 4%rate: 15,44%When we calculate 4%-15,44% the result shoud be -11,44 In the expression we added:TO_CHAR(ROUND(Project_Cfp.Get_Cf$_Mci_Marge_Planned(v.PROJECT_ID) - Project_Cfp.Get_Cf$_Mci_Taux_Fg(v.PROJECT_ID), 2), 'FM9999990.0000') But Aurena show -11% instead of -11,44 %Where can we define the number of décimals on percentage fields ? Any hint

We have requirement of POCO approval only for delta amount. we are not able Approve the POCO when the delta amount is negative. 

We have an issue with a issue with a customer that data mount is running out of space due to the high space usage of FND_AV_SCANNING_LOG_TAB.Is there a Cleanup job to remove these entries.Can someone assists to trouble shoot this issue 

When reporting time in mobile work order, IFS MWO Maintenance my comments are not populating in cloud 24R2. We are not using time clock to clock in and out, we are only reporting hours worked.I can see that Cloud = ReportComment but mWO is using ClockOutComment. Since we are not using the clockings where should we map mWO?Any help would be greatly appreciated.

Hi, I was wondering if anyone knows if Apps10 is compatible with punchout technology for eProcurement? Is there any documentation available on how this can be setup in Apps10?Thanks 

Hello community.Currently I’m in the middle of uplifting some lobbies from APP10 to Cloud (24R2). For the older version of lobbies I do get the “convert to IFS Cloud” option. For some lobbies it works fine but of some it doesn’t. Does anyone has knowledge on this option, such as it’s limitations and it’s capabilities?Thanks in advance. 🙂