IFS Solutions

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?

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. 

Hello everyone For a certain project, we have planned revenue of 293,767.59 in the Project Navigator. How can the planned revenue amount changed? Can it be changed by changing the amounts in the customer order?  Would appreciate any guidance on this.  

We are in the process of setting up and implementing IFS Cloud and I have a concern around purchase requisitions to purchase order behavior. I am running MS One Part and MRP to generate purchase requisitions. The purchase requisitions are being created as I expect. However, I have concerns about the behavior that is taking place when converting requisitions to orders. As demonstrated in the upper section of screen shots below, when a 7/23 requisition was created through MRP, and I converted it to a PO, and re-ran MRP, the 7/23 requisition was closed as expected since the need was replaced by an order for that date (7/23).In the lower section of the screenshot, I converted a purchase requisition in the future (9/1) to a purchase order to send to my supplier as they require a lead time on orders in the future which is typical for many of our purchase parts. I expected (and need) that the 9/1 requisition would move to closed and it did do that. However, it closed the 9/1 requisition, elim

Hello,can any one suggest way/steps to clone production environment to Test environmentSpecially users. RegardsPankaj

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

Hello Community,We are using IFS Applications APP 10-UPD 15 version. Currently we are trying to Automate AP processing and decided to use E-invoicing with PEPPOL to receive all our supplier invoices. But we are not quite sure what is the setup needed in IFS Applications in order to process the PEPPOL einvoices/xml files we receive from the Access Point. Really appreciate if you could let us know the steps or some guidelines as to how we should do this setup in IFS.