Solved

Does anyone know where can we change the configuration fields below directly on the database (Oracle)? We need to setup our database copy script so we don’t need to reconfigure it every time we restore a database in another environment (what we do a lot).    

I have a user that never receives the numerical notification in his Streams when he is sent something. If he clicks on the Streams button, he does see the task/notice, however there is not red alert to indicate it is there. He appears to be the only user this is happening to, and I do not see anywhere in Streams that there is a config to turn the notice on or off. Any help or guidance on this would be greatly appreciated. Thank you.

On the place screen, we have a “quick part price” button Using this will show you the list price of the part but nothing more. We have many part pricing rules in effect for specific customers but those numbers are only visible when adding the part to a part need. is there anyway to make this function work to look at those pricing rules? Doesnt look like it looks at the unit cost from the rule either.  

We have posted an Advance Invoice Agst Purchase Order at a Time of Final Invoice Posting we are facing This error Can sum please guide us on how to resolved This type of Error.    

Hello, is there anywhere specific to provide general improvement suggestion feedback about IFS? I’m talking about things that aren’t bugs per se and don’t really count as support cases but rather suggestions that could make IFS better - a suggestion box.

Hi All Is it possible to hide/inactive below highlighted fields for some users in system without any customization ?   Window - Customer Order    

I have Added a extension table to the place table. then added the new fields to the place screen. but when i go an update the one of the fields i am getting this error  “Column '' does not belong to table imax_place_extension.”   Can anyone suggest where this error is coming from.   If i try to post the update message in the XML Poster i get the same message.   <perform_batch> <sequential_dependent> <update_place regex_validated="true"> <place> <update> <original_place> <place_id>20759</place_id> </original_place> </update> <place_id>20759</place_id> <e_ref1>1000</e_ref1> </place> </update_place> </sequential_dependent></perform_batch> <perform_batch_result> <update_place_result> <result type="Exception"> <error> <system_error> <severity>ERROR</severity> <message>Column '' does not belong to table imax_place_extension.</message&

Hi, Due to summer holiday in the company, we have created the Schedule Exception with “day type” weekend for the period of time( two weeks ) in July 2020, as an example see  below for the 13-07-2020. However, we will still like to be able to create PO’s and recieve PO’s. Since our department for goods recieve is not closed. Does anybody have experience with that scenario ? What to do ? Best Regards, Marianne

We’ve created a new context/scope in Aurena and want to roll it out to users. The only way I can find to do that is by default company. We have several business units and would like some users to see one style screen, and other users to see a different one. They are all users with the same default company. Is there any other way to do this other than company?      

When entering text fields (like Part numbers) using the numeric keypad, the dot is shown as a comma. The regional and keyboard settings in Windows are set to keyboard layout en-US, which in every other application results in a dot.  Changing regional settings or numeric format in the IFS options gives no result.  Is there a way to influence the behavior of this? 

Hi , can anyone tell me  how to update the record in mobile  .when we create a new screen we are giving the primary table and selecting the fields  for the screen but when we enter the data the data is not stored , it just disappears what is the step that i am missing .

During our manufacturing process, we produce scrap. This is anticipated, as it is a result of stamping processes on our shop floor. A part will be stamped out, and the metal skeleton is collected and then sold to a metal scrapping facility. We have been setting this up as a by-product for each type of metal (stainless, copper, etc.). The issue we are running into is that our operators have to manually receive all by-product on the shop order. Is there a way to automatically receive by-product without having an operator need to report it during the Shop Order? Should by-product even be used for this scenario? I believe we needed to use by-product for the financial transaction of selling the scrap material: PN: 123456 produced 10,000 lb of scrap as a result of the mfg process, and it was sold to company XYZ for $6,000. 

Does anyone know how regular expressions work with FSM? As in, how do you specify the (input)value that needs to be validated and how do you specify the ‘Output format’?  There are some examples which sort of make sense, but it is to little to fully understand it.     

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