Forum FAQs & Help

Hi all,I am wanting to call a DVLA api to get some vehicle information, can someone advise on the best way to do this please.  Using Apps10 update 24

 Hi everyone,I’m just trying to learning Report Studio and Im trying to create and bind table. When Im try to bind the table and preview, I only see the first row of the table. I cant see the other rows.I dragged and dropped translated text and field list labels into to report. And this is what I see. What should I do to see all the rows in the table? Thanks.

Hi Everyone,Is is possible to IFS HR module to add an ½ day public holiday in Substitute schedule in Working hours schedule ? Thank you in advance.

Hi Everyone,Does anyone have an existing userguide in Aurena for managers explaining how to: Authorize a leave request? Approve a timesheet? Approve an expense sheet? Any documentation, guide, or screenshots would be very helpful.Thanks in advance!( an why not also a userguide for end user also)

I am receiving an error saying “unc paths are not supported. defaulting to windows directory”  when trying to install Application Server locally  using  IFS Developer studio. Could anyone guide me  how I can avoid that error. ? Thank you! 

Can anyone tell me if it’s possible to manually connect or peg an estimate to a business opportunity and even a certain business opportunity revision? 

We would like to be able to display messages (announcements) in assystNET based on Contact User Query Profiles like you can with FAQ’s. The current method of using CSGs to do this is too cumbersome and requires a level of complexity that is just too much to administer

AttributeError: 'NoneType' object has no attribute 'getServers'

Our customer has noticed that their P/N on our paperwork is incorrect. Looking for a way to correct in IFS APPS 10 but can’t find any way to amend the current Customer’s Part Number in the customer order or Sales Part Cross Reference screen.Is there a way to correct the typo without having to create a new Sales Part Cross Reference part? And if so will all the customer order lines need to be cancelled and reentered?Customer order has over 100 lines with the incorrect customer P/N.

Hi I have a couple of barcode printers (low volume) and I have successfully setup the IFSPrintAgentConfiguration to point to a single IFS Cloud environment by following the IFS Documentation https://docs.ifs.com/techdocs/24r2/070_remote_deploy/400_installation_options/005_operational_reporting/020_install_print_agents/.  I would now like to connect the same printers to another IFS Cloud Environment.   Has anyone done this.  Is it possible to use the same installation of the IFSPrintAgentConfiguration?  

Bonjour, Mon entreprise utilise l’IFS comme ERP. Je suis actuellement dans le service de la maintenance et j’aimerais savoir si parmi vous,  certain utilise le module maintenance de l’IFS dans votre entreprise afin qu’on puisse venir voir le fonctionnement. En attentes de vos réponses, Luken BARCOS

Dear Heroes,I want to create an Execute Online SQL type Event Action to a particular table. I want to fire the event when the Rowstate column value equals to “Cancelled or Returned” both. How should I give the Conditions.I gave this like below. But it’s not workingNEW:ROWSTATE = Cancelled;Returnedhow to do this???

i want the tool thank you

Hello everyone,I'm experiencing an issue using the JSch library to establish an SFTP connection with an OpenSSH server configured on Windows. The error returned is com.jcraft.jsch.SftpException: Bad message.Here are some details about my setup:SFTP Client: JSch version 0.1.54 SSH Server: OpenSSH for Windows version 9.5Complete error message: com.jcraft.jsch.SftpException: Bad messageInterestingly, I can successfully connect to the same OpenSSH server using GUI clients like FileZilla and WinSCP, but the issue arises specifically when attempting to connect from our middleware server using JSch. Has anyone else encountered this type of error or have any suggestions on specific configurations to check or modify on JSch or OpenSSH?Thank you in advance for your help and suggestions.

dear All,any help?I want to calculate 8 fields and display the total in another fields

Can we stored emails as documents in IFS cloud ?  like say xxxxx.msg or 

Hi,I am having an issue when adding a Global Command using Page Designer for an overview (table) window in IFS Cloud. (24R2)When I add the command to the header section, it still requires me to select a record for the command button to be enabled.My goal is to have the command button visible and enabled at all times, regardless of whether a record is selected or not. I also tried adding the command within command groups, but that didn’t work either.Has anyone managed to achieve this? Any guidance would be appreciated.    Thank you.

Hello, I have a custom menu which runs a crystal report via a quick report passing it a parameter.  Is it possible to do the same and add an extra step which will send an email to the user requesting the report.Thanks

Hi I have to upgrade IFS Application 10 to IFS Cloud when install completed . I found  all namespece status is pending . Please suggest how to check root cuase.Please see as attachment. Database convert from non-cdb to cdb and plugin pdb database. Run install.tem for change to upgrade version.

Hi everyone, I am experiencing some issues integrating Power BI into the IFS Cloud, I am new to using IFS and Power BI so any insight would be much appreciated.I am hoping to understand if the issues that I raise are either based within IFS or Power BI.Below, I will add images to show my process and where potential issues are coming from. [Image 1] - Inputting the URL.Have I correctly inputted the URL with the additional suffix? [Image 2] - Sign in button.Should this page come up if I am already signed into Power BI?[Image 3] - Window pops up and immediately disappears.This occurs after pressing the sign in button.What should be shown on the window? Should it be an authenticator window? Would this issue be based in IFS or Power BI?[Image 4] - Option to open within a new tab or sign in again. Why am I being asked to sign in again, if I am already signed into Power BI? [Image 5] - The result of clicking on either link. Refreshing the page has no impact, still comes up with ‘page not foun

After I batch create users, I would like to find a way to mass update those user’s email. Does anyone have a suggestion or know how that can be done?

I cannot respond to most of the thread on the forums :(  I used to be able to respond to any community post but I don’t see that option anymore 

Hi IFS TeamI was thinking, say, when someone searches through the IFS Community, can the KBs also show up? I am referring to the search results in this link. Knowledge Base - Service CenterIt would be great if you can make them linked. At least for known errors, it would help us, customers, that a fix is planned in a SU for a future version. Thanks,Asela 

I would like to create a quick report that allows multiple WO_NO entries.Unfortunately, I get the error message‘You may only specify a single value for the Report Parameter: Work_Or’.I have tried thousands of variations, but nothing works.However, the condition ….AND woco.wo_no in (54046, 54037) works.

We have identified a performance issue for a customer, FACT_PROJECT_CONN_DET is taken 3 + hours to do internal IFS data mart refresh. The Refresh for FACT_PROJECT_CONN_DET is taking 3+ hours to run on each refresh. They have set a separate refresh category to run this overnight, but as they informed it is now impacting their month end process as they cannot run data mart jobs in parallel. With the timely manner performance issue got worse up to 9+ hours with the growing data load of 7+ million in the environment.Note:Highest time-consuming SQL query running when refresh data mart for FACT_PROJECT_CONN_DET.INSERT INTO PROJECT_CONN_DET_MVTSELECT * FROM ( SELECT F.*FROM PROJECT_CONN_DET_MVS FWHERE ((F.PROJECT_ID) IN (SELECT P1.PROJECT_ID FROM T1512369F9074D569E0635904F_TAB P1))OR ((F.ACTIVITY_SEQ_KEY) IN(SELECT A1.ACTIVITY_SEQ FROM S1512369F905BD569E0635904F_TAB A1))OR ((F.ACTIVITY_SEQ_KEY, F.OBJECT_TYPE_KEY, F.KEYREF1_KEY, F.KEYREF2_KEY,F.KEYREF3_KEY, F.KEYREF4_KEY, F.KEYREF5_KEY, F.KEYR