Unfortunately I don’t don’t neither have clear answer for you, but some more variables to consider. Delivery term; are goods sold on your premises or delivered to customer Partial deliveries; how those should be counted I assume there is no standard wayt to handle this, depends on company and business where they are. But if you can define rules how to calculate, that is most probably possible to implement to IFS with custom fields, LU’s and events. -Jouni-
If you go to your report rule and condition RMB edit expression 1You can see that there is no Company on report xml data. So your condition won’t ever match.You need to use site or make select or use api function to get company based on site at expression1 field
Just confirmation, have you tried to use @CUSTOMER_ORDER_CONF_REP\CONTRACT
,nvl(prior qty_per_assembly, 1) * qty_per_assembly quant --this will return qty from whole stucture ,SYS_CONNECT_BY_PATH(part_no, ' / ') "Path",SYS_CONNECT_BY_PATH(qty_per_assembly, '*') "qty"
I don’t have answer, but related questionI got task relating datamatrix yesterday from customer and just make first test, but seems that datamatrix not return value it have. Instead it returns www.ifsworld.com as your code above. Did you get Datamatrix give output something else www.ifsworld.com? I haven’t yet possibility to test real print out, but at least report designer not show real data.
Our need didn’t realize, so I never tried this. So unfortunately I don’t have knowledge
@Nimesh Kasun If you press date on line, you get card what you used, if you press operation you get card what is have.I lack knowledge, what are the step to get field visible there, when you add content to card.Which LU to add field in EE and what need to do in Aurena side?
I have this kind of solution, what will create csv file so that there is line breaksEvent what will create messageDECLARE pick_list_no_ VARCHAR2(300) := '&NEW:PICK_LIST_NO'; l_refcursor SYS_REFCURSOR; l_xmltype XMLTYPE; bxml_ CLOB; BEGIN OPEN l_refcursor FOR select '2' ||';' || pick_list_no || ';' || Source_ref2 || ';' || Source_ref3 || ';' || Source_ref4 || ';' || part_no || ';' || -(qty_reserved - qty_picked)|| ';' || Fnd_Session_API.Get_Fnd_User || ';' || to_char(SYSDATE, 'DD.MM.YYYY') || ';' || to_char(SYSDATE, 'HH24:MI:SS') || ';' || contract as "C00"from PICK_SHIPMENT_RES_STOCK_UIV WHERE location_no = '3' and pick_list_no= pick_list_no_; l_xmltype := XMLTYPE(l_refcursor); bxml_ :=l_xmltype.getStringVal();plsql_rest_sender_api.Call_rest_Endpoint(rest_service_ => 'SEND_TO_KARDEX',xml_ => bxml_,http_method_ => 'POST',http_req_headers_ => 'Content-Type:application/xml',message_type_ => 'KARDEX')
Just FYI, we have now wait UPD 3,5 month (G2348029)
Just FYIWe have now wait UPD 6 months, we had even project go live last week. We haven’t got any ETA even asked few times.
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.