Solved

​Hello everyone,I have a tricky problem for you.As part of a go live project with IFS APP10, we migrated the financial data, including the ledgers. We went through external assistant and everything went smoothly.Later, the finance team realised that for many rows the E code was the wrong one. So we modified the E code using Excel Add-in with the GEN_LED_VOUCHER_ROW_UNION_QRY view.This worked well, so the E code has been modified. In the view GL Voucher Rows Analysis, the CODE E is good. All the CODE E are ‘EXTERNE’ But when we look at the view GL Balance Analysis different results from 'EXTERNE' still exist.  When We look at the SQL Query Tool :It is therefore clear that the 'accounting balance' view has not been updated.This table is used to summarise the balance. The balance has therefore not been updated.So I tried to recreate an excel add in to update the values using the ‘ACCOUNTING_BALANCE’ view tu update the balance.But when I want to execute the excel, an error message occurs :

In IFS Cloud we use SSO and have a business unit that just changed their Active Directory information as part of a renaming.  Once the AD domain name changed, users were no longer able to log in to IFS using the new domain name.Looking at the User Details screen in IFS we can see that although the Directory ID and email for the user were updated to the new AD values, the IAM User account associated to each user did not change.  This value does not appear to be changeable.When we delete the IAM User and the user logs in again using their new domain details it then works, and a new correct IAM User account is automatically created and associated with the User.  The new IAM User account is then included in the User Details screen.Is this the correct approach to align/fix IAM accounts for users after a domain name change in AD? Or is there something else that should be done instead (or in addition)? Thanks in advance,Nick

I have prepared a file type URL that is prepared for VIEW:I followed the first option in the thread:This option is to prepared a file locally with .url as file extension.I am able to upload and connect the URL to an object, but the view icon is not presented. Only Edit, which makes no sense for this type of file.Doc Revision is as above.Anyone an idea how to get the View icon?

Hi, In the Activity Codes transaction, for dependencies we have 2 options: Pre requisite and Successor (not co requisite in this transaction).I didn’t find a way to put an activity as successor.  (only pre requisite)1/ Could  you tell me if there is a setting necessary to do that for an activity ?2/  If we put an activity in a Service Guide (problem code) with Auto load : Should we have aslo the successor activity load to SV as sucessor without put it in the service guide ?Thanks and Regardsanthony 

Hi,Is there a way to add some fields by default to a module opened for the first time ? I mean in standard opening a module for the first time, there is no fields available to set up criteria. Can we add some (or all) by default instead of none ?  ALLIANCE V15.4 SU6 Thank you.

Hi,In a service order, for instance, in zoom mode, we have a “counter” to indicate which record it active of the total number of records.eg : “1 of 3” if we are on the 1st record of the 3.In french version, the translation is “ 1 de3”, but it appears space is missing before the final number.In the case where there is only one record, display is “1 de1” and one customer complains that it is confusing as he read “1 del” (final caracter is ‘l’ instead  of ‘1’ in their mind).Is there any chance to add this space or replace by / ? If so how can we do that ?  Thanks

Hi,IFS Cloud 21R2 SU 2. I am looking for the procedure to install Demand Planner client and server for IFS Cloud 21R2.ThanksUma

