- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
Search

Replies posted by ludovic.rougean

51 Replies

Newest first

Oldest first

Sanjay.KDo Gooder

asked in Getting Started with IFS

Error when doing changes to PO

Hi, you cannot prevent it from appearing by default, that’s a normal process. if your PO is approved, you must go through a Purchase Order change order to amend it, because it must go through the approval workflow again.

HarikrishnangrSidekick (Customer)

asked in Supply Chain

How to disable add new records button in shop order

Hi, not sure what is your level of confidence with permission sets, but it’s where you can find your solution. Each screen is attached to a package (API): (i don’t have shop order, but same principle with purchase order) Then you go in permission set and you can search for this API in Database Objects. When you click on it, you ll see that each API is connected to “Methods” and you will find a methods called “New_” or similar. That is the one(s) you must deactivate in the permission sets given to your users. To know which permission is granted this method, just right click and choose “Show Grantees”

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to create Custom event action on custom field table to save data to the same table for other records

In this case, I’m sorry, you need to know a bit of PL/SQL, i would not know where to start.What I can tell you is that you may face a problem if you try to just update this value straight away as your table is in a locked status due to other modification on going.You should update your 2nd field though a background job. So first your table will be saved and then it will update your 2nd field, few seconds later.This post describes how to create a background job:https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/inserting-a-value-upon-new-data-creation-on-custom-logical-unit-24431?postid=89780#post89780That’s basically 2 procedures imbricated.By amending the code of the procedure in the middle, you should be able to achieve your objective.

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to create Custom event action on custom field table to save data to the same table for other records

Hi, what is exactly the difficulty you are facing? you don’t know how to make a custom event? or you know how to make custom events, but when you tried this one, you got an error message saying you cannot update this table ?

sood33Do Gooder (Partner)

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

Sorting of IFS Screen data when navigated through a Lobby Element

It can be done through this option: This thread is talking about it:

sood33Do Gooder (Partner)

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

Sorting of IFS Screen data when navigated through a Lobby Element

Hi, I may not have understood your question properly, but in Navigation you can filter the target view by specifying relevant target column (NB: make sure you name them exactly as they are in the target view) and/or through the URL that can also contain filters.You can have something a bit more sophisticated URL thanks to “external search” function:ifsapf:frmAvailabilityPlanning?EXTERNAL_SEARCH=CONTRACT%3D{&CONTRACT}%26PART_NO%3D{&PART_NO}%26PROJECT_ID%3D%23If needed, you can easily find other discussions describing this function.

ludovic.rougeanHero (Customer)

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

Long running call: GetCountAttachments

First of all, thank you for taking the time to answer my question. We do not use Restricted Access, only 1 document has got it, but your message confirms the problem is related to the document management. Actually I just got the info that this day an employee attached 146 documents to an invoice, that maybe triggered this issues...

ludovic.rougeanHero (Customer)

asked in HCM (Human Capital Management, Payroll)

Hiding wage code of type absence to avoid manual entry

Thanks, that’s an interesting point. However the change is effective on Aurena only but not on App10 interface.Anyway i guess that’s the only thing we can do. Thanks again.

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to get SQL code behind Order report

What proposed Thomas is clearly better and I also realized you can see it from the permission set, in component part.

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to get SQL code behind Order report

You searched for the package %FIN011B% you got nothing ?If no, it seems your report is custom, actually I do not have it on my DB. In this case it could be included in another package or they may have used an other name for the package, you try several combinaison including %Part%Provision% until you find an RPI package that seems matching…

HarikrishnangrSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to get SQL code behind Order report

Hi, you should get the ID of the report from the view REPORTS:Or you can also use the Debug console.Then with the ID, go to PL/SQL Package Code, and the search for the ID, replace REP by RPI.ex: PART_CERTIFICATE_REP → PART_CERTIFICATE_RPI

hassen.sbaiDo Gooder (Customer)

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

scheduled task

Hi, not sure i can help, but you should send a screen shot of an example of schedule task generating this error.

firat.yucelDo Gooder

asked in Supply Chain

how can i filter products sort by last arrival dates

After a 2nd thought, something like that could work: I’m not an SQL expert, but assuming the SEQ_NO is your key column (just a dummy example), if you manage to get a pre-selected list of items with the max receive date in the sub query behind the IN function, then it should work.

firat.yucelDo Gooder

