Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hello @Sean W, Per SuiteAnswers 35631, Reorder Point is the counterpart of 'Build Point' for Assembly Items. You mentioned that you already have an existing search. If it works for your other items, then I think you can just make some modifications to include the WO instead of the PO. If you need help modifying your…

Hi @Benjamin Paul - USA, Did the given response above help resolve your concern? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and…

Hi @Benjamin Paul - USA, Did the given response above help resolve your concern? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and…

Hi @Rhys Gottwald, Did the given response above help resolve your concern? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and you…

Hi @Benjamin Paul - USA, Did the given response above help resolve your concern? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and…

Hi Oliver, Kindly try this formula and check if it works: CASE WHEN TRUNC({today}) - (LEAST(NVL({custitem_rlrs},TO_DATE('01/01/2099','dd/mm/yyyy')),NVL({custitem_blrs},TO_DATE('01/01/2099','dd/mm/yyyy')),NVL({custitem_tlrs},TO_DATE('01/01/2099','dd/mm/yyyy')))) > 60 THEN 'T' ELSE 'F' END You can change the hardcoded date…

Hi @OliverK, I checked the formula on my end (via a saved search) and encountered the same behavior. Per further checking on what might be the cause of this, I noted that in your formula, you are converting the date fields into a string/text by using the "TO_CHAR" function. And since it is already a text, then the LEAST…

Hi @User_75YL8, Glad to have you back with us and thanks for posting your question here in our community! Our gurus will be checking on this and will get back to you. @Michelle Jabanes-Oracle, any ideas? To our other members, feel free to share your insights as well.

Hi @User_NG9BL, Glad to have you back with us and thanks for posting your question here in our community! Our gurus will be checking on this and will get back to you. @Michelle Jabanes-Oracle, any ideas? To our other members, feel free to share your insights as well.

Hola: Consulte SuiteAnswers 87427: Reglas del sistema para NetSuite WMS. Según este artículo, este es el comportamiento de la regla del sistema "Permitir ubicación temporal solo para el selector asignado": Si se define en Sí: permite que solo el preparador de órdenes asignado a una tarea de selección ubique temporalmente…

Hello @Benjamin Paul - USA, For OneWorld accounts in general, the currency used on value fields on item records such as Total Value, Average Costs and Last Purchase Price is the Base Currency of the Root Parent subsidiary and is converted using consolidated exchange rates. On the other hand, if the account uses MLI,…

Hola @User_7JDS3, Según lo que entendemos, desea saber si hay una manera de asignar automáticamente preparadores de órdenes a tareas de selección. He revisado mis recursos en este campo y he observado que actualmente no forma parte de la funcionalidad nativa de Oracle NetSuite WMS porque es necesario seleccionar…

Hello @Rhys Gottwald, You can check SuiteAnswers 99470: Defining Autogenerated ID Formats for instructions on how to define a format for cartons. Note however, that you can use an order number as the prefix for carton IDs, but there is no mention of using Pick Cartons for this yet. Also, we do have a System Rules for…

Hope my previous comment clarified your concern. Let us know if you need further help on this one.

HI @Benjamin Paul - USA, As mentioned in your previous thread with the same topic, the cost of the Kit/Package depends on the cost of its components since Kit/Package item inventory is not tracked by the kit, it is tracked by individual component members. To check the cost of the Kit/Package item, you can refer to the…

Hi Adam, Thanks for sharing that DISTINCT works with NS_CONCAT. However, note that as per SA 18392: The NS_CONCAT function is not officially supported by NetSuite. Furthermore, result values for formula fields containing the NS_CONCAT function are limited to 4000 characters. Use this function at your own discretion. It's…

Hola @User_7JDS3, Estamos encantados de tenerle con nosotros hoy. Gracias por crear este hilo. Por favor, permita que nuestros gurús revisen su preocupación y realicen su investigación inicial. Nos pondremos en contacto de nuevo si tenemos novedades al respecto. Para nuestros otros miembros, siéntanse libres de compartir…

Hi @Benjamin Paul - USA, If grouping is not possible, then you would have to add the other Link Type that shows up in the Criteria. In this example, I have exposed the Applying Link Type field in the Results tab of the search: Notice that there is Drop Shipment for this order, and also Order Bill/Invoice and Revenue…

Hi @Benjamin Paul - USA, Thanks for providing the screenshots in English. Per further checking, I noticed that you are using Type = Sales Order on your criteria. In that case, then Applying Link Type should be the field to be used. In my example previously, I used Type = Purchase Order which is why I used Applied To Link…

Hi there @Mathias_Netsuite, This is possible by adding a filter in the Purchase Order form. Here's how to do it: Step 1: Create an Item Saved Search Go to Lists > Search > Saved Searches > New Select Item Under the Criteria tab, add a Formula (Numeric) field with this formula: CASE WHEN {departmentnohierarchy} =…

Hi Paul, MRP/MPS uses the Work Calendar in NetSuite and the lead time in the Item Records. Finite Scheduling is based on the AM Work Bench and the AM Work Center. If you run MRP to generate Work Orders from a Sales Order demand, there will be 2 Production Start/End Date for it. One in the Default View (which uses the core…

Hi there @Martha Hakes, Hope you're doing good today! Welcome back to the community and thanks for posting your question here. 😊 Allow our gurus to check and test this one, and we'll get back to you with our findings. @Patrick Fresnosa-Oracle / @Clarisa De Torres-Oracle, any ideas? To our other members, feel free to share…

Hey there @Adam Birk, I checked this one and it seems that "Distinct" function is not yet supported in search formulas. For a list of the supported SQL Expressions, refer to SuiteAnswers 10101. We do have an existing enhancement related to this: Enhancement # 166265: Saved Searches > Request the ability to use the SELECT…

Currently it's not possible since there is no "Select All" button when on the Add Multiple window. There's an existing enhancement # 232936 logged for this, and you can vote for it in the SuiteIdeas page. The alternative is what I provided in my previous comment which is to use "contains" in your filter. I'm not sure what…

Maybe you can try using "contains" when setting your filter? Then add the keywords that you need.

Hi @User_OTL18, Can you share what specific report you are working on and what field you are using as the filter? This is so we can further check and test on our end. Screenshots would also be appreciated, but make sure to hide any sensitive information.

Hi there @User_4HDGW, Glad to have you with us today and thanks for posting your concern here in our community! @Dominica Sevilla-Oracle / @Elychelle Gulen-Oracle / @Katerina Winklerova-Oracle, any thoughts you can share? To our other members, feel free to comment your insights as well.

Hi there @User_USRCP, Thanks for posting your question in our community! Tagging our guru who can help you out on this: @Michelle Jabanes-Oracle, any ideas that come to mind? To our other members, feel free to share your thoughts as well.

Hi there @Emzo Alama-Oracle, Glad to have you back with us today and thanks for posting your concern here in our community! Our gurus will be checking this one: @Patrick Fresnosa-Oracle / @Clarisa De Torres-Oracle, need your expertise here. 😊 To our other members, feel free to share your insights as well.

Hi there @Pallavi1903, Welcome back to the community and thanks for posting your concern here! I have coordinated this internally and our guru @Patrick Fresnosa-Oracle will be helping you out on this one. To our other members, feel free to share your insights on this as well.