IFS Solutions

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 t

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, espec

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

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 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.

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. 🙂

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

We are trying to use the IFS supplied currency rate downloader BPA workflow as it is described here:  Finally we could get it to work which is nice.The normal way it works is in the background initiated by background jobs.However we cannot find a way to get notified of the errors that occur in the workflow (for instance webservice to download from the currency rates is not accessible).Background job reaches state ‘Executed’ and does not reflect any error.How can the user/admin get notified of errors in this kind of asynchronous workflows?It is Cloud 23.2.0.

I want to set up an event to automatically add an Approval template every time a Budget is created on a Work Order.I have an event I’ve used before, but looking at the key reference, I have two questions: Approval template links to the individual cost type, rather than the Work Order Budget total - is there a way to change this?If answer to above is approval can only be linked to cost type - WORKORDERBUDGET when selected in an event is missing the ‘WORK_ORDER_BUDGET_COST_TYPE_DB’ field which is used in the key reference - what is the best way to get this into the event - is there a SQL expression that can be added?i.e. Key Reference for approval template is - WO_NO=20287^WORK_ORDER_COST_TYPE_DB=E: 

Apologies if this has been asked.I am looking to created an advanced search within the Inventory Part in Stock screen within IFS Cloud. I want to be able to retrieve a list of stock records which are classified as Manufactured Parts.Within EE you could add in API calls to advanced searches,inventory_part_api.get_type_code(contract,part_no) = ‘Manufactured’Does anyone know the options for this rather than added a custom attribute within this screen? Thanks,Jamie

Im creating a migration job for our users to be able to move part data to a new site quickly. I understand there are the copy parts and copy part windows but these dont satisfy our conditions. I made a migration that joins each associated view the inventory part has, however when i pull the data in i get hundreds of duplicates. this is what i have in the FETCHCONDITION rule ID  

Hello , I have excel layout with .rpl extension ,is there any method to redesign this document and add some features. 

After the Windows 11 update I can't export in Excel an IFS Business Reporter file.I usually go to the 'Manage Reports' function in the tool bar and then "Export" the report. Which then saves the file as an excel file.I have been using this method successfully for years until my laptop has gone through the Windows 11 update. I am now receiving the below error message: Any idea how to resolve this issue? Thanks The error details as follow:System.Runtime.InteropServices.COMException (0x800A03EC): Excel cannot open the file ’tmp30AB’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.   at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Ob

After the Windows 11 update I can't export in Excel an IFS Business Reporter file.I usually go to the 'Manage Reports' function in the tool bar and then "Export" the report. Which then saves the file as an excel file.I have been using this method successfully for years until my laptop has gone through the Windows 11 update. I am now receiving the below error message: Any idea how to resolve this issue? Thanks The error details as follow:System.Runtime.InteropServices.COMException (0x800A03EC): Excel cannot open the file ’tmp30AB’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.   at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Ob

How do I move or change items from a location type of quality assurance?

We want to be able to restrict by Permission Set who can edit a the Price/Currency or Price/Base on a Customer Order Line.  We cannot find such a granular solution - is there one in Apps 10?Is there one in Cloud and if not does anyone want it added to the ‘Ideas Wall’?

My requirement is to update the label ‘Due Date’ to ‘Payment Due Date’ in IFS Invoice Report Layout I can't simply remove it and replace it with plain text, as it needs to support translation into multiple languages. Is there a way to change the label without affecting functionality?

We have a supplier that is blocked for payment, they are paid by ACH.  The system is still letting them pay thru the normal ACH process.  With our suppliers paid by check we get an error message that they are blocked, not happening with the ACH suppliers

Is it possible to add extra decimal places to a Lobby Pie Chart. We have one that has two values 31 and 8004 that have the percentages of 0% and 100% and want it to not round.