IFS Solutions

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   

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.

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 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 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, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object L

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, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object L

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