IFS Solutions

We are currently in a dialog on a case with Support for improvements, but I’m curious about response times for other cloud customers in GL Balance Analysis/GL Balance Analysis Basic.Queries like the example below returns 84 accounts + balance in about 5 seconds when there are about 60 000 records in ACCOUNTING_BALANCE_TAB for the filter. A similar search for other accounts use about 2 ½ minute to return 33 accounts +balance for about 1,2 millions records for the filter in the same table.Our Size on Disk represent the amount of data since Go-live in April 2023.I’m looking forward to get more knowledge about your experienced response times for similar queries, your size on disk and if you have enabled the In-Memory Acceleration Package.Example search for year, period(s) and account(s)

Functional Scenario:Customer has a sales contract linked to a project. Sends several AFPs. After a specific point a final invoice which has the complete amount on it and also shows the deduction of the already paid AFPs is created. Problems/Issues:Sales Contract does not provide any kind of “Final Invoice” it is always just the project invoice based on AFP and that is based on the certified/confirmed amount. When matching the payment in advance/payment on account with the AFP. IFS automatically creates an invoice. This leads to the issue that we are not able to offset the previously paid AFPs against our complete “final invoice”. We are currently not able to have a process with advance payments via AFP and a final invoice that shows/includes the previously paid AFPs. Are we missing anything here or is such a scenario just currently not designed/considered in the sales-contracts yet?   Kind reg

I’m currently experiencing issues when pulling my GL Actuals into my Planning Entry when completing a forecast for the remaining year.I use the standard functionality to complete this task, however, I get the following error message.This will be across multiple companies, The message does not allow me to determine which items have uploaded and which haven’t. I don’t have a mechanism to allow a quick review and is very labour intensive.Has anyone experienced the same issue, or have a better process to complete this?Any help would be much appreciated.Thanks

Five vulnerabilities have been discovered within the Ingress NGINX Controller for Kubernetes on the 24th of March 2025. NGINX Ingress Controller is a tool used in CE Kubernetes environments to manage and route external traffic to services within the cluster. Ingress Controller acts as a reverse proxy and load balancer, supporting various protocols like HTTP, WebSocket, GRPC, TCP, and UDP, and also provides features such as content-based routing and TLS/SSL termination. Vulnerability detailsCVE-2025-1974 - ingress-nginx admission controller RCE escalation CVE-2025-1974 is a critical 'improper isolation or compartmentalisation' vulnerability with a CVSSv3 score of 9.8. An unauthenticated attacker with access to the pod network could execut

Hi all,I am currently exploring best practices for utilizing the Internal_Part_Issue_Pub table within the context of Demand Planning. I’ve noticed that the table includes multiple transaction types, and I understand that the appropriate configuration often depends on specific business practices.That said, is there any recommended or commonly used Source_Ref_Type or Transaction Code for standard Demand Planner base flow configurations?Any insights or guidance would be greatly appreciated. There is the where condition used in this view. SELECT tran.part_no                                                                                                part_no,       tran.contract

Hello All ,while we  trying to set IFS 23R1 on GCP cloud we are getting error  below error no steps when we need to create SSH key for remote access. Any pointer to resolve this error, we have updated the etc/hosts file also update  the main.ps1 as we are not using 22 port but still below error shown its picking port 22 only.. D:\ifsroot\utils\..\config\secrets\.ssh\gmu-co-ab__com_id_rsa already exists.Overwrite (y/n)? yprocessed file: D:\ifsroot\utils\..\config\secrets\.ssh\gmu-co-ab__com_id_rsaSuccessfully processed 1 files; Failed processing 0 filesAdding Public Key to Linux Boxssh: connect to host gmu-co-ab__com_id  port 22: Connection refusedExcution Failed: Error occured when adding Public Key to Linux BoX.2023-10-25 10:22:51.93   GMUVDIFS-COE-01 Stop  Add-KeybasedAuthWithLinuxBox RegardsSujeeth S

Hi All,When a customer order line is connected to a staged billing profile and once a stage has been invoiced, it is not possible to cancel the CO line even after creating a credit invoice. When trying to cancel the order line, the system raises an error that 'The order line may not be cancelled when invoiced stages exist'.I have created the following Idea for the above issue.Please share if anyone knows a workaround.

Can I also use these two SQL statements as a combination.I need the issues for sales orders plus inventory issues. Thanks for your help.Henning

Hi , Getting the below error, while trying to change IFSAPP password Details: IFS Web Version: 24.1.2.20240704080601.0Date: 2024-08-25T16:45:59.640Z --------------------------------------------------------------------------- UserHandling/Users (server error)Unable to fulfill the request due to unexpected server state.Error details: N/A Request Id: 562f8377-940e-4e60-a38f-72c0c2c8ff8eUrl: https://***********/main/ifsapplications/projection/v1/UserHandling.svc/SetUserPasswordCan anyone help to resolve the issue?Thanks in Advance 

Hi all,Users should not have access to the document revision page, but only to the document detail page here: However, the problem is that the link here in the document attachments always refers to the document revision page. Is it possible to set/change this somewhere so that this link button goes to the document details page? Thanks, Mike

