Solved

 I know that you can add a new adjustmnt_reasn in Code Tables,  but how does an adjustment_reasn get entered into the records on part_tranlog, is it only when a stock count is posted?     

Hi,   I have some quick reports created in IFS 10, and suddenly, one of them stopped exporting data to excel. Inside IFS, I can see the values I am querying, but in excel I get the “No data found!” message on the first cell.  Does anyone know what might be causing this sudden error and how to get around it?

Hi, I’m trying to figure out how to install IFS EE Extension for all users via ConfigMgr. From my testing I can’t get it to work then doing it in SYSTEM context. Has anyone found a solution for this?    When I do it manually (starting the ifseeextensioninstall.msi) with a user account that have admin rights on a machine, it works correctly. But there must be a solution where the user doesn't need to be local admin, right? Best regards/ Tobias Sandberg

We have recently begun developing reports in BA.  We have published several for our end users to run on demand, but when the reports open in Excel they are blank.  This only happened for the end users without the BA Excel Add-in installed.   No errors are received, they just get a blank excel spreadsheet.   It was my understanding that the end users would only require the Execution Server and obviously be granted access through their permission sets to see the reports. Is there another piece to this that we’re missing that would cause everything generated for end users to be blank? 

How do I determine which Projections I need to grant in order to give permission to do a function in Aurena?  For example, if I want to grant the “Report Time” function, how do I find the projections to grant?

Hi All,   We are proposing GDPR functionality for a customer in APPS10 UPD 6 and noted that First Name and Last name in the Personal File is not included in meta data (Personal_Data_Man_Det)     Is this due to a bug or is this something configurable?   Cheers! Damith

Hello, Our users request a custom RMB from “register arrivals” to the related demand source of type “Shop order” (use case outside operations) in IFS 10 Update 6. This was already implemented in IFS 8 SP1. Due to changes in the view, required source columns are only referenced from the client, but don’t exist in view. in Form Register Arrivals, the relevant data is displayed. column Demand Order Ref1 is not a field in the view. it is a referenced value (...api.get...) Custom Menu definition requires a source column in the source view - which does not exist   other approach could be: Idea 1: source Key Name could allow to use a bind variable of the column name of the form like: :tbwRegisterArrivals.colsDemandOrderRef1 Idea 2: source Key Name could allow to use a get-function of the format like:    &AO.Receipt_Info_Manager_API.Get_Demand_Order_Ref1(SOURCE_REF1,SOURCE_REF2,SOURCE_REF3,SOURCE_REF4,SOURCE_REF_TYPE_DB) There is the same problem when defining a condition for Custom RMB. I

I have created custom menus in several screens, and they are working. But for one custom menu I want it to display only there is a value in a specific field. Therefore, I used conditions. But seems the custom menu is not accepting the condition. I have tried most of the conditions in below site. https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm Ex:  MINIMUM_QTY IS NOT NULL MINIMUM_QTY <> NULL MINIMUM_QTY != NULL MINIMUM_QTY = “” MINIMUM_QTY = ‘’     The custom menu when no value     The custom menu with value     If you have faced similar, please share your findings.

I have a Quick Report (Crystal Report) that has the parameter WO_NO (work order number).   The report works fine.   Created a custom menu on the work order header and in the custom menu set the Quick Report Parameter as: Source Key Name = WO_NO Dest Key Name = WO_NO This again works fine but the user has to press enter when the parameter screen displays the Work Order No.   Can this be set to AUTO accept the value being passed?

Hi, we have an issue where we want to use document attachments for expenses. The users who will need to be able to view the attachment is the employee the expense sheet has been created for, the employees manager and an administration team. Generally the employee is inputting the attachment so will automatically get permission to see the document, adding an administrative team is easy but how can I get the employees line manager to view the document without opening the document up to multiple other users?ThanksHelen 

Hi,   user is requesting access to RMB option on PO screen. Can you please guide me how to give access thorugh permission set

I know you can request an emergency license (last 3 days) from IFS using the link provided.   This generates a license key.   How do I apply this?  Normally, we receive an xml and click apply then select the xml to license the software.   Thanking you in advance for your help.    

Hi Everyone,   Once material has been loaded to a Preventative Maintenance Plan and it is viewable in a Single Page Report, how does one generate a picklist to issue material to a Works Order?

Hi all, Is it possible lookup the local check-out path inside a SQL block?  

We are looking into expending our IFS 10 environment with Case Management. However we have the desire to use some kind of (B2B) portal so that our customers can register cases and look at the status of their cases. I cannot find any information regarding this being included in the Aurena B2B. Does anyone have any experience with this?

Hello, I would like to now, how is possible migrate sticky notes into Apps10. This is a part of data we need migrate on the upgrade project from Apps7.5 → Apps10.   Thank you in advance, Jozef

Hi Validation of Accounting Period Transactions in Progress shows Transactions Exist:   How do we identify the transactions in order to resolve? Regards Shaun

I have a lobby element which uses year period as a parameter, is there a way to have the description show in the title, rather than just the year period. e.g. if I enter ($YEAR_PERIOD$) in the title, it correctly shows 2020-07, but I’d like it to show January 2020.   Is there a way to use a SQL query in the title?

Hi - i would like to be able to query all CUPOA’s entered in Biz10 that have been entered in Mixed Payments.  Is there a way to return a search for all of these types of prepayments?

Hi all (me again!)   Off the back of my previous topic and @RavinduS help I have managed to import my price list however I have hit a different issue.  If I enter a sales price manually on the Sales Price List → Part Based tab (and press tab/save) it will auto populate the following fields. Calc Sales Price Sales Price Incl Tax Base Price Base Price Inc Tax When creating the migration job the following fields (with flag MIU) are required to have a value which normally are auto-populated off of the Sales Price being entered however if I don’t enter a default value the migration job error’s out demanding that the field has a value. ORA-20124: Error.NULLVALUE: Field [SALES_PRICE_INCL_TAX] is mandatory for Sales Price List Part and requires a value. For now I have entered ‘0’ into the default value field to get around the error for the following fields. BASE_PRICE BASE_PRICE_INCL_TAX PERCENTAGE_OFFSET AMOUNT_OFFSET SALES_PRICE SALES_PRICE_INCL_TAX The downside is that having a default val

Currently, when adding a new button (within command groups in the page designer) it seems that the ExternalNavigationLink is being restricted to prefix with either http:// or https:// - is there any way of calling a custom scheme / protocol (class) registered on the PC?   I have a local class that has been associated with a software in where I want to invoke it from Aurena. Is this even possible?

When I create a new Change Request Record I would like to Auto Populate the “CR No:” with text like the following. ABC-0001 Where the 0001 would increment up as a sequence.   So after creating 5 Change Request I would have the following “CR No:” in the system.   CR No: ABC-0001 ABC-0002 ABC-0003 ABC-0004 ABC-0005 Any help would be greatly appreciated.  

Hi IFS, I have created a custom field which accepts data from another custom field. The second custom field is a type of reference and it is in a custom logical unit. The first custom field gets data from the List of Values.  I noticed same column is duplicated in the list of values window and it contains data which I have not entered. This behavior was not in the past. Any suggestions to avoid this?    

Hi Using the custom event STEP_READY_FOR_APPROVAL  as part of the document management approval routing to send an email. Email subject is using the variable &MESSAGE_TEXT which as an example contains the following:  “Document Class 3015, No 1678422, Sheet 1 , Rev REV00 is ready for your immediate approval” My questions is there a way to amend the content of this variable somewhere in IFS? We are using Apps 8. Thanks in advance Shaun

Hello, I have made an event that throws an error message to the user, using the error_sys.record_general function, based on some criteria set in the event, which triggers on a change in the status of the object.  error_sys.record_general( 'SomeLogicUnit', 'SOMEERRORMSG: this is an error message'); I am in the process of creating another event that will change the status of the object, but I am wondering if it is possible to catch the exception raised in the other event, and handle it separately?  Without handling the event, and running the event manually in a DBMS, the procedure completes, but returns ORA-20110: SomeLogicUnit.SOMEERRORMSG: this is an error message   My event would look something like this: BEGIN --change status on object, which may cause an error to be raised in the other eventEXCEPTION WHEN ... THEN -- handle the exception raised from the other eventEND; If I specify “EXCEPTION WHEN others THEN … “ I will catch the error raised in the other event, but I won’t know t