IFS Solutions

I want to change the comments of  custom attributes with excel migration.I have done some work for this by taking a working migration job as an example , but i am having  some problems.1.Date is entered in the header section of the migration job and source mapping , method list, rules are created automatically.“ORA-20124: CustomFieldAttributes.FND_ITEM_FORMAT: “String” value for [DATA_TYPE] in Custom Field Attribute has incorrect format.” It gives an error. 2. We get this error when we delete some mappings and run the migration again.  3. We tried creating a new migration job and deleting the source files.We get this error again.4.We tried making the new property no in the method list tab.We get the same error again.How can we solve this problem?

Hello, It is possible to retrieve in extra column in IFS cloud the difference in values ​​between two CFs? I have two Custom Fields, for example CF_12 and CF_11 and I want to display (CF_12 - CF_11) in extra column, how can I achieve it? Should I use in creating new column in this entity Custom Field - Select statement, Expression or Reference Value? Only CF_12 is located in SQL, CF_11 is not

Hi All,In IEE we have the below Transaction Types which is available to connect to a cash accountIn Aurena or Cloud its not availableWe can see the number 12 and 13 are missing,  This is used for mixed payments method Manual.   Anybody knows why this is missing in Aurena, Cloud and how this functionality is used in Aurena and Cloud

Dear IFS Support Team,I’m reaching out to report an issue with the IFS CRM Outlook integration. The CRM panel is not visible in Outlook, and I’m unable to use the expected features linked with it.Could you please assist in resolving this issue or provide guidance on what might be causing the CRM panel not to appear?Thank you in advance for your support.Best regards,

As I get a similar question multiple times, I thought to write a separate topic on how to use an Excel Migration Job for multiple views. As example I take the creation of a new part in Excel and adding a manufacturer. I know it is a simple example but it is the base for exploration of more functionality. Create a mig job with the following setting: Used views on parts entryOpen the tab Rules Create connection between two viewsThis rule value would be the same as if you prepare an SQL statement that will connect the two views. So if you have a view that has multiple fields to form the external key, all field combinations must be included using a regular ‘and’ construction. There are quite some fields on a master part general tab. I've removed the majority in the spreadsheet by removing the source column in tab Source Mapping: Leave in the fields with a default value. Clearing the Source Column for these fields (as in positions 40 and 60) will result in not showing these columns in Excel

Hi,In the Reserve and Backflush visualization dialog box I cannot see the available quantity.However, the this inventory item is in stock and if I select manual reservation for the SO material line I can see the stock lines.In the SO line, inventory part is in stock, and both windows' part ownership is company-owned.What could be the reason for this?Thank you in advance. 

Hello Team, I would like to know if someone already did the configuration for a status change ?For example I want to trigger the history log when a Shop Order is released and same for Purchase Requistion.I cannot find the value ObjState in the right table in History Log configuration. Thanks for your help.   

Hello,What is the most appropriate report for inventory (values and quantities for parts) on the particular day, that the value  equals to the value for local account: 310100. We will need  print the report for the auditor.Thanks and Regards

Apps 10 Update 15SEPA payment format, CORE, 001.001.03In the SEPA XML message there is a tag named <InstrPrty> that can be used to indicate that the payment file should be treated as urgent by the bank.This seem to be defaulted to value “NORMAL”.Is there a way to set this, from within IFS, to “HIGH” for specific payment files.  

We have a large number of users who have left the company and their IFS IDs are inactive. At the Oracle database level they are also inactive and our DBA would like to remove them.  Does anyone have experience with removing users from the Oracle data base but leaving them in IFS as inactive.  They do not own any schemas, events, triggers, batch jobs, etc.

In 23.2.9, we are not able to connect a material requisition line to a non conformance report.It seems that in the object key ref, the key order_no is missing. So, we cannot search for a material requisition line from the material requisition number.  Conversely, when trying to attach a NCR from the material requisition window, we got an error message. Hereafter are the parameters of the object connections : Any idea regarding this ?

Hello.We have a weird IFS behaviour : on this screen ifsapf:tbwReceiptInfoWe already added a couple of custom fields, they are already available and displayed on ifsapf:frmReceiptInfoAbout ifsapf:tbwReceiptInfo , by realizint a right click → column chooser, even if we add every CF on the right side, and then, by clicking on the OK button, these CF are not displayed.If we return to column chooser, they still appear in the left side.What can we do to display these CF? all of them are persistants and they are not shared with no other view.

Hi,  Does anyone know a way to see the information sources used in Business Analytics/Business Reporter reports. Essentially trying to work out which of our QFACTs are not being used. Thanks

I find this question to have been posted earlier, but without a definite reply or a reference to a solution.  It is in reference to the SAF-T file and the use of GroupingCategory in conjunction with GroupingCodes instead of StandardAccountID as the mapping option. Background:We are based in Norway and need to comply with the Norwegian SAF-T regulation.  These regulations allows us to choose how we want to map our GL-accounts. However, the SAF-T file has to correspond to how we report taxes, and since we report taxes using schema RF-1167, we need to map our GL-accounts to these RF-1167 codes.  In other words, we cannot map our GL-accounts towards the Standard SAF-T accounts.  The Norwegian SAF-T Financial Data - technical description (see norwegian-saf-t-financial-data---technical-description.pdf (skatteetaten.no) pages 12-13 explains how this can be done by using the tags GroupingCategory (value = RF-1167) in conjunction with the corresponding set of codes in the GroupingCode tag.  The

Hello All,I am facing this error - Supplier S00*** has no delivery address with purchase specific attributes specified. how to resolve this ?Thanks and Regards,Kruthika

We have an  issue/question related to machine load for work center and work orders.Conditions for this to work is clear; wc resource connected to object, obstructive and status on work order etc.Our issue is that work center resource is connected to a maintenance object where more detailed setup with sub levels below connected object id exists, see picture. I our case this is a robot cell with multiple robots, conveyors, stamping units etc. All defined as maintenance objects below object connected to WC resource.We cannot se how, but is there a way to consider and show load also for obstructive work orders on lower levels for object id connected to WC resource? 

Hi, Under work task , if I go to document section there is no download button coming but for other users it is coming , the configuration for both the users is also same.Screenshot1 has download button .Screenshot2 doesn't have it.  

A customer has custom data warehouse built in MS SQL server that they are using with multiple internal systems for reporting purposes. When using IFS Cloud they want to keep using the same data warehouse solution.What is the best way of loading data to their existing data warehouse from IFS Cloud at the database level?Is it possible to use Access Views for this purpose? if so are there any benefits of using access views for this rather than using Oracle views with direct DB connection?

This is for IFS 10 - IEE.  We have some users who are receiving - “Error on Page  The page you loaded could not be activated due to errors.  Please contact your support representative.  Could not load file or assembly “Ifs.Fnd.Windows.Forms.ConditionalFields, Version=4.52.10.0, Culture=neutral, PublicKeyToken=...” The user is using Chrome for browser. Has internet connection but may be a poor connection.  Chrome Add-in is installed.  User’s IFS permissions are fine.  Receives the same error no matter the screen that is selected. Any idea what might be causing this issue? Stacie 

Imagine that we buy 2 foot sticks, and that we cut them in half to get 2 one foot stick. Currently we just count-out the two foot stick and count-in 2 one foot stick but this way causes problem since its hard to keep track of the material inventory. Is there a better way to transfer one part number to two new part number? I tought we could make the 1 foot stick with a product structure but then it would mean that everytime we produce end product the step of cutting the stick is in the process. We dont want that since we cut alot of stick that last us a pretty long time. Any suggestion?

Hi,Using Apps 10 UPD14 we have a need for a fixed consumption of certain components regardless of the Shop Order Lot Size. For some Shop Orders we always consume 2 pcs of a critical material as part of the set up.We are trying to solve this by setting Component Scrap to 2 and Qty Per Assembly to 0, and it works on the Shop Order. However, we cannot set the values on Product Structure which requires Qty Per Assembly > 0 if Consumption Item = Consumed.Any ideas or suggestions? Could it be a bug?Best regards,Jørn Straarup

Hello,in IFS10APPSI have created custom event to release every purchase order just after saving.  Than, when I save new purchase order, nothing happens. The purchase order 433184 is still in “Planned” state. No errors of the event, nothing.  What is wrong with it? Where should I look for error? Thanks in advance Jan

Is it possible at all to have a MarkdownText content field that is populated with a H1 callout `#` and then pulls the data from a specified field (eg; CustomerInfoSelector/CustomerInfoAddresses or something similar). Would love to be able to pull another freeform short-text field as the value, but am not sure how to get this working (or if it’s even possible!)  Thanks all!

Hi All, During the Order Delivery step in Release update Studio (upgrade from 23.2.4 to 24.1.4), delivery fails due to installation errors in FNDBAS (I attach the log).There are a whole bunch of errors including missing columns in tables from FNDBAS (in dictionary_sys_tab for example). Customizations have not touched this area. More strangely, this earlier as well as later creation of TOP environments from Release Update Studio (and thus theoretically based on the same code from the repository) succeeds.Also successful is the Sanity Build run, which was performed just before the failed delivery creation (DEL environment installation).Update 23.2.4 to 24.1.4 is run by the customer team.Unsuccessful attempts to create DEL were made by him 3 times, as well as we did it afterward with similar results. Have you had to deal with a similar situation, or do you have any idea what could be the cause?I would appreciate any suggestion.Thank you and Best Regards,Krzysztof Błaszczak (TSM | IFS)

Can anyone share the FSM - UPS integration design document? FSM6 has a standard connector to UPS, but I can't find any documentation of it. A customer requested this documentation this week. Likely, such a document got released with an older FSM release.