Solved

Does anyone know of any IFS Documentation on how to map IAL columns to the Designer ? Here’s what we’re trying and we get an error:         IAL: select col.COMPANY as Company, col.CONTRACT as Site, col.customer_no || ' - ' || max(rega1app.CUST_ORD_CUSTOMER_API.Get_Name(col.CUSTOMER_NO)) as Customer_Name, pm.Part_Main_Group "Trademark", ROUND(SUM( col.revised_qty_due * col.sale_unit_price), 2) "Total_Revenue", ROUND(SUM( col.revised_qty_due * col.cost ), 2) "Total_Sales_Cost", ROUND( SUM( ((col.revised_qty_due * col.sale_unit_price) - (col. revised_qty_due * col.cost))), 2) "Margin", ROUND(AVG( case when col.sale_unit_price <> 0 then (((col.revised_qty_due *  col.sale_unit_price) - (col.revised_qty_due * col.cost)) / (col.revised_qty_due * col.sale_unit_price)) * 100 else 0 end ) , 2) "Margin_%" from REGA1APP.CUSTOMER_ORDER_LINE col left join REGA1APP.CUSTOMER_ORDER co on col.ORDER_NO = co.ORDER_NO left join REGA1APP.PART_CATALOG pm on col.part_no = pm.part_no left j

Hi, I’m starting to use IFS Application. It’s a Windows Client running on Windows 10 Professional. I was reading the on line help and doing the excercises proposed on the e-learning page. When working with the toolbar, I used the contextual menu to hide diferent toolbars. Suddenly, I hided all the toolbars and I can not find the way to show the toolbar again. I’ve looked in every menu available, and tried with the secondary mouse button on the menu.   About info is: IFS APPLICATIONS 7 Copyright © 2006 IFS AB This program is protected by copyright laws and international treaties. Unauthorized duplication or distribution may result in severe criminal penalties, and will be prosecuted to the fullest extent possible by law.   System Info: Windows Environment: Systema Operativo:        Windows Server 2003 Versión Windows:        6.2 (build 9200) Nombre Ordenador:        GPEV-SSOP-C01 Procesador:        586 No Procesadores:        4 Memoria Libre:        2048 Mb Disco Disponib

Don’t laugh - I know, 2003, yeah!   Does anyone have a copy of the Data Import executable that allows you to load in new records, and update existing data in IFS2003. I cannot remember the name of it. Since my laptop rebuild, I have lost it! IFS support didn’t want to know. Thanks in advance.   TIm

Hello In FSM 5.7 mobile, when attaching photos, you can only take the photo and save within FSM but not to your camera roll. This is an issue as there have been many instances of the file getting corrupted and unable to retrieve it since it only exists in the attachment database.   Is there a way to allow the app to save these photos to the camera roll as well? I know users can upload there own photos but you have to navigate through android root menus and that is not user friendly 

Hi Team,   we have four managed server , in each managed server log, getting below error: could anyone suggest what could be the issue ? ####<Jun 23, 2020 9:56:01 AM CEST> <Info> <JDBC>  <ManagedServer1> <[ACTIVE] ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1592898961605> <BEA-001128> <Connection for pool "fndbas" has been closed.>   we  have IFS 8 environment .   Please suggest.      

We have certain windows that currently do not allow us to attach documents. I am looking to enable attachment in the windows but do not know how too. How would I do this in IFS 9?

We want to analyze in which lobbies (and quick reports and events) a specific database field is being used, but we can’t find the queries used by lobbies somewhere in the database. Can anybody tell me, where these information can be found?

When I release a customer order that has a manufactured order line, it creates a shop order.   One of the custom fields on ShopOrd has a default value, but no record gets created on SHOP_ORD_CFT, so the default value isn’t set when the shop order gets created.   How do I ensure the SHOP_ORD_CFT record gets created when the shop order is created from a customer order?

When generating the tasks from a contract using PM Contract Manager i get an error in the run log the error states “There is no row at position -1.”   i re-created the contract and the results are the same. any idea what this is referring to?    

Hi, My client plans to share Ifs.Fnd.Explorer.application runtime manifest file for all our users instead of creating shortcut to the IFS landing page due to internal IT reasons.  Question - Every time we apply IFS Updates or Deliveries to the Application Instance, do we need to copy the latest manifest file again across client PCs or this isn’t required as the ClickOnce file is just a pointer which launches the updated IFS Applications IEE client automatically? I am 99% sure we don’t need to copy the file again but want to be 100% certain before we follow this approach. Thanks in advance!  

We were using the ScanIT App and came across the following error:    Unexpected http status code: 500   Can anyone advise.

I am trying to bring over customer and supplier invoices using the heavy migration tool.  The containers load successfully, migration prerequisites job executes without error, but when we try to bring over a couple of items to test, nothing is written to the tables.  There are no errors, but it simply leaves the row unprocessed.  The execution log: Start migration: MTK_SUPPLIER_INVOICE_API/Phase:1 Jun 16, 2020 16:56:17 Live mode migration. Processing entire primary input cursor. Displaying message level info1 and higher. Setting Database Optimizer Object Statistics preference CONCURRENT = OFF . . . Prerequisites completed successfully. Migrating invoices matching Company: % and InvoiceNo: % . . . End migration: MTK_SUPPLIER_INVOICE_API/Phase: 1 Jun 16, 2020 16:56:19 Insert error count:  0 Other error count:  0 Commits performed:  2 Rollbacks performed:  0 TableMonitoring_Update: Oracle Cost Based Optimizer statistics updated in 2 seconds.   Is there any way to get any mo

Hello!   I can’t grant permission to sticky notes to the permission set. I’ve already gave ‘Activity’ ‘ManageNotes’. Any other ideas? It is frame “frmEmployeeEquipmentCard”. I know that’s question of security, because one user can with some permission set and other can’t with another permission set. Greetings, Gerard

Want to set logical printer for INVENTORY_PART_BARCODE_REP using a Report Rule. Using the following expr1: [&select inventory_location_api.get_location_group(ipis.contract, ipis.location_no)  from inventory_part_in_stock ipis  right outer join inventory_part_barcode ipb    on ipis.contract = ipb.contract    and ipis.part_no = ipb.part_no    and ipis.configuration_id = ipb.configuration_id    and ipis.lot_batch_no = ipb.lot_batch_no    and ipis.serial_no = ipb.serial_no    and ipis.eng_chg_level = ipb.eng_chg_level    and ipis.waiv_dev_rej_no = ipb.waiv_dev_rej_no    and ipis.activity_seq = ipb.activity_seq where ipb.contract = '[@INVENTORY_PART_BARCODE_REP/BARCODE_LINES/BARCODE_LINE/CONTRACT]'  and ipb.barcode_id = '[@INVENTORY_PART_BARCODE_REP/BARCODE_LINES/BARCODE_LINE/BARCODE_ID]'] Ordinal: 10 Operator: = Expr: 100  I get the following errors: Rule ID=40 ORA-31011:ERROR Evaluating Expression=''[@INVENTORY_PART_BARCODE_REP/BARCODE_LINES/BARCODE_LINE/CONTRACT]'' result_ke

Hi All,   Is there possibility in IFS to send Customer’s transaction report to Customer email id every week.     Regards, Mukesh Gupta 

I am trying to create a custom task user for a time clock in task, however it keeps defaulting to a full user. an help on this? 

When i go into Text Translations Screen in IFS I don’t see an option to add more entries in there.  How do i add more words to be translated into IFS?

Hi All, Can you please help on this topic : I want multiple request/task/request_unit will be created on Button Click from a Custom Screen. But I am unable create multiple request/task/request_unit through business rules, only one data I can insert. Please help on this.  Note : Number of request/task/request_unit that will be created  is variable and depends on calculation between two dates.  I just want help on , how multiple request/task/request_unit data row can be inserted in business rules

Hi guys,   I’m experimenting with the field ‘Priority Category’ in Shop Order. The aim is to see how APB schedules works orders with values plugged into this field.   Can somebody indicate the relevant UoM? What are valid inputs (1,2,3  or A,B,C assuming values are pre-configured). What is greater (i.e. 1 or 2).   many thanks, jay      

Hi can anyone please tell me how to install FSM mobile service in my Mobile.Now i am using mobile service through NOX mobile emulator but i want to use the service in my mobile phone only. I tried to download the service in mobile through but its not connecting its saying localhost refused to connect.Remember the FSM i installed is on premise installation only with my local IIS server. Please help me how i can use FSM mobility service in my Mobile.

Can we write a condition using expression instead of using "change" operator. I have a business rule where I have a condition using expression like below: In the same expression can we also check whether PERSON_CAL_EXCEPT.START_DTTM has been changed or not. The intention is not to add one more input param “PERSON_CAL_EXCEPT.START_DTTM”  and not to rebuild the condition again with an additional line  for checking whether PERSON_CAL_EXCEPT.START_DTTM has been changed or not.   Please help if anybody has any suggestion on this.

Morning all,   We have an issue where we have certain suppliers who “chance it” and send us material that they have finished early (sometimes months early). Obviously we don’t want to be taking on this stock until we actually need it however as some of it is sent by courier i.e. FEDEX, UPS etc we get the courier dropping the item off, takes a quick signature and then they are on their way. It is only after manual inspection of the delivery later that we realise that we have something we didn’t yet need. I know what you are all thinking. just tell the supplier to stop doing it! (apparently they don’t listen) For audit obviously we have to register the purchase order arrival but after this we have 3 options.  Leave the stock as registered and keep stored in a goods-in location Return for Credit Return for Rework The only one that works in the way they want is Return for Rework in so far as it halts the payment, creates a return note and upon it coming back we can just re-registe

Hi guys,  This was posted a while back. A ton of people viewed it but gave no answer - despite  me requiring one desperately! Since then I posted ‘more simple’ kinds of questions, and received a reply soon after. But, to be frank, that’s no good. Surely I should get some indication for the more complex stuff without recourse to a consultant? I’ve got a query about how to use APB. An example is apt here. Consider an MPS consisting of 2 items. Lets stipulate the structure for each is: Level 0 = end-item (GA), Level 1 = SA (x2), Level 2 = 4 piece parts & Level 3 = 10 piece parts. Let’s also imagine 0 overlap between recipes (thus no requisition to merge supply). The relevant ‘Priority Rule’ is ‘Earliest Possible Due Date’ (with all operations selected) since we’re looking to schedule both projects to finish asap, with no spare capacity gaps. 2 options arise at this stage. Either, schedule both project items (under the priority rule stated) in APB with a single executed run. Or, l

Hi, What is the functionality of ‘Planning Structure’ in IFS Apps 10?  I pasted a part no. into the initial search and received nothing. So, assuming it’s relevant to scheduling, what are the data requirement necessary to run it?   thanks,  

While accessing the FSM Web Client Portal from IIS server.It is  throwing 500.19 Internal Server error. How to solve this error. Remember that its an on premise installed web client portals. I believe i need to do some configuration in the web config file.Can someone tell me what i need to do?