Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

chrisplantSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

restrict access to specific fields to specific users

We use permissions sets to specify whether users have none, query or full access to screens, but if for example 10 users in a permission set have full access to a screen, whats the easiest way to only allow 1 of them to update a specific field on that screen? Thanks, Chris.

12096

4 years ago

BLLBrucemoSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Is there any report or screen where i can see which customer invoices were printed or emailed?

We have started to email invoices to our customers, but we also print invoices.Am struggling to show the business which invoices went via email/which print but not sure the best way to do this. Any thoughts?Only thing I can think of is to query the application messages - but its quite a manual process.Thanks

3655

4 years ago

ADNANSidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Change Password Message Text Edit

Hello; I want to change the password warning message. Could you help?

1283

4 years ago

JouniSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Read csv from mail attachment

Customer is receiving fixed format csv files as mail attachment. We would like to read file content automatically inside IFS. Is there some way to do this? Data can be stored to custom view or migration table etc. Used version Apps 10

5375

4 years ago

TosohLBlumHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IALs as Datasource

We are upgrading from 7.5 to 10. We have many IALs that are owned by ifs_info. Is it possible to access these as datasources in the Lobby Data Source Designer? If so, how?

2392

4 years ago

DualtaDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

CONNECT_BY_ISLEAF multiply up QTY_PER_ASSEMBLEY

