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 @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 @paguin Please check here.
Hi @paguin Sorry about that. Here is the list for APP10 as of April 2022.
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 @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 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 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 @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 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 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.
Thanks Chanaka. Yes I want to know whether we are supporting this functionality or not.
Not yet Franck
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.
Thanks Sandun for the clarification
Already have an account? Login
No account yet? Create an account
Enter your 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.