Hello @Narsi, Thank you for the prompt response. Unfortunately, the solution URL is not accessible to users who are outside of the IFS network. But, if your system is currently below UPD6, you can create a Support case and request for the fix unless if you don’t have plans to upgrade in to a higher UPD level soon. For your convenience, I will add the Bug Description below. Hope this explanation is clear with you. Cheers! Thanks for quick response, We are on UPD5, waiting for UPD11.Thanks,Narsi.
Hello @Narsi , What is the Application version and the UPD level currently you are in? In Apps 10, this issue has been resolved via the Solution ID 273604 (Related Bug ID: 149341) delivered via UPD6. Cheers! Hello @Imal Thiunuwan Thanks for replying.It is IFS Applications 10,Do you have any resolved link? Thanks,Narsi.
@william.klotz Thanks for replying.I’m using IFS Application 10.I can also see the CORRECTION_REASON_ID, NET_CURR_AMOUNT, and ROWSTATE with CustomerOrderInvHead(LU) and INVOICE_TAB. I’m happy now I can use it. Thanks,Narsi.
@tobese thanks for replying I have checked, there is a public get method for Status, and no method for NET_AMOUNT, trying to get that Colum using CURSOR in Event Action ThanksNarsi.
@anmise I can not see Quick Information Sources in the Lobby Data SorceI can see only standard Information Sources Do you know why Quick Information Sorces are not available?
Hi @ADNAN It’s related to the lobby pagehttps://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/lobby-page-filter-parameter-4395 Could you please reply there?Thanks,Narsi.
@Rusiru Query:select s.EMPLOYEE_ID, COMPANY_EMP_API.Get_Name(s.company,s.EMPLOYEE_ID) AS Name,s.DURATION*60 AS "Actual(Minutes)", CASE WHEN (SELECT SUM(DURATION) FROM SHOP_FLOOR_CLOCKINGS_UIV WHERE ORDER_NO = s.ORDER_NO AND RELEASE_NO = s.RELEASE_NO AND SEQUENCE_NO = s.SEQUENCE_NO AND OPERATION_NO = s.OPERATION_NO) = 0 THEN 0 ELSE ROUND((s.DURATION/(SELECT SUM(DURATION) FROM SHOP_FLOOR_CLOCKINGS_UIV WHERE ORDER_NO = s.ORDER_NO AND RELEASE_NO = s.RELEASE_NO AND SEQUENCE_NO = s.SEQUENCE_NO AND OPERATION_NO = s.OPERATION_NO))*o.PLAN_LABOR_RUN_TIME*60, 0)END AS "Expected(Munites)",CASE WHEN (SELECT SUM(DURATION) FROM SHOP_FLOOR_CLOCKINGS_UIV WHERE ORDER_NO = s.ORDER_NO AND RELEASE_NO = s.RELEASE_NO AND SEQUENCE_NO = s.SEQUENCE_NO AND OPERATION_NO = s.OPERATION_NO) = 0 THEN 0.00WHEN o.PLAN_QTY = 0 then 0.00 ELSE ROUND((o.REPORTED_QTY/o.PLAN_QTY)*(o.PLAN_LABOR_RUN_TIME/(SELECT SUM(DURATION) FROM SHOP_FLOOR_CLOCKINGS_UIV WHERE ORDER_NO = s.ORDER_NO AND RELEASE_NO
@paul.phillips I have FND_ADMIN permission setAlso, have access to impersonate a user But I cann’t see “Set as active in current session” option
Hi @JurWhere can I run this? Thanks,Narsi.
thank you all
Hi @NickPorter,It works where '&MANAGER' is empty but doesn’t work where '&MANAGER' is not empty getting result as empty records + MANAGER2 records when '&MANAGER' is MANAGER2Thanks,Narsi.
Please check this conversation https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/lobby-link-to-excel-quick-report-1541?postid=12353#post12353Thanks,Narsi.
Hi @ADNAN It works now I added a space between ifsrep: and qr.448404, that’s why it didn’t work.Now it’s working with ifsrep:qr.448404 (without space)Thanks,Narsi
Hi @ADNAN ,I have written as ifsrep: qr.448404 Checked report ID but no luck still getting same screen Thanks,Narsi.
Hi @ADNAN Quick Report SQL:select PART_NO,CONTRACT,WAREHOUSE,LOCATION_NO,Inventory_Location_API.Get_Location_Name(CONTRACT, LOCATION_NO) as "Location Name",INVENTORY_PART_API.Get_Description(contract,part_no) as "Part Description",CONFIGURATION_ID,LOT_BATCH_NO,SERIAL_NO,CONDITION_CODE_MANAGER_API.Get_Condition_Code (PART_NO,SERIAL_NO,LOT_BATCH_NO ) as "Condition",Condition_Code_API.Get_Description(CONDITION_CODE_MANAGER_API.Get_Condition_Code (PART_NO,SERIAL_NO,LOT_BATCH_NO )) as "Condition Description",ENG_CHG_LEVEL,Inventory_Part_API.Get_Unit_Meas(CONTRACT, PART_NO) as UoMfrom INVENTORY_PART_IN_STOCK_UIVwhere CONTRACT = ‘101’ and PART_NO = &PART_NO Lobby Element Screen:Lobby Data Source:Thanks,Narsi.
Hi @ADNAN I’ve tried with this link ifsrep: qr.79991 to get quick report form lobbybut no luck getting this screen when pressing a column on lobby Could you please help? Thanks,Narsi.
thanks @Rusiru I’m able to download now. Thanks,Narsi.
Hi @paul harland It tried where current_step_no = step_no on new records, it doesn’t work because current_step_no becomes blank on new records.then I tried on objects are changed And put if statment as if '&OLD:CURRENT_STEP_NO' = '' and '&NEW:CURRENT_STEP_NO' = '&NEW:STEP_NO' thenin Event Action. It works now.Thank you. Thanks,Narsi.
Hi @Jur @Rusiru @anmise Is it possible to default/pre-populate values on the date parameter fields when we press “View Report”?I mean date paramer fields would be populated automatically when we press “View Report”“Date From” would be the first day of last week and “Date To” would be today’s date.For example:Today’s Date: 17-08-2020From Date: 10-08-2020To Date: 17-08-2020 Thanks,Narsi.
Hi @paul harland @ShawnBerk I’m using LU: InvetoryPart, a user adds an Approval Template manually in the Approval Process block against an Inventory Part.So I have created an event action on event STEP_READY_FOR_APPROVAL to get an email alert for the next approver. It works from when the first step has been approved(Next Approver is getting an email alert)For Example,Let’s assume there are three steps against an Inventory PartWhen we add an Approval TemplateStep 1(Not approved yet, approvers need to get an email alert to approve to this step, but not getting) - Here I need to make an email alert for approvers approve this stepStep 2(Waiting for Step 1) Step 3(Waiting for Step 2)When approved the first stepStep 1(Approved )Step 2(approvers are getting an email alert) Step 3(Waiting for Step 2)When approved the second stepStep 1(Approved )Step 2(Approved) Step 3(approvers are getting an email alert) I think it makes sense Thanks,Narsi.
Thanks @Jur
Thank you so much @Rusiru and @anmise
Hi @Rusiru It works now Is it possible to add comments by default when we press View Report?I want to provide date format information.Thanks,Narsi.
Hi @dsjThanks for providing this,It doesn’t make sense that the difference between APPROVAL_ROUTE_REJECTED and STEP_REJECTED_NODOCCould you please elaborate? Thanks,Narsi.
@dsj thanksI can see that now.
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.
