Data Migration

We are on IFS Cloud 25.1.2. Microsoft just forced updated Office to 2507 (19029.20136) which broke our IFS Excel add-ins. Users that stayed on 2506 are still OK. Issue is, when you click login, the add-in panel briefly flashes and does not bring up the login window for IFS cloud. Anyone else have this issue?

Hello With the latest version of excel, it seems IFS Excel migration does not work. cloud 23R2 version

Hi All, My requirement is to update the total accumulated depreciation up to the cutoff date during the import process and set the cutoff date as the Thru_Date. Then, when running depreciation using the Depreciation Proposal, depreciation should be calculated correctly only for the period after the cutoff date.

Hi community, in IFSAPP10 I am trying to create new configuration for quotation line with migration job. I checked the configuration form and found these two tables: CONFIGURATION_SPEC and CONFIG_SPEC_VALUE. I used the table CONFIG_SPEC_VALUE as many times as I have parameters in my configuration revision. I am able to create new configuration with this migration job. I can see records in both tabels with new configuration ID, but I am not able to create the record regarding the connection between the new configuration and particular "Order Quotation Line". I found table CONFIG_SPEC_USAGE where you can see the records, that connect configuration ID with another object, but I am not able to use the table/method CONFIG_SPEC_USAGE in migration job. Could anybody provide any suggestions? How to solve the connection between new configuration and other object? Thanks a lot. IFSAPP10

Hello, I am looking to see if there are any column level definitions in any of the IFS documentation for fields like C1, C2 and N1, N2 etc that can be found on tables/views like Invoice_Item_Tab. I found some defitions for Invoice Header and Invoice_Line under the EDI messages page but nothing for the Invoice Item. https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/default.htm?openpage=https://ifstestcloud.xxxxxxxxx.com/ifsdoc/documentation/en/GeneralIFSApplications/AboutEDIMessages.htm (I replaced our local instance name with xxxxx) Is there a place where I can find these? Thank you

Hello, I am trying to locate some data from the Shipments page in the underlying views/tables but coming up empty. I am looking at Shipment Management > Outbound Shipment > Shipment, general Tab and then Weight. I have the following in there - Net Weight, Adjusted Net Weight,Tare Weight,Manual Gross Weight,Operative Gross Weight,Operative Adjusted Gross Weight. When I look at Debug > Page Info, I am told these are all part of the TotalWeightGroup element under the View Shipment. But when I query the Shipment view, none of these columns exist in it. Where can this information be found in the IFSAPP database? Thank you

Hi, There is a migration job to create or update suppliers. We want to add ‘30’ prefix for the supplier id if the the supplier is a new supplier. I would like to know how we can do this. we tried to get next supplier id and add ‘30’ prefix in the Method List attribute as below. but it didn’t work. Thanks, Sachini

We recently found out the External File Assistant has been (or is about to be) deprecated in IFS Cloud. Is there any information on a replacement for this functionality? Will that replacement be an additional cost?

Hi Experts, I want to clear existing values in DMM. How should I set it up? Here are some specific examples. I want to update the notes value to blank. Deploying blank data will not update the notes. How do I clear values in DMM?

What method should I use to change the status Plannable to Tentative? Thanks in advance,

I am trying to run a migration job to import a large number of test points and parameters on functional objects. I am experiencing the below issue Parameters: When my migration job (EQUIP_OBJ_PARAM), it updates the Parameter for the Default testpoint not my newly created Testpoint. Anyone had a similar issue or has a solution in IFS Cloud? I ran migration job for Hours but the system generate and associates the parameter that is created in migration job to the test point id * Default Testpoint (there is no such parameter template). I even tried key manipulation by changing the flag on method EQUIP_OBJ_PARAM and EQUIPMENT_OBJECT_TEST_PNT for the attribute TEST_PNT_SEQ from “P” to “-” (minus sign) it errors something like this “exact fetch returns more than requested number of rows” suggestions are appreciated

Is it possible to update values on a custom field through migration job in IFS Cloud? I’m trying to set a value in a custom Cf$ screen using migrate from source data I see no exception but the value is not updated. I even tried hard coding all the keys and value still no luck. Ideas appreciated.

Hi, I’m using a Migration Job to import some Customer Orders. When Customer Orders are created in Aurena we have a custom action in place that creates a new Financial Project, and connects the new Customer Order to the Financial Project. I can see this running in the Log Window, which shows that the action name is “Cf_CreateConnectFinancialProject” and the Projection is “CustomerOrderHandling”: I can confirm that this Projection>Action exists by looking at the Projection in Enterprise Explorer: What I’m stuck on is how I call this action from my Migration Job, as it claims the method doesn’t exist: I’m familiar with how to call APIs but not Projection Actions. Can anyone help please? We’re running APPS 10 Release 25.

Whilst migrating customer master data I have an issue when attempting to migrate the information that would populate the Customer > Sales tab. View: CUST_ORD_CUSTOMER_ENT I am receiving the following message: ORA-20111: CustOrdCustomer.ORDERATTR: Customer BDAR has no delivery address with order specific attributes specified. Looking at CustOrdCustomer.plsql can see: PROCEDURE Exist ( customer_no_ IN VARCHAR2, customer_category_ IN VARCHAR2 DEFAULT 'CUSTOMER') IS BEGIN IF (NOT Check_Exist___(customer_no_)) THEN Error_SYS.Record_Not_Exist(lu_name_,'ORDERATTR: Customer :P1 has no delivery address with order specific attributes specified.', customer_no_); END IF; super(customer_no_); END Exist; I have checked that customer BDAR has an address: Also, checked the Sales Address Information tab: Any ideas on how to resolve this? Many thanks in advance. Kind Regards John

In cloud version, cannot create data migration job for custom view. Returning “custom lu views are not supported” error. Any idea?

Hello, Using IFS designer I would like to add the media imported by the technicians when carrying out a step of a work task so that the photos are present in the printed report. The configuration was carried out by one of my predecessors (see the result in the photo) a long time ago but since the version upgrade to 23.1.13 the configuration has disappeared. Except that in IFS Designer I cannot find the solution to include the media coming from the technicians when carrying out the step. Can you help me please ? Thank’s

Is there an “easy button” to move one site under another company within the same IFS instance? Or does that require a full blown data migration to move data from one company to another? How have other IFS customers resolved this situation?

Community, We would like to know IFS to other ERP system (SAP) if any migration solution available? Any PPT/Presentation available? Thank you.

When using the 'Data Migration Tool' to deploy to an output container, sometimes I get the error "Base data target table not found" and sometimes I don't. There is no difference in the settings. Please tell me how to stop the "target table check". 1. When not checking 2.When checking “WAREHOUSE_BAY_TIER validation failed, basic data target table cannot be found” error

Edit: Sorry, for some reason this post cannot be made in the Assyst discussion board. Hi, all! I am currently trying to get ETM to import a .CSV file of our hardware, but I’m having trouble getting Assyst to import the file. My current setup is: A hardware list is generated by another program and a .csv file is created. That file is emailed to ETM via a MS Graph Import Channel formatted for .csv files. That .csv file is mapped to our hardware import datamapper. Whenever the email is sent to ETM, however, it fails to interact with the attached .csv file in the email. Is there any way for ETM to receive an email and then utilize an attached file, or do I need to come at this from a different angle? I’d greatly appreciate any input, thanks!

Hi Community, We are currently facing a challenge with our Build environment, which gets reset or vanishes after a certain time frame. As a result, we have to manually reconfigure key master data such as Company, Site, Supplier, and Customer each time. This manual setup is quite time-consuming and repetitive. We do have another environment with the required data already in place, and we are exploring possibilities to move or copy that data into the Build environment. Could you please advise if there is an easier or recommended method to achieve this data transfer efficiently? IFS Version- Cloud 24R1 Thank you in advance for your support.

in 24R1, i have met the error message below in Excel Thanks in advance for your help. BR/Emmanuel

Hello, while executing WO creation via migration job (procedure name: MIGRATE_SOURCE_DATA) i received such information: There is no information about any errors, but the WO record is not created in the application. Maybe someone knows what does such information means? Thank you beforehand!!!!

Is anyone facing an issue of being unable to add an address for a customer after the 25R1 update in IFS Cloud? I am facing this issue, and this does not work even through data migration.

Hi We are using IFS Cloud. I’m trying to load Cost Breakdown structures and want to make them active, suing Migration jobs, Alternately, Use a Background job to set them as Active. Is this possible? I’ve tried using Cost_Structure_API.Activate__ but cannot get this to work in an anonymous block. Here is my code: DECLARE attr_ VARCHAR2(5000); job_id_ NUMBER; CURSOR get_structures IS SELECT cost_structure_id,objid, objversion FROM cost_structure WHERE state = 'In Progress' ; BEGIN FOR c_get_structures IN get_structures LOOP client_sys.clear_attr(attr_);-- client_sys.add_to_attr('INFO_', 'NULL' , attr_); client_sys.add_to_attr('OBJID_', c_get_structures.objid , attr_); client_sys.add_to_attr('OBJVERSION_', c_get_structures.objversion , attr_); client_sys.add_to_attr('ATTR_', '' , attr_); client_sys.add_to_attr('ACTION_', 'DO' , attr_); job_id_ := TRANSACTION_SYS.Post_local__('Cost_Structure_API.Activate__', 'PARAMETER', attr_, 'TESTING '||c_get_structures.cost_structure_id , sysdate ,'TRU