IFS Solutions

Hi, Can you help me for Purchase_Part_Supplier Data Migration. We don’t want to write for all rows in excel for column “LINE_NO”. We can arrange it with a select statement but I couldn’t do it. This doesnt work. (selectMAX(line_no)+1 FROM PURCHASE_QUANTITY_PRICE ppsWHERE CONTRACT = pps.contractAND VENDOR_NO = pps.vendor_noand PART_NO = pps.part_no) Thank you. I attached a similar problem from community as well. Excel migration issue with update of purchase_quantity_price | IFS Community  

Hi,I have issues with running an Excel Migration job updating valid to date on the current price line on supplier price list (purchase_quantity_price). I get the familiar error “Object does not exist”, but I have all key attributes present and the same job works in another IFSAPP10 database for the same customer. The job is set so that the only attribute to be updated is “VALID TO DATE”. Has anybody had issues with updating purchase_quantity_price?I can say that creating new records works fine. B.RPer

Hi,I am looking for advice on setting up Document Management in a way that ensures individuals who access documents with different classifications (Public, Sensitive, Highly Sensitive, Confidential) are aware that secured documents should not be sent outside the organization. Is there a way to configure this in the system? Or does anyone have suggestions on how this can be achieved?Thank you for your help!BrLinda

Unable to log into Demand Planner - receive below error message. Thank you! 

Simple Integration from IFS Cloud 23.2.10 to an application called Blackline that uses REST APIs. This is the authentication method using Postman – everything is sent over in the message Body:This returns a Bearer token. Then I call an accounts reconciliation endpoint and authenticate using the Bearer token returned above, like so:The message body contains the accounts information and amounts, like so:(dummy data)C0004 9001        AT020 1102  BK    12111                   BKD - Cash - Group      Cash  A     Asset TRUE  TRUE  GBP   USD      06/30/2018  10000.00    12000.00    11000.00 I believe I should be able to create a Routing Address like this:Link this to a Routing Rule and then create a procedure in a package (using Dev Studio) that uses the PLSQL_REST_SENDER_API.Call_Rest_Endpoint method to create the PUT message, construct the message body with accounts data (from a SQL statement) and then send to IFS CONNECT to be picked up by the routing address/rule above. This routine will

Hello.We made a custom report which uses the UNIFORM_PAYMENT_ADVICE_REP table to make the report, and we have a report rule to send the report to suppliers, but sometimes, the report is well generated, sometimes, the report is empty.On the report rule screen, we defined the following condition :select NVL(sum(payment_amount), 0)from UNIFORM_PAYMENT_ADVICE_REPwhere result_key=[#ResultKey]  <> 0 To generate the report, we have this main sql query :SELECTRESULT_KEY,    SUPPLIER_INFO_API.Get_Name(LEDGER_TRANSACTION_SU_QRY.SUPPLIER_ID) AS SUPPLIER_NAME,    SUPPLIER_INFO_ADDRESS_API.Get_Address(LEDGER_TRANSACTION_SU_QRY.SUPPLIER_ID, 'ADD_DEL_FR_0001') AS SUPPLIER_ADDRESS,    COMM_METHOD_API.Get_Value('Supplier', LEDGER_TRANSACTION_SU_QRY.SUPPLIER_ID, 2) AS SUPPLIER_EMAIL,    UNIFORM_PAYMENT_ADVICE_REP.Payment_Address AS SUPPLIER_IBAN,    LEDGER_TRANSACTION_SU_QRY.COMPANY,    LEDGER_TRANSACTION_SU_QRY.PAYMENT_ID,    LEDGER_TRANSACTION_SU_QRY.LEDGER_ITEM_ID,    LEDGER_TRANSACTION_SU_QRY.

Hi, Is anyone avare of the setup which enables employee to report flex time for day off days.In our customer case the situaion is that there is overtime rules for day off -days for example an employee works normally from monday to friday and saturday and sunday are day off. If an employee works on saturday or sunday based on his/her own will the time is flex accrual, if she/he is asked to work from employer/customer side during the weekend then the time is based on overtime rule. Overtime is calculated when the employee report overtime cash in/out, how about for the flex time for day off how to do the in/out reporting?BrEevastiina

I have a requirement to translate the "Complete" command for WT in the My Work Tile (MWO) app.In the translatable text, I only see the following two paths for "Complete Prog Text" under the path %ServiceEng%. However, it seems like these paths are not related to the "Complete" button for WT in My Work Tile. Does anyone know how to add a new path, or if I am mistaken, how to translate the "Complete" button for a WT in My Work Tile to any other language? adding language translation to below two paths did not translate the Complete command   

Hi All,Our environment is SSO configured and users login using their network login.We installed the Print agent and tested reports. It looks like reports picks up the Print Agent and I can see Print Jobs in ‘Complete’ state in Print Manager.Printers we have are network printers and users need to login to the printer using their user network login id in order to print reports.Now the problem is, reports sent to the printer queue has their owner as the service running the IFS Print Agent. Therefore it is not possible to see jobs when login to printers using network user login and print reports.How can we change the printer queue owner to user login?    

Good day.  I would just like to confirm.  Is Position Access/Supervisor Access always required for Approval of Expense Sheets, even if it is a direct subordinate of a Manager creating the Expense Sheet? Thank you.  Anya.

We have been building our Maintenance surveys for Aurena in a test environment. I am not able to find how to add those to an app package or be able to export them for importing into the production environment. Is this a possibility to do? We have a lot of layers developed and would rather not do them manually again. 

I have a case in IFS 10 where I need 4 operations on a shop order on the same work center. I would then afterwards like to connect these 4 operation with 4 operations from other shop orders in a block. But it is not possible to add more operations on a shop order to the same block, why?

Is there a quick way (now that F9/Zoom isn’t an option) to identify where Basic Data for each Dropdown lives?  For example, if I needed to set up a new Shipment Type where would I do this?  What would the view be under in the Navigator? If I type in ‘Shipment’ there are at least 50 entries.  How would I which to choose?  Is there any logic to help?  Is it always TOPIC Basic Data or Basic Data TOPIC?  Is there a debug/page info clue?   Any assistance gratefully received.

Hi,We are experiencing some issues with synchronizing FSM and PSO unavailabilities. When an unavailability is created in FSM, it is automatically reflected in PSO. However, when the unavailability is deleted from FSM, PSO is not updated and continues to show the unavailabilities that have already been deleted in FSM.How can we proceed to update PSO according to the changes in FSM?Thank you.

Hi,I’m facing the below exception while creating/making changes in team ID.  

Dears,Can someone guide me what I need to write exactly to hide few fields in Mobile based on access group. For web client I have done it for mobile how it can be done?Below is my mobile script to hide the fields let me know anything I am missing in the script.RequirementIn mobile I am trying to hide user_def16 and user_def17 from part_usage table and bin_id from stock_bin table based on the access group (which is ‘ELUX_US’) .  var taskId = getCurrentKeys("task", "task_id");var partUsage=getCurrentKeysvar binID=getCurrentKeysvar AccessGroup = getDBValue(stringFormat("SELECT access_group FROM task WHERE task_id = {0}");if (AccessGroup == 'ELUX_US') {        setControlVisibility('part_usage','user_def16',true);    setControlVisibility('part_usage','user_def17',true);    setControlVisibility('stock_bin','bin_id',true);    }           else{    setControlVisibility('part_usage','user_def16',false);    setControlVisibility('part_usage','user_def17',false);    setControlVisibility('stock_bin'

Hello, Trying to implement a user available excel migration file and have to solve two problems to make it useable.  problem 1) Want to make one of the columns a drop down with 5 to 6 options for ease of input and formatting. Other values could be manually input but the drop down would contain the most frequently used values. Would prefer to do this using Client Values and not DB values. In this example it would be the Work Task Template ID  - Description - Rev. Problem 2) This specific migration container is to a custom page and the primary values are Contract and Line No. The issue is that the migration file is asking for line DB value and the user will not have access to that information since its not viewable in the client. There is an API call to the OBJKEY on that table which is the DB value for the Line Number. Trying to determine how to have the file fetch the DB value after the user specifies the client value.  I’ve scoured documentation and watched numerous videos with no luc

We have two specific tax scenarios which I presume would be consistent amongst any customer using the Avalara service...so hopefully I’m not breaking new ground with this question.  We have ‘freight’ and ‘sales tax credit’ setup as Sales Charge Types in IFS.  But there is no way to assign an External Tax Parameter to a Sales Charge...I only see that for Sales Parts.  Without a mechanism to assign a tax code mapping, these charges then get passed to Avalara as taxable.  How are other customers addressing this?  Are you create these as sales parts and then adding them a lines on your orders?  Is there already way method to handle this that I am missing?

the download icon and preview icon is missing for this user What can be the reason ?I have cleared the personal profile , has given full access still cannot see it .  

Hi, i’m tying to query in Aurena  project filtering by  Created_date field , when i try to perform this query i retrieve this error  {    "error": {        "code": "ODATA_PROVIDER_ERROR",        "message": "An internal server error occurred. Contact administrator.",        "details": [            {                "code": "TYPES_NOT_COMPATIBLE",                "message": "The types 'Edm.DateTimeOffset' and 'Edm.Date' are not compatible."            }        ]    }} this is the query that i trying to perform:   Someone know how can i solve that ? Thanks for the Help.

Hello everybody, The client would like the “Card No” to be longer than 10 characters. Is it possible to modify this? 

We have shop orders in process that will be completed but cannot ship until quality approves shipping. Inventory is lot tracked. We cannot put availability control on the lot because the shop order is still in process. What is the best practice to prevent a shop order from shipping when it is completed? Can availability control be setup ahead of time so that when the shop order is received into inventory, there is a control on it?  Regards,Eric 

There is a day forwarning column in the maintenance plan. I would like to know which screen or column uses this data. I was unable to identify this information in the help.I think it is the Next Interval Maint screen where only maintenance intervals within the period defined in the days forwarning column are shown. 

I decided to create this conversation as I don’t see this issue addressed clearly in other areas of the IFS Community. Although it is alluded to in other questions, no real answer is provided by IFS that has been satisfactory (or maybe it is but I could not find it).The question is simple: Why has IFS fully restricted the execution of any IFSAPP API’s to the user accounts given to Customer’s IT departments to connect to Oracle (that is, IFSINFO and IFSDBREADONLY)? What alternatives does IFS provide to Customer’s IT departments to perform some tasks that are SAFE that were entirely possible in APPS10?I would like to expand a bit on what I mean by SAFE API calls. In the past, IFS Consultants maintained that the state of IFS Database Access to Customer’s IT Departments was presenting a risk, as users (with the IFSAPP password) could do whatever CRUD operations they wanted against the base tables CIRCUMVENTING IFS API USAGE and that was very risky.Fast forward to IFS Cloud architecture and

Hi Everyone, Just come across the negative value of the unit cost of the part. any understanding how to fix this ?  BrBT