asked in Supply Chain

how can i filter products sort by last arrival dates

If you need columns that are specific to each line such as the price, then yes, it will not work with simple grouping. You must first perform a subquery to isolate the items with max date and the key columns and then make an INNER JOIN to the main table to retrieve all remaining columns for these pre-selected items. That is not possible as far as i know from the SQL tab in the advanced search as it only proposes a where clause. You could easily achieve this through a Quick Report but you may lose some right click functionalities. If that is a must for you to get it as a view and not as a report, then you can create a custom logical unit with all required columns and a schedule task that regularly refresh this list, then you can add custom menu to it.

firat.yucelDo Gooder

asked in Supply Chain

how can i filter products sort by last arrival dates

Hi, if i understood your question, just select Highest in grouping option:But when you group, you must specify which field to see and you must ensure one of them does not disturb the grouping, same as GROUP BY option on SQL.

ELJOSidekick (Customer)

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

History Log on User Permission set

Hi, you must activate the log of the table FND_USER_ROLE_TAB. It may not be available by default.Make sure to select show Foundation1 Component. Then it works as usual and you can track any modification of access rights related to permission sets.

asked in Getting Started with IFS

What is your favorite mode of Training?

For new comers and generic knowledge, if you are not able to organize trainings internally, IFS classroom is ok and convenient, although there are not enough class organized, and the few are mainly focusing on Cloud version.But on day to day, I’m convinced that the best form of training is the contextual help. It is possible to customize the online help and thus provide specific contents on each every screen. Users do not like user guide, they never read them, trainings are usually quickly forgotten if the user does not apply it regularly, and e-learning are highly time consuming. So contextual help provide the exact amount of data at the right place.

cbilodeauDo Gooder (Customer)

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

Custom Field with #USER_ID# as the Context Substitution Variable

I think it is possible if you create an event that runs in the background because it will force recalculating the value every time you insert a new line.There is an article on this subject if you understand a bit PL/SQL:https://dsj23.me/2021/08/27/tips-to-avoid-mutating-table-error-in-ifs-event-actions/

cbilodeauDo Gooder (Customer)

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

Custom Field with #USER_ID# as the Context Substitution Variable

Hi, how or where did you set up the value by default with #USER_ID# ?

ludovic.rougeanHero (Customer)

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

Why is my Writeback function remaining GREY?

Actually that was only a problem of access rights …Although I thought I had all the permissions, obviously somehting was still missing and when I added:all worked fine.

ludovic.rougeanHero (Customer)

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

Display a question on a form

Thanks all for your suggestions. I have created a read only field based on a simple mandatory drop down value with a CLU that holds a column per question linked to this dop down value and it works. Although it s not clean. I just wanted to know if there was something embedded within IFS that i completely missed, and the answer is no.Thanks again!

ludovic.rougeanHero (Customer)

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

Display a question on a form

Hi, thanks for your interest in my question.It ‘s in the project screen. We must answer the question depending on specific service lines/activities chosen (both are custom fields). I was thinking of making an event to make the answer to the question mandatory or not. The problem is really to display this text. I thought to put the question in a a read only custom field that would display the question based on the activity chosen, however it requires to refresh the screen in order to update the field, and thus if the answer field is mandatory because of the choice we made, the question will not display before I select the answer.

ludovic.rougeanHero (Customer)

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

Search fields related to my CLU are empty in the search window

Just to complete, actually I finally understood that the changes made on this part such as adding an attribute in List of Values require to restart your session to see the changes. Updating or reloading configuration does not help (my version App10 upd13).

ludovic.rougeanHero (Customer)

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

Search fields related to my CLU are empty in the search window

Hi, apparently the problem solved by itself, now I can see something in the search window...

ludovic.rougeanHero (Customer)

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

Creating a read only attribute in a custom logical unit referring to another custom logical unit

Just to complete what I wrote earlier, although it was interesting in terms of understanding how IFS works, the easiest way to achieve the same is simply to choose ‘Reference’ for the custom field, it will give you the data straight away without any headache.

1
2
3

Page 1 / 3

Badges

LefaNokohas earned the badge 1st Topic
Thilini Wijesinghehas earned the badge 10th Reply
Harm de Brouwer 12Guidehas earned the badge 5th Topic
bjoverhas earned the badge 5th Topic
OIVINhas earned the badge 1st Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK