Solved

Afternoon all, I have come across an issue that I am sure has plagued others before. Way back in the heady days of 7.5 being implemented the business made a decision to opt out of a numerical ID system for our Person and User ID records. Instead we opted for <First Initial><Surname> e.g. NTAYLOR. The problem we have is that one of our users got married and now the Person ID and User ID do not reflect her now taken name and has asked if we can update the Person ID/User ID to correctly reflect her new surname. As these are somewhat key fields within the system I am pretty sure there isn’t a standard way of achieving this as it would need to flush the entire system to update everything that was ever posted with these ID’s. If anyone knows of a way how to do this or (for the IFS employees) if  a data fix exists for this kind of change it would be interesting to know!   Regards Nathan

Hi all, I constantly have to deal with the mutating table error when creating events. Usually I need to: Save (F12) Run some PLSQL in an custom change event (mutating if same table involved) The only solution I know, is to start a background job. However, for some scenarios I need the code to run “online” or lock the UI until the job has executed.   Does anyone has some solutions for this?  

Hi,I want create task automatically based on product selection Bill of material.Suppose if i selected product in request and if that product model or task has BOM,task needs to be created for each model/ part in BOM.I am able create task for product when it is selected in request through XML business rule, is their any way i can create tasks for BOM also,Please suggest.  ThanksRamya 

Hi,   We are changing our domain name lets assume from aaa.com to bbb.com. What will be its impact on application? Do we need to reinstall the application or reconfigure will work? Any other suggestions, please guide.   Thanks & Regards Shitanshu 

Hi all, For a customer, i need to hide the “Confirm Differences via Change Order'” RMB on the Purchase Order. I have checked the permission sets but i cannot seem to find this pop-up in there.Thank you for your help!

We currently have IFS Application 10 Update 8 installed in our environment and we plan on moving from IFS Enterprise Explorer to Aurena in the coming months.  I’ve been playing with the Aurena environment and I haven’t been able to locate the Time Clock terminal within Aurena. Do anyone know if IFS as ported the Time Clock terminal to the Aurena client or do we need to wait until a future IFS Application 10 Update packag? Thank you,William Klotz 

Hi, we have a Work Task Template with Revision Control enabled on it.On the Active revision, IFS correctly restricts the ability to add new lines into Work Task Steps etc., however it allows Work Task Steps to be deleted on the current Active revision.Shouldn’t revision control prevent Work Task Steps from being deleted from an active revision Work Task Template, or is this normal and why?Running Apps 10 Update 6.

We have a Counter lobby element that when we drill-down it is loading all CustomerOrders- not just the ones for the SQL behind this element.The SQL uses an IAL - RW_ORDERS_SHIPPED_TODAY2, which is built on another IAL (RW_ORDERS_SHIPPED_TODAY).I’ve done other lobbies where the drill-down works, so I don’t see what’s different with  this one, unless somehow IALs aren’t recognized? select count(*) from ifsinfo.RW_ORDERS_SHIPPED_TODAY2where contract = 'W'

Hi,Can anyone please explain why will we use physical and organizational service groups in FSM what is the purpose of these groups.I know how creating groups and applying in person, place records please explain where these groups reflect. ThanksRamya 

Hi I am a IFS 10 user on update 8 and when I try to update a Aurena Lobby using the EE Lobby Overview config Mode it doesn’t take effect in the Aurena page. This never used to be a problem in Update 7. Am I missing something or does anyone have any suggestions for me to try? Cheers Jack

Hi, About the training path for FSM Developer, we have training for : Mobile development, Integration, but do we have trainings for technical administrator ?FSM6 can be installed on saas or on premise, if you make a on premise installation you can have some tasks for installing the software. In the training path for partners do we have some courses/documentation about all this required tasks ? Could you explain how partners could be upskill and expand capabilities on this area of installation ? Thanks & Regards 

I’m trying to get media working in our test system on fault reports - LU ActiveSeperate. I have added Media to the Object connections and can see it on the screen but when I drag an image to the record I get the following error message:We have just applied Update 17 to this environment so unsure if this is an update issue or if you can’t use media on fault reports or if I’ve not configured it correctly.Thanks Sarah

Hi All,I am using IFS 7.5 and running “Perform Site MRP” batch job.System hit error as below and not able to proceed to create PR.Anyone know what should I check?Thanks. ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at "IFSAPP.MRP_PROCESS_API", line 3339ORA-06502: PL/SQL: numeric or value error: character string buffer too smallORA-06512: at "IFSAPP.MRP_PROCESS_API", line 3004ORA-20110: PurchaseReqLinePart.NEG_QTY_: The quantity must be greater than 0.

