Thanks Sandun for the clarification
I’ll update the post if I get anything. Seems there is a high demand for this. Another person reached out to me asking whether I got a solution.
Not yet Franck
Thanks Chanaka. Yes I want to know whether we are supporting this functionality or not.
Hi Gonzalo,Thank you very much for the link.However this example is not for passing a dynamic value. I’m looking for that scenario. Anyway thanks again for your input.
Hi @geminirajesh Extremely sorry for the delay.You may use the view ORDER_SUPPLY_DEMAND_EXT to get the Shop Order.SELECT order_no from ORDER_SUPPLY_DEMAND_EXTWHERE Order_Supply_Demand_Type_API.Encode(order_supply_demand_type) = '5'AND part_no = <Part No in CO line>Additionally you may need to give another condition like Due Date (date_required in ORDER_SUPPLY_DEMAND_EXT) which should be equal to the Planned Due Date of CO line. Or else you need to add other conditions as per your requirement to fetch the correct Shop Order.If the query fulfills your requirement, you can use it in a custom field.
Hi @geminirajesh Can you please provide some screen pictures showing the connection between CO line and SO? How do you filter the correct SO from IPAP screen? These will be helpful in finding a solution.
Hi @geminirajesh Try the steps suggested by @Hans Andersen above. There is no connection to the project or DOP. The Shop Order and Customer Order connection is stored in CUSTOMER_ORDER_SHOP_ORDER_TAB.
Hi Randini, I tried the below SQL query and got that invalid identifier error select ifsapp.Customer_Order_Line_API.Get_Shop_Order_Info('N22-0225','1','1','0') from dual Any idea how to use that API call ? Hi @geminirajesh These 2 methods are not functions which return a single value (actually these are procedures), hence you can’t use them inside a SELECT statement. I can see you are using PLSQL Developer, so you can follow these steps to test these procedures.STEP 1: Right Mouse Button on the method name → TestSTEP 2: Enter Customer Order Line details and press Execute buttonIf using the other methodHope above steps are clear.However if you want to show the SO details in Customer Order Lines screen, you can introduce a custom field as suggested in the above comments.
Hi @geminirajesh You may use below methods.Customer_Order_Shop_Order_API.Get_Shop_Order()Customer_Order_Line_API.Get_Shop_Order_Info()Above methods return Shop Order No, Release No, Sequence No as OUT parameters.
Hi @ThushAsanka Communication methods have been redesigned in later APP7 and during APP75 SP4 by moving data into COMM_METHOD_TAB from various tables including PERSON_INFO_COMM_METHOD_TAB. But the PERSON_INFO_COMM_METHOD_TAB was kept in APP8 as well (seems only with old data) and then permanently removed in APP9.Hope this helps.
Hi @paguin Sorry about that. Here is the list for APP10 as of April 2022.
Hi @paguin Please check here.
Hi @rcruz Return Material Authorization Lines window itself is Read Only. That’s why you cannot update the custom check box you added.Try it in Sales\Returns\Return Material Authorization → [Return Material Lines] tab.
Hi @crysalis010 You cannot define permission by field/column level. Alternatively a custom event can be introduced to trigger an error when updating the Target Date by a person not permitted to do so. Refer below posts.
Hi @cjohnson Is this the configuration setup you are using? Path: Manufacturing Standards → ProdStructure → MANUF_STRUCTURE_TABThis worked for me.
Hi @Alexis.S You may use a drop down list (combo box) instead of a LOV if that is more convenient.Data Type: EnumerationFormat: Normal
Hi @NRTDENISEL Sorry for the delay in replying.The override comes into play with below option hence should not have an impact to the visibility in Order Report dialog.With this option application decides which report to be displayed - CUST_STMT_ACCT_REP or CUST_CONF_STMT_ACCT_REP.However just go through the steps below.Check whether Report Definitions exist for both CUST_STMT_ACCT_REP and CUST_CONF_STMT_ACCT_REP. Check permissions of both CUST_STMT_ACCT_REP and CUST_CONF_STMT_ACCT_REP and grant if necessary. Refresh report cache and security cache then log off and log on again to the application.
Hi @Chaminda Are you using GET extension?Check whether below entry is available in PURCH deploy.ini?Fisnot=DYNAMIC
Hi @NRTDENISEL May I know the report name please?
Hi @NRTDENISEL Was this report showing in Order Reports earlier?Is it available in Report Definition screen (means Schema and Layout imported)?
Hi @NRTDENISEL Please check the value defined for the show_in_order_reports_ parameter in the report RDF file. It must be defined inside the method call Report_SYS.Define_Report_() and the value must be set toTRUE.
Hi @Ozge These might be helpful.
Hi @Link In your example you need to give access to below methods. Or else try below presentation objects as well. You can grant access to the processes you need.
Hi @Link Please check whether below post is helpful.
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.