I have written a procedure to finish work orders, however if there is an error when calling the api to close I want it to log the problem but continue with the rest of orders.  How do I complete this in the code please ?Sample code:objversion_ varchar2(200);  wo_objid_ varchar2(200);  wo_objversion_ varchar2(200);  null_ varchar2(32000) := NULL;  error_message_ varchar2(2000);  t_ date;  CURSOR Cur Is    Select wt.state, wt.objid, wt.objversion, wt.task_seq, wo.objid as wo_objid_, wo.objversion as wo_objversion_, wo.wo_no    from ifsapp.ACTIVE_SEPARATE_UIV wo inner join ifsapp.JT_TASK_UIV wt On wo.wo_no = wt.wo_no    where wo.mch_code='MATERIALS' and trunc(wo.reg_date) <= Trunc(sysdate)-30;         BEGIN   FOR cur_chief in cur loop    If cur_chief.state In ('Released','New') Then       Transaction_SYS.Log_Status_Info('Work Order: '||cur_chief.wo_no|| ' has been finished.' , 'INFO');       IFSAPP.JT_TASK_API.START_WORK__( null_ , cur_chief.objid , cur_chief.objversion , null_ , 'DO'

Hello community, Any solution to suggest set the right parameters?I want to create a supplier offset proposal for a manual supplier invoices with an “FM” series ID. ORA-20110: AutomaticOffset.NOAUTOSEIES: The specification of the invoices series with a manual numerotation isn't authorized. Use an invoice serie with an automatic numerotation.Thanks in advance !  

[Mon Nov 28 01:42:17 UTC 2022] - INFO: Installing ifs-cloud[Mon Nov 28 01:42:17 UTC 2022] - INFO: Using chart ifscloud/ifs-cloud --version 222.0.0[Mon Nov 28 01:42:17 UTC 2022] - INFO: Installing ifs-cloud[Mon Nov 28 01:42:17 UTC 2022] - INFO: Running helm upgrade[Mon Nov 28 01:57:44 UTC 2022] - SEVERE: UPGRADE FAILED: post-upgrade hooks failed: timed out waiting for the condition[Mon Nov 28 01:57:44 UTC 2022] - SEVERE: Failed to install ifs-cloud[Mon Nov 28 01:57:44 UTC 2022] - INFO: ifs-db-init log:

Hi all, me and  my Team are coming from Alliance 15 and currently working on the Field Service Management (FSM) Part of IFS Cloud, but I think this can be seen as general Data Logic or Mapping Question. I’m having troubles to find the correct references to match an entity to another. This actually holding me back on API’s and also in the Query Designer joining e.g. SrvRequest with JtTask. Is there any guide or documentation describing the Data-Structure and/or References, something were I can get the idea of how entities are working together? Thanks,Michael

Salute, I was working a couple of years with IFS 75 and IFS 10. For failure investigations, Quick Reports, custom attributres, I used to using the SQL Developer. I’m not bad to handle it.Also, to combine it with the debug console, to find the right API and find the function or process. Now the BUTSince November, I work as an IFS Consult for Arcwide. To use my known approach is not more possible.I have installed SQL Developer and am using it to build my scripts. Without access to a database. The buityfier supports me as it only does it nicely if the syntax is correct.I test the scripts in the quick report and than I copy it and adapt it in the customer attribute. Sounds complicated, it is complicated.Today, I got the course Query Designer. Brilliant.  MY QUESTION:Is there a tool lilke Query Designer from IFS to support my work.With API Explorer, I have my problems to find the right information. Process/ function, necessarry parameters, what is must, what is optional. Or is there a cours

Our collegue did bad debt management process to some customer invoices some years ago (Invoices were sent to debt collector) and now debt collector  informed us that customer has been insolvent. That is why,  we decided to do “account: 6351=Confirmed losses on AR” However, account 1515 is Ledger account, so it is not permitted for manual vouchers. How can I book for this? Thank you for your help! 

Hello,Is there a best practice for exporting the translation of custom fields to IFS Cloud?Thank you in advance.

Hi Community, Is there any way i can setup the attached document will flow from Purchase Requisition to Purchase Order? Regards,Jewel

What would cause the error: Route departure date is not within current calendar? What calendar are they refferred to? When I try to create a new customer order I know it is using the route Id for the customer to calculate theWanted delivery date. Does this error mean I need to activate a calendar?  

Hi,With the SP4 SU4, we have an update for the MOE -10329. we can create a RA Inside Values : ▪ N=Return to Warehouse▪ O=Return to Whse & Create RA,▪ Y=Return to Whse & Create Inside RA. Could you explain the purpose and process for an inside RP ?For an inside RP, you don’t have a customer, but here the Technician is on the customer site and swap a component or installed item who belongs to this customer.Is inside repair provided for certain types of equipment (loan) ?Thanks and Regardsanthony

Has anyone figured out how to adjust the CSS for these tooltips? If I have a tooltip that is long it goes to the very edge of the page, so I’d like to change the width to make it more compact.  

Hello, Currently, I am building automation for blocked customer orders to get automatically unblocked when a payment is made to an account and their available credit >= blocked customer order cost. Since I cannot automate this via a workflow due to the commit limitation for customer order flow that prevents a rollback, I am attempting to accomplish this via an event action. Can someone please shed some light on the CUSTOMER_ORDER_API.START_RELEASE_BLOCKED call? I see that in the create statement for the procedure that there is a “release_from_credit_check_” variable which I need help with finding what value this is supposed to represent. Is this a boolean value?  Any and all help would be greatly appreciated. Thanks,Bryan

Hi all,Often when we have created a shop order, we would like to change a work center.That is no problem, when there is no control plan.When there is a control plan, it seems to become a mammoth task, involving new control revision, new alternative/changing rountings, conflicting dates etc.What is best practice on this?  

Hi, I’ve found in the standard lobby the information about the leads created per month but i don’t find the same for accounts and contacts. Does this exist ? If not, is it complicate to create it ? (I’m a beginner in lobby in IFS)Regards,Pierrick

When the lot size is 100 pcs, but only 5 pcs is received. Shop order is not completely received. When the shop order status is Started in state products: shows Partially received.System is allowing to close the partially received shop order.  But how the state can show completely received.  When lot size is not completely received, How can show completely received? 

Hi, In the V15.4 SU2 we have a new functionality : Item Discovery Search on Mobile will now display the Site ID and/or Warehouse ID to indicate the source of the item being searched.Could you explain the page on mobile edge where we can find this option and if a setting (MOE) is mandatory.Is it in site detail ? or in a service order ?In my test : In mobile edge in a Service Order > Installed item card > Add new item > Scan and Search on Server an item  > I only have the message “Sorry no records found”Thanks and Regards anthony

Hello,I need your help please to better understand the RMA process: 1- I have a customer order line with discount that is invoiced.2-  I have created the RMA from the customer order line: The price showing on the RMA line is full price not including the discount.3- I have created a credit invoice from the RMA line: the credit also showing the full price not including the discount. My question is: should the RMA line retreive the price including the discount from the order line? Or we need to add the discount manually when we create the credit invoice? Thank you! 

If requirement is to populate LOV of 2 drop-down attributes on dependency basis , How to do that ?Say , if I select A from the LOV of first dropdown, I'll get 1-10 as LOV for 2nd dropdown , where as if I select B from the LOV of first dropdown , I'll get 11-20 as LOV for 2 nd dropdown. So, Could you please tell me how to achieve that ?