Hello, I am looking for a way to prevent our Logistics department from Delivering/Completing a shipment without approval. Currently, we have been experiencing issues with incomplete data being filled out by our shipping clerks. This is leading to post-shipment cleanup transactions. I’ve noticed in Shipment Type, there is an Approve before Delivery checkbox. The help seems to indicate that enabling this will require a shipment to be approved before Delivery can be made. Unfortunately, there is not additional detail on how this approval works. Has anyone used this feature before? If so, how is the approval setup? Any help would be greatly appreciated. Thank you! 

Is there a standard integration (either CONNECT or CONNECTIVITY) for the Shipment/Consolidated Shipment? Also, will be good to know is if the extension modules have this integration if not in core.  

Navigation :Financials\Supplier Invoice\Invoice Workflow Basic Data\Invoice Posting Authorizer GroupsFinancials\Supplier Invoice\Posting Proposals For our invoice authorization, we are using Invoice Posting Authorizer Groups linked to our organisations. Those groups can move regularly due to new started, leavers or people changing organizations.Unfortunately, those changes don’t get reproduced automatically in the Posting Proposal/Authorize tab/View Authorizers Group Members. This creates problems as the modified users cannot access the invoices although they should now be allowed. Is there a way in IFS to deal with that problem or does it need a new program to be developped ? Thank you and Kind Regards, Anne-Sophie

In Supply Chain IE version the Customer Credit Control Group is selected in Sales > Customer > Customer > Credit Info > Order tab from the list of values created in the “Customer Order Credit Control Groups“. I am unable to find the corresponding scree in Aurena. I hope some one can help. 

Hello,I dont know why, but my streams and tasks are  not working. Which area i should check for the solution can you tell me?Best Regards. 

Trying to sort a column by order process and not alphabetically for a Lobby and it doesn’t like the as Status format.The similar quick report works fine.Is this not possible in a Lobby? case when state = 'Blocked' then '1 - Blocked' when state = 'Planned' then '2 - Planned' when state = 'Released' then '3 - Released' when state = 'Reserved' then '4 - Reserved' when state = 'Picked' then '5 - Picked' when state = 'Partially Delivered' then '6 - Partially Delivered' when state = 'Delivered' then '7 - Delivered' end as Status Quick report has desired seqeunce: Lobby is currently alphabetically: 

Hi,is there a way to create a pdf outrput?I can create but does not. Tks

Trying to search for all planned start dates that are 14 days old. I can search using >TODAY but cant find out what other functions i could use to search for dates without actually using dates. Can’t use “Yesterday” or “Last Week”   if i do try one of those i get the following value    

Hi All,   We have this unsupported tool (Simple Migration Tool.xlsm) and it works fine except for at one customer. They get the error “Could not unlock memory location. Copy aborted.” when hitting the Export button. Have you seen this error before? How did you solve this?  MS Office installation is 365 ProPlus (same as what I have) the macro code bit is…'Unlock the memory.  If GlobalUnlock(hGlobalMemory) <> 0 Then    MsgBox "Could not unlock memory location. Copy aborted."    GoTo OutOfHere2  End If... Many thanks.

Hi,What is the functionality associated with ‘Connected Boxes’ tab in Shipment? Is there any documentation that I can refer to know more about this tab? Seems like this is part of retail extension and will be great to receive some inputs.Thanks,Harini

Hello team,  I develop custom field or page and IFS doing some updating patches then custom field or page is visible in that case. 

Hi Community I have created a Persistent custom field in Sales Basic Data → Salesman to enter Sales manager of each salesman.  I have created another custom field in Customer order → Misc Order info tab and I want to update Sales manager’s id into that custom field using an event.  i created an event to achive that but i am getting no result. Customer order doesn’t fire any error too. Can you let me know where the issue is ?   DECLARE  SalesM_ VARCHAR2(20);  pragma autonomous_transaction; BEGIN  SELECT CF$_SALES_MANAGER    INTO SalesM_    from SALES_PART_SALESMAN_CFV    WHERE salesman_code =  '&NEW:SALESMAN_CODE';  IF CUSTOMER_ORDER_API.Get_Authorize_Code('&NEW :ORDER_NO') = 'IWT' THEN    UPDATE Customer_Order_Cft        SET CF$_S_MANAGER = SalesM_     WHERE rowkey = (SELECT rowkey                          FROM Customer_Order_tab                          WHERE order_no = '&NEW:ORDER_NO');  END IF;END;