Hi Piyal, Hi Susith, Thanks for the reply. I get the reason what the check box does.I’m trying to use this condition on my report for showing “only” the Changed/New lines.The Purch_Chg_Ord_line shows few other lines also and the ObjState/Status column for all those lines are same. When I hit this check box, it show only the lines that were “really” changed.So I want to use that condition on my report to show only the changed lines rather than showing all from Purch_Chg_Ord_Line
I think you can use “Line Status” column easily for your requirement. Hi Piyal, Unfortunately, Line_Status isn’t helpful.. please see the attached before and after differenceBEFORE AFTER
Aha.. status of the PO line ‘Cancelled”, you may have to filter out. That line noting to do with POCO. If you look at the before picture.. you will see line items 14,15,16 etc also are cancelled.i.e. Line_No 22,23 has same status as Line_No 14,15,16 etcSo I’m sure that the check box is using something different.
Hello, You may need to check what is the underline query executing for the given records to be shown in your environment. As mentioned by Piyal the given lines will not be shown in latest reference environments. Hi Dumeesha, Thanks for your reply.. Do you know how can I see what query is executing when that checkbox is clicked ?
Hi Nadeesha, I have this already.. but still it does not work.The report still shows the default value of the parameter (False)
Hi Nadeesha, Unfortunately, these options did not work.I tried TRUE, True, ‘True’ …. it still kept showing False - which was the first value of the Boolean parameter on the report.
Hi Nadeesha, thanks for your suggestions..I did a work around and added LINE_NO as Source_Key_Name for the MenuItem1 and did not add this Qucik report parameter for MenuItem2By this way.. when the Parameter ISNULL() I can Suppress the Summary field. Passing Static value won’t work as we expected.. so instead I passed some field name which would always have an value and use ISNULL() to suppress the Summary field on the report.
Hi Guys, Is there any workaround for this.. ? I badly need to sort my Custom LU which is a list and that looks horrible without any sort order.
Hi Sandun, I wanted to add more column to the record selector for Request for Order Quotation view… which means that is not possible.Anyways, thanks for you support !
Hi Infaz, I’m on APPS9 Regards,Rajesh
Hi Anmise, I did change all ifsapp. to &AO.. but still I get the same error. select emp_no, &AO..Time_Pers_Diary_Result_API.Get_Presence_Hours(company_id, emp_no, valid_from, valid_to) presence,&AO..Time_Pers_Diary_Result_API.Get_Absence_Hours(company_id, emp_no, valid_from, valid_to) absence,&AO..Work_Sched_Assign_API.Get_Sched_Hours_Db(company_id, emp_no, valid_from, valid_to) schedulefrom &AO..AUTHORIZATION_EMP
I’m connected to the dB as IFSADMIN which should have access to that IAL object.. am I right ? P.S. I’m executing the below query via PL/SQL where I’m connected to dB as IFSADMINSELECT * from IFSINFO.Get_Total_Additional_Hours
Hi Anmise, I did change all ifsapp. to &AO.. but still I get the same error. select emp_no, &AO..Time_Pers_Diary_Result_API.Get_Presence_Hours(company_id, emp_no, valid_from, valid_to) presence, &AO..Time_Pers_Diary_Result_API.Get_Absence_Hours(company_id, emp_no, valid_from, valid_to) absence, &AO..Work_Sched_Assign_API.Get_Sched_Hours_Db(company_id, emp_no, valid_from, valid_to) schedule from &AO..AUTHORIZATION_EMP You will need to grant the IAL to one of the permission sets you are granted. There’s a tab in the permission set screen called IAL. Hi Anmise, Thanks a lot.. I had to grant right to the new IAL object to my IAL permission set I can now access the table with the query.
Hi Susith,I managed to increase the dialog box size, thanks for the help.I also tried to add ADDRESS3 and saved the layout etc.. but the new Address3 line does not show up. Please see below
I have logged in with admin rights.. I don’t see Max row count and User defined row count columnsAnd also when I try to add more than 6 fields, it says the max allow fields are 6Am I missing any setting ? P.S. I’m on APPS9
This is the error I see when I add Address4.I don’t see this error when I add Address3 alone, but still it does not show the new address boxes in the Address Sample or on the layout.
Hi Dumeesha, Where will I find these xml tags ?
Hi Reol,Thanks for your reply.In the end like always the solution was simple.I had to grant access to Site 20 for the IFSPRINT user accountOnce that was done, everything seems to print fine.
A quick answer to this question would be no. However, just to see if there is a work-around. Could I know which values you expect to change and what sort of update is your expectation ? Best Regards, Ed.Praveen Wijetunge Hi Praveen, I have a custom field called ‘drawing sent’ and I want to record the history when someone changes the drawing sent field from Yes to No or vice versa.
@geminirajesh isn’t it possible to enable History Log for this field? It would not be visible in the PO Line history. But you would see when somebody has done any changes to the field. I will try this...
Hi @geminirajesh Is this common for every part or for few parts? Best Regards, Tharaka. Hi Tharaka,It is common for every part.The document text option is enabled when I login as a different user. So the problem lies with my particular user account Regards,Rajesh.N
HI @geminirajesh , Another question, Do you have this is only at purchase part? If not, the setting is as follow in presentation object per component (printscreen is from IFS10): Can you please let me know how to get to this screen ?
Hi Randini,I tried the below SQL query and got that invalid identifier errorselect ifsapp.Customer_Order_Line_API.Get_Shop_Order_Info('N22-0225','1','1','0') from dualAny idea how to use that API call ?
Thanks a lot for your suggestions.Unfortunately my CO lines are not Project connected, so I guess that makes the above suggestions won’t work for me.Is there any way to find the shop order numbers for the CO lines that are not project connected ? P.S. I usually rely on Inventory part availability planning screen to get the shop order number, but that is a pain when the same part number is used in multiple CO lines.
Hi Ozgun, My inventory part type is manufactured and I don’t see DOP in the Part type LoVor am I looking at the wrong field ? And I also looked at the DOP headers and I don’t see even a single record. I guess I’m not set up to use DOP Regards,Rajesh.N
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
