Solved

We use Inventory Valuation Method = Weighted Average (on Apps9) and we receive inventory parts from a PO and we match the supplier invoice and pay the supplier.  Then the supplier sends us a credit. Our Supplier Invoice Consideration = Transaction Based and we would expect this credit to update the inventory value of the part.  How should this credit be processed?  We have never set up any type of “supplier credit” series but maybe this is possible?

We would like to print a pro forma invoice for a given shipment but the option is grayed out. The shipment is in “Completed” status and we’d either like to print it manually by RMB in the header of the shipment > Print Pro Forma Invoice OR have it as an optional event for the shipment type. The help says that this should be as easy as RMB in the header and clicking Print Pro Forma invoice and the only prerequisites are as follows: The shipment must be in Complete or Closed status before you can print the shipment pro forma invoice. In order to print the customs value it must be manually defined for each customer order line. The customs statistics number will be printed for both inventory and non-inventory sales parts as well as package parts, when defined in the respective inventory part, non-inventory sales part and package part records. The net weight will be printed for both inventory and non-inventory sales parts as well as package parts, when defined in the respective sales

Can anyone please suggest me how i can to database migration from my SQL server FSM 5.7 Database to FSM 6 Database or any other external database. Regarding database migration any sample will be very helpful.

I sent this topic to IFS Support in March, but have not received an answer. Hoping someone maybe can give me a “yes”/”no”:   We use IFS V9. We updated in the Application Base Setup > Enterprise > Site, under the Inventory > General tab, the Picking Lead Time to be 10 days for all sites in Prod. However, if we have to key a short-lead order, we get an "INFORMATION MESSAGE: THE DUE DATE IS EARLIER THAN TODAY'S DATE. EARLIER POSSIBLE DELIVERY DATE IS YYYY-MM-DD" for every line item. We can press OK and bypass the message, and it will let you continue keying, but again - it occurs with every line item, which makes keying more of a task. We are looking for a possible way to disable this message?    

We have the below XML being triggered from a business rule, after commit insert or update on the TASK table.  This XML creates a new address (using a custom view) and updates the address_id of the task.  We sometimes see that,  if there are 2 TASK’s created almost at the same time (with just 1 second delay or less than 1 second delay)  then both the task’s  are updated with the same address id.    The below expression that is updating the address_id returns the same address_id in  both cases.  <address_id xpath_node="//update_address_result[@result_name='update_tmfb_address']/address/address_id" />   However we see in the database that 2 new address_id are created but the both the task’s are updated with only 1 of them.    So basically when we have 2 similar tasks created at the same time then this business rule executes 2 times and the expression “//update_address_result[@result_name='update_tmfb_address']/address/address_id" doesn’t return unique result.  The task ‘s ar

Hallo, I need some help with mWO objects. I have  approximately 8 000 objects serviced by 50 technician. So I want to divide the objects into smaller parts (like service regions) & and have individual access to them. I disable property SuncAllObject on TAS. I (even)  disconnect group push user (IFSSERVICEENGAPP) from the site. Doesn’t work. Every mobile user can see all the objects. What else I should do ? Any idea, please ?

Is it possible to show/hide fields (setControlVisibility) or set some fields as required/not required (setControlRequired) on the FSM Smart Client Screen using Client Script?  I want to set some fields as not required based on the task_type on the TASK screen, so that I do not get the validation error when saving.  If task_type = A set user_def1 as required  else if task_type = B set user_def1 as not required

When in Print Customer Invoices the E-mail Invoice option is greyed out.        The customer record has an email address defined and it is set to default for method. Can someone please advise why this would happen and how to resolve. Thank you.

Hi Experts, As I know, ‘Finished’ & ‘Cancelled’ status WOs are viewed in ‘Historical Work Orders’ screen. But, if you look on the search option for ‘Status’, it shows two more options i.e. ‘END’ & ‘Reopened’ . So, can anyone please let me know the situations of those WOs ??? what are the instances of getting such status for WOs ???   Thanks, Thieuban

Hi, We configured CWS for IFS Apps 10, as per IFS documentation but running into the following error trying to View a Crystal Quick Report in IFS: Here are the error details captured by the CWS logs: 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[LoadReport] Loading report : C:\ifs\test10_reports\WC Load.rpt 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[LoadReport] DBUser = ifssys ,DBPassword : ******* ,DBServerName : TEST10 ,AppOwner : IFSAPP 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[ReadLogonInfo] ssss 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[LoadReport] Processing 2 parameters. 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[SetTableLocation] Set appropriate post-fixes for REI_WORK_CENTER_LOAD\ 6/18/2020 11:23:18 AM[IFSCRWebSetup]-[SetDatabaseLocation] Generating fully qualified database object name for ABC_WORK_CENTER_LOAD\ 6/18/2020 11:23:18 AM[IFSCRWebSetup]-ERROR in [ExportReportWithParametersAndlogonInfo] Error in exporting the report in rpt format. 6/18/2020 11:23:18 AM[IFSCRWebSetup]-Failed to load databas

Hello!  I’ve been trying to clear down some operational transactions in order to change the base for cost/revenue elements from code part A project to another code part (with no function)  I have cleared all the transactions and there are no errors.  But when I try to change the base I still get an error: “It is not possible to change the base cost/revenue element as there are non-transferred PCM transactions”  I’ve been trying to find out what PCM transactions are and where they are with no luck -  Does anyone have any ideas on where this may be ?  The Error Message Any suggestion is welcome!! Thanks,  Mish   

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