IFS Solutions

The Art of IndexingIn an online transactional database, administrators tend to avoid adding indexes because of their impact to inserts and updates. This is true in a laboratory setting, but a real-world system has to deal with a collection of concurrent workloads. OLTP ERP systems tend to be very read-heavy, in the neighborhood of 94% in my experience. Reducing the aggregate read load can free system resources, and if that means getting the system out of a heavily-loaded state, intelligently adding indexes can indirectly (and paradoxically) improve real-world write performance. Your mileage may vary. I recommend iteratively measuring the effects of tuning your own system rather than following any given recipe. "Match Case"Oracle string comparisons are case-sensitive, unlike Microsoft SQL or MySQL. This means the query hints in Enterprise Explorer do not accurately reflect the effects of the "Match Case" flag, since extra work is necessary to scrub the table's values to uppercase first,

Hi all, I met an issue for triggering a user interaction workflow when clicking Ok button of Order Address Dialog. It is an easy workflow which I attached it.Reproduce steps:Click Operations-> Single Occurrence Address Check Single Occurrence. Click pencil edit button Modify Delivery Address with some not quiet correct address, click OK Click OK for Order Address then error pops up quiet often though not every time. Or the page was stuck in Order Address Dialog.Two scenarios I met:Page was stuck   Error page, I attached the error details.( General: Date = 2026-02-09T16:31:35.075Z Client version = 25.1.5.20251008163646.0 Browser name = Chrome User agent = Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0 )  

A Day Type was created to allow for ½ hour lunch period that is not auto-deducted. The intent is that Employees are required to clock in and out for lunch and that ½ hour would be counted towads time if they did not. It also allows the expected start time and end time of the scheduled day to display correctly.   The result is that the ½ hour extra time between two normal time periods is not counted. Only the extra time before the start of the normal time period at 7am and the end of the normal time period at 3:30pm are counted if the Employee clocks in at 7am and out at 4pm yielding 8.5 hours instead of the expected 9 hours of reported time. Why is the extra time from 11- 11:30 not included?

Hi,We are currently using IFS APP9 with the Backflush method for material issuing.We have noticed that, for some shop orders, the system issues more material than the required quantity. Upon investigation, we identified the following two issues:Required Material Quantity Calculation, The required material quantity is displayed incorrectly, as the system appears to ignore decimal values during the calculation. Backflush Material Issue, During the backflush process, the system issues excess material, again seemingly without considering the decimal values. As a result, the issued quantity is higher than the actual requirement. I checked the inventory part→ master data. qty round up is properly updated.The lot size is 18, Reported qty is 17.  Please help me on this. Regards, Tharakan                             83 0 85

It’s great having Payment Information section in the Employee Masterfile which allows to define multiple bank accounts with different Value Types. However, if the customer uses the Expense Payment process in the Expense Management module, then the bank details needs to be defined under the Property Codes, as the relevant Property Codes has to be connected to the Employee Payment Methods Basic Data. Defining the same information in 2 different places in the employee Masterfile is just a duplication of data and during the data migrations and integrations 2 places needs to be updated. Is there a way to generate the employee payment files by using the Payment Information defined under the compensation data without using the Property Codes?  Thanks

I’m trying to set up a third-party integration on using the Payroll Integration in 25r2.I’ve set up the Provider and am able to add a line to the Payroll Transfers page. However, when I select that line > New File, I get an error that the provider has not been fully implemented. I know at that point, it hits a “VrtTransferPayrolls” call but I’m stuck there.I don’t actually want to send a payroll file and I’m willing to create a dummy file if needed. My goal is to get Payroll Transaction lines to populate. I know that “new file” button will aggregate records from travel, time..etc. and create those lines, however - I just need to get over that error message.Is there any documentation on what is required for a third-party provider to be implemented so that the Transfer to Payroll assistant does not throw that error?

Hi, everyone!Yesterday morning (around 11AM - Brazil) we started the installation of the following deliveries:‘initial’ delivery (1.0.0) for customer XXX (running on server XXX) customization delivery 4.12.0 for customer YYY (running on server YYY)     NOTE: Both customers use IFS Cloud 26R1 (26.1.1)At the very first execution for customer XXX (delivery 1.0.0) the error below was shown:[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Installer Action: install[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Installer Deploy Step: all[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Installer version: 26.1.1[Mon Jul 20 11:46:20 BRT 2026][INSTALLER] - INFO: Java: build 11.0.29+7-LTS[Mon Jul 20 11:46:21 BRT 2026][INSTALLER] - INFO: k8s (client): v1.34.1[Mon Jul 20 11:46:21 BRT 2026][INSTALLER] - INFO: k8s cluster: https://XXXXX.XXXX.com.br:16443[Mon Jul 20 11:46:22 BRT 2026][INSTALLER] - INFO: k8s (server): v1.34.1[Mon Jul 20 11:46:22 BRT 2026][INSTALLER] - INFO: auto scaler: 2.18.0[Mon

When registering arrivals, what is the difference between the Qty to Receive and the Inventory Qty to Receive? Example of fields: 

I am currently working on a new pallet label using Crystal Reports within our IFS Apps 10 environment.As part of the label requirements, we need to print a GS1 QR Code on the pallet label. After reviewing the available options, we are considering using the IDAutomation QR Code Font and Crystal Reports Encoder to generate the QR code within Crystal Reports.As our Apps 10 environment is hosted by IFS, I would appreciate some guidance from anyone who has implemented a similar solution.Specifically:Does a Service Request need to be raised for the installation of the IDAutomation QR Code font and Crystal Reports encoder on the server hosting the Crystal Web Service? Has anyone successfully deployed IDAutomation QR codes in an IFS-hosted Apps 10 environment, and if so, were there any challenges or considerations? Would the installation require any system downtime or service interruption?Any advice or experiences would be greatly appreciated.

We have issue regarding the MRP Snapshot.Actually, we have for a part, a Shop Order to produce the part SO#1 for Part#9.During the night, the MRP is running and start by the Snapshot.We have production team that is working during the night.First snapshot : Inventory. No Part#9 in stock. (duration 5 minutes)During this Snapshot, we close the SO#1 and receipt Part#9 in inventory.Second snapshot : Shop orders - Customer Orders….(duration 5 minutes) SO#1 has been closed so no Shop Order. The result is : MRP didnt see the Inventory, and didnt see the Shop Order.So, he will propose a Shop Order Req to produce Part#9.And we have Shop Order process type that will transform the SO Req into SO just after MRP. Is there a way to : Pospone rception during the Mrp calculaton and record it after ? Forbid reception  during the MRP Calculation ? Actualy , our workaround solution is : Quick Report to identify the Parts that have been received during the snapshot Relaunch Part MRP on these parts  Generat

Would like to check if anyone had come across with UK GAAP requirements related with leasing contracts in IFS and how the mapping should be  done (FRS102 )Additional requirement for a short term lease not to include purchase options Ability to apply the Obtainable Borrowing Rate FRS 102 requires lessees to disclose a maturity analysis of its lease commitments for exempted short-term leases and leases of low-value assets.

Has Anyone using available functionalities in IFS on the PPWR regulation in EU? to manage the data such as DoC and material weights? https://packintelx.com/blog/eu-declaration-of-conformity-packaging-manufacturers/

Good morning,I interested  to checked if anyone use this postings control in Romania and what accounts are linked to.Thank you in advance!

Hi all,We're on IFS Cloud (managed SaaS, hosted by IFS, 25R2) and we're evaluating enabling Analysis Models (Tabular) with self-hosted BI infrastructure. We've been working through the technical docs but, before committing, we'd love to hear from people who've actually been through it. Docs we've been looking at:Scenario 3 (BI infra in Azure, customer-managed): https://docs.ifs.com/techdocs/25r1/050_reporting/010_analytics/010_analysis_models/000_am_tabular/000_biinfrasetup/010_infra_setup_azure/ Scenario 2 (Azure, IFS Cloud Remote): https://docs.ifs.com/techdocs/25r1/050_reporting/010_analytics/010_analysis_models/000_am_tabular/000_biinfrasetup/009_infra_setup_azure_2/ Scenario 6 (on-prem): https://docs.ifs.com/techdocs/25r1/050_reporting/010_analytics/010_analysis_models/000_am_tabular/000_biinfrasetup/020_infra_setup_onprem/A few questions for anyone who has deployed this in production — either managed service (IFS-hosted + Azure BI) or on-premise:Did you stand up the full stack (A

Hi everyoneWe are currently creating a concept for our development process for IFS Cloud Upgrade. We are planning to use DevOps on our own Doppelmayr Azure Tenant for handling all kind of Issues (BacklogItems, Developments, Bugs, Tasks, Testcases, etc.)We are used to mention the issue key in our commits for the customized sources (.plsql, .projection, etc), so that there is an automatic connection between the Issue and the source (visible in DevOps).The issue now is, that the code resides on IFS DevOps and the issues are on our DevOps so we cannot link the commits to the issues anymore. Has anyone the same requirenment or even a solution to that?Best RegardsMatthias

Simply, how do I filter non-extensible PersonInfo entity selection LOV on client? No developer studio is allowed. We want to not show all of our ERPs people on quality assurance person selection drop downs when we only care about a subset we would curate. 

Where can I find the code definition table for inventory transaction codes, like OOREC? Is there a basic data table that has all codes and their definition or description? Thank you,

If you purchase something and pay for it with a corporate credit card, how do you record it through IFS Cloud?

If you sell something and the customer pays for it with a credit card, how do you record it through IFS Cloud?

Hi, In Apps 10 - adding custom fields to LEDGER_ITEM_CU_DET_QRY. Works ok as read only. We can add Persistent Fields but it will not let us enter data in the client.Any ideas on why this is and if there is any where we can add this in the client?Current alternative thinking is to use  a Custom LU to enter data which will be picked up by LEDGER_ITEM_CU_DET_QRY. This is for an invoice query management system - so need to be visible on the screen that Credit Control use,

Hi, I’m experiencing an issue with the file name of the Reminder Letter report.A customer reported that they received the email with a seemingly random attachment file name. However, when I checked the corresponding Application Message in IFS, the attachment file name appears to be different and looks to be the correct oneI'm struggling to identify the reason for this discrepancy. Have you come across this behavior before, or do you have any idea what could be causing it?

Hello, I face this issue  as you can see in the screenshot below while trying to post a manual voucher. Is there a problem linked to permissions ? How to check if it’s the case ? Best regards  

IFS Cloud 25R2 - We have a supervisor set up with access through the organization structure and supervisor access setup.  The view of all supervised employees appears correctly, but he receives an error message of “user does not have access to this employee” when selecting Start Indirect or Start Production.  The supervisor was an active employee in Apps9, migrated to Cloud, was then terminated as an employee using the standard Terminate Employee process.  Supervisor access was configured afterward.  Another supervisor with identical permissions and supervisor access, that was not previously set up as an employee, works correctly.

 I use PurchaseRequisitionLineAuthorizationsHandling  and action AuthorizeRequisitionLinesThats my json {"FullSelection":"LINE_NO=1^RELEASE_NO=1^REQUISITION_NO=1234^SEQUENCE_NO=1^","ChkptUsername": "username","ChkptPassword": "password","ChkptComment": "comment"} What is wrong ? I receive message:"ORA-40441: JSON syntax error"

We need to list all the endpoints preferably module wise to restrict the access and maintain the application security.Please suggest.