Where can we get a listing of transaction codes from the ERPs to allow us to analyze which transactions we would consider “manual journal entries”. Are these codes subject to stricter control within and outside of the IFS system? Also does IFS APPS10 have the capability to implement a “park/post” feature that enforces segregation of duties for manual journal entry prep and post? Thank you,

Hi,I am currently working on an Avalara tax integration for a Canadian customer.Does anyone have experience with Avalara Tax integration for a Canadian company? Your insights will be most valuable when sorting the questions below. 🙂The correct tax amounts are in the application message for the Avalara tax return. However, IFS fetches only PST/HST/QST taxes, and the GST amount is dropped from the Customer Invoice tax line. 1. Is there any special IFS Application setting for a Canadian delivery address?2. Why are GST/TPS taxes not fetched in Customer Invoice lines?3. Why does the Application receive the country as the jurisdiction code for the GST/TPS tax line?4. Is there any special configuration on the Avalara side for Canadian tax? SS - Application Message SS - Customer Invo

Hello,I am not sure why our task.schedule_value is changing from 20000 to 38000. BR 99 is set up to update task.schedule_value to 20000.Response Code value is blank. 

We have just upgraded to 24R2 and I’m trying to change the default value for a customer order to the identifier reference from the Customer. I have the Value in the Site set to this: ${CustomerInfo.IdentifierReference} but I’m unsure how to filter to the particular customer selected by the user.

Lesson I have learned:If you need a REST API with any SQL statement, you can use either the Query Designer or Quick Report.Example of using REST API with Quick Report:https://MY_SERVER/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_xxxxxx(my_parameter='1234')) Note: xxxxxx is a randomly generated number when we create a Quick Report.Remember to use an underscore in QuickReport_xxxxxx.  

Hello Dears i want to get some ideas about how i can track the No. of invoices that were either posted or Noted in Posting proposal for a specific user  i have asked each one to type his name in the invoice receipt field in the invoice header , but i have no idea how to get use of this data and how to fetch it 

Is anyone using this space in Cloud and might have documented instructions they are willing to share?  

When converting a Lead to a Customer, we ‘d like to make the Account No field read only or hide it from view, to prevent users from manually entering details.How do we do this in Cloud (23R1), is is possible? 

As Part of a Service Management implementation we’re considering setting up the Service Technicians vans as a form of Mobile Warehouse but the Support documentation we’ve been able to find indicates that this is primarily intended for use in Part Searches, it makes no reference to what impact this would have on MRPIf our client manages some of the items contained within warehouse type VAN, will these parts be considered when MRP runs if they are also managed on a Safety Stock or Reorder point planning basis?

We are using the Advanced Planning Board to schedule resources within [certain] work centers. (The resource represents employees/workers rather than machines in our setup.) The APB tool is not loading the resource with its maximum capacity each day. Rather than loading a resource at the full 8 hours it can handle, we are seeing 4-6 hours being allocated per resource per day. Is there a setting or configuration needed per resources to achieve this?Because the resources are not scheduling to their full “potential”/capacity, the work center is also showing less 100% capacity each day (generally we are seeing around 60% capacity for the work center).We would like the APB tool to schedule these resources at their full capacity, resulting in work centers at [or close to] 100% capacity each day.

Hello everyone,I'm looking for some insights on how to set up planning within the IFS Project module. We want to implement planning for purchase requisitions and purchase orders in the context of projects.Has anyone already configured this kind of setup in IFS?Are there any best practices or specific functionalities to activate (e.g. links between project planning, procurement needs, milestones, etc.)?Thanks in advance for your help!

24R2. As soon as work task is finished IFS automatically generates time records for assigned person/employee.Is there a function to roll out this record/records for all Team participants?Customer needs information of time records spent by every Team member.

I use the Child Relation Editor to link to related tables without issue. In the example below I can successfully link to PRODUCT and use field form PRODUCT on this screen.  I now want to link to product_ext so the link would be stock_serial_id → product → product_extHow do I do that? I have tried the below.  However I get the error below when adding a field from PRODUCT_EXT so my linking method must be incorrect.  Any help on the correct procedure would be appreciated.Thanks,Barry

Hello, If we have a task that is allocated to a resource, they have not clicked on any statuses, if the resource wishes to move that task to the following day, i just want to confirm that the drag drop function applies to this scenario. Can we simply drag the task to the following day in console if it is the same resource without restrictions?  

It is my first time using ACTION with an IFS REST Connector for Cloud in Boomi. I am specifically using the Invoke action “PromoteToObsolete” on a document. This is the Post request:https://**********************.com/main/ifsapplications/projection/v1/ManageDocuments.svc/DocIssueSet(DocClass='{DocClass}',DocNo='{DocNo}',DocSheet='{DocSheet}',DocRev='{DocRev}')/IfsApp.ManageDocuments.DocIssue_PromoteObsoleteI’ve been using this forum to help me start but I think I’m stuck because I have multiple parameters that I need to pass. I am currently receiving a Bad Request so there must be something wrong with the way that I am passing the parameters.Before my Connector, I set up a “Set Property” shape of a Dynamic