Using connect pror query belowhow would you get the QTY_PRE_ASSEMBLEY multiplying as it goes down each level?ORConvert this EQUATE_THIS coloum I have into as resule i.e *1*8*.022222 becomes 0.16 help Select PS.PART_NO As parent_part, PS.COMPONENT_PART As child_part, Level, PS.LINE_ITEM_NO, Sys_Connect_By_Path(PS.COMPONENT_PART, '\') As STRUCTURE_PATH, CONNECT_BY_ISLEAF, Case When PS.QTY_PER_ASSEMBLY < 0 Then 'BY-PRODUCT' Else 'COMPONENTS' End As TYPE, PS.QTY_PER_ASSEMBLY As QTY_PER_ASSEMBLY1, Sys_Connect_By_Path(PS.QTY_PER_ASSEMBLY, '*') As EQUATE_THISFrom PROD_STRUCTURE_HEAD PSH Inner Join PART_REVISION PR On PR.CONTRACT = PSH.CONTRACT And PR.PART_NO = PSH.PART_NO And PR.ENG_CHG_LEVEL = PSH.ENG_CHG_LEVEL Inner Join PROD_STRUCT_ALTERNATE PSA On PSA.CONTRACT = PSH.CONTRACT And PSA.PART_NO = PSH.PART_NO And PSA.ENG_CHG_LEVEL = PSH.ENG_CHG_LEVEL And PSA.BOM_TYPE_DB = PSH.BOM_TYPE_DB And PSA.ALTERNATIVE_NO = '*' Inner Join PROD_STRUCTURE PS On PS.CONTRACT = PSA

1562

4 years ago

RutJWhalenSuperhero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

HTTP Certificate Expiry Date location

Does anybody know if the HTTP Certificate expiry date is held in a view/table? The reason for asking is I wanted to set up in Application Monitoring a query to advise when the certificate is coming up for expiry, e.g. 30 days notice. Recently, only by carrying out a delivery installation did we get notice that this was due to expire in 9 days. I don’t want it to be this close again. I have a notification in Outlook Calendar but just wondered. Thank you for looking.

5902

4 years ago

reimccabeDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Search available fields in configure search dialog

Hello, IFS has added search capability in the column chooser, and the very handy “go to column” right mouse option. One place where it would be nice to search is in the search dialog, Configure Search Fields. Are there any plans to add the “search” option at the top of the available and show columns?

2573

4 years ago

envkavitaDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS hosting on VMWare software

Customer wants to move to a hosted environment (not cloud). It is possible to host IFS on Nebula(vmware environment). Azure stack does not support IPV6, whereas customer wants an IPV6 supported environment

64012

4 years ago

NarsiSidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick Report - data between two parameter dates

Hi,In Quick Report, I have to get data FromDate to ToDate using a DateTime columnI used this:WHERE o.REAL_FINISHED BETWEEN TO_DATE('&From_dd/mm/yyyy','dd/mm/yyyy') AND TO_DATE('&To_dd/mm/yyyy','dd/mm/yyyy') I’m getting when we go to view report It works fine When I export data I’m getting this error: Excel Plugin Error: Undefined bind variable 'from_dd' in Excel fileAny idea how to sort this issue?

13009

4 years ago

gianni.nevesHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Migrating my changes from an environment A to environment B

Hi,I am new in IFS system and I have huge implementations that involves many windows. Is there an option to export/import to migrate between many environments?Somebody that works with me told me that I need to replicate manually all my changes in each environment. It’s hard to believe, so anybody can help me?

5156

4 years ago

HayleyGDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Calculating Custom Fields - Apps 8

HiI have created 3 new custom numeric fields, 2 will be manual entries and the 3rd I would like to add the numbers from the first 2 fields. Is this possible in Apps 8?If so does this need to be done via a custom event? Would be much appreciated if it is possible for some to send a screen shot of how. Below is a screen shot of the fields I am referring to, and the one circled is the field I want the calculation to appear.

69021

4 years ago

IFSmattisSidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Showing Coordinator of external customer order in shipment as custom field within IC workflow

Hello all,we want to see the coordinator (authorize_code) of the external customer order in an inter-company process in the shipment-header of the supply site.I created the following three-step-logic which is working ok. But does anyone of you have a smarter way of finding the right coordinator? It is a bid of a mess I have to admit: CF$_C_COORD_PRCPL in supply_order_analysis:select authorize_code from customer_order where order_no in (select order_ref1 from supply_order_analysis where tree_id = :tree_id and node_id = '0') CF$_C_COORD_PRCPL_SPM_LINE in shipment_line_cfv:select CF$_C_COORD_PRCPL from supply_order_analysis_cfv where order_ref1 = :source_ref1 and order_ref2 = :SOURCE_REF2 and order_ref3 = :SOURCE_REF3 Cf$_C_Coord_prcpl_shp in shipment_cfvselect CF$_C_COORD_PRCPL_SPM_LINE from shipment_line_cfv where shipment_id = :shipment_id and rownum<=1 Is there even an API that I did not find so far?Any ideas to fetch the value in a smarter way? Thank you!BestMattis

1731

4 years ago

SANJSidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Read Attachment from Mail

Hi All,Is there a possibility in IFS to read the attachment from the mail and place the file in the corresponding path by using Mail Reader or by any other mean ?

2671

4 years ago

DalShiloZSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Priority waiting background job execution

how can i Priority waiting ( background job ) execution use Application basics setup

1741

4 years ago

DalShiloZSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How can i set Permission with IFS screen control (read only or full control)

How can i set Permission with IFS screen control for user (read only or full control)For example ------------------Read only Can searchbutCan't saveCan't newuse Permission set ? How can i do it?

4542

4 years ago

bengabSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Update of IFS Cubes

Is there someone that knowns any problem with sql server and updating of the IFS cube. We use SQL server 2017 and IFS 10? We find that the database is being updated by the scheduled jobs but the cubes aren’nt.

2062

4 years ago

SHAUN_KERSLAKEHero (Customer)

posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Functional vs End User Permission Sets

I know the topic of IFS permissions is never as black and white as we would hope, and each business may have a different view on how it should be implemented.We are now required to comply with SOX due to US ownership, so Segregation of Duties (SOD) plays a big part in regular audits! In addition, the existing permission sets developed previously have become unmanageable for the team and is difficult to report on access to management or auditors. This has effectively triggered a re-build of our permission sets across our business. I have started to build new functional permission sets to group specific access together which is common across the business. For example, MANAGE_PUR_ORDER, MANAGE_WORK_ORDER, AUTHORIZE_PO, VIEW_SUPPLIER, APPROVE_INVOICE and MANAGE_CASE which within has all the relevant screen/database access for those areas. We know around Finance, HR and Payroll modules we may need to be more granular with the functional PS controls. These functional permission sets are then

14314

4 years ago

gianni.nevesHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Excel tool - Misc. Parts from project module.

Good morning,I’ll try to explain my problem best as I can . I need to import my misc. parts data to a spectific project. My problem here is that I need for exemple my activity code and the person that seize has juste the activity ID. My question is: Can I put any kind of logic that allows me to fill out another cell based on the information seized?Exemple: When I seized my project and my activity ID, the cell acitivity code will be fill out automaticly.Let me know if you need more information Thanks,

3527

4 years ago

cjohnsonSuperhero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Conditional Formatting on Material Status

Hello, I am attempting to make it easier for Shop Floor users to understand when there is a material shortage on Shop Floor Workbench. Currently, on the materials tab, there is a red exclamation if a certain material is short. Is it possible to use conditional formatting to highlight that row to make the problem more visual? I have not seen a way or column on that tab where it could be setup. I’m assuming there is something that enables that status alert, but I cannot find the column to use for CF. Any help would be greatly appreciated. Thank you.

4212

4 years ago

krestensbSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Where does the reports go?

Hi,I’m after a printed report.Once a report (in my case an invoice) has been printed I can find a table with it’s XML, but not the PDF document.What I would like to do, is to create a document of the report once it’s been printet.Is there a standard way to set that up or could it be done with code?

2411

4 years ago

Krzysztof CiesielskiDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Where I Find E-learning to IFS?

Where I find IFS Documentation Online which include e-LEarning

10989

4 years ago

FajarDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS IEE Development Tool

Hi, Regarding IFS IEE Development tool, currently, i’m using Visual Studio Professional to do customized in IEE, can i use Visual Studio Express to do customized in IEE ? Thanks. Regards, Fajar .

8323

4 years ago

hwilkieDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Mobile App to Receipt Purchase Orders

Is there a mobile app that allows you to receipt both part and no part purchase order lines? I understand that the notify me app can allow authorisation of orders. Can this be configured to all the mobile user to receipt the order?

2636

4 years ago

RutJWhalenSuperhero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

On trying to log into IFS the user is receiving Contact the Vendor instead of the login screen. I have managed to get the user going by changed the default web browser from Edge to Internet Explorer. Can you please advise.

1262

4 years ago

Page 296 / 317

Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded