Ivy Lopez-Oracle · SCM Guru · Red Diamond

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.

Hi @Sivasubramaniam, Welcome back and thanks for posting your concern here in our community! As initial troubleshooting, kindly check if you are using the Standard Form or a Custom Form as the preferred form for the Employee record when using that Accountant role. If you are using a custom form, then you can check if the…

Let us know if you have further questions on this.

Hi @Benjamin Paul - USA, There's actually 2 "Link Type" fields that look alike. One is called "Applied To Link Type" and the other is "Applying Link Type". The correct one to use is the "Applied To Link Type". I am unable to tell which you are using since I can't read Japanese. Since the name of the fields are very…

Hi @Jeff_BlueMemento, Glad to have you with us today and thanks for posting your concern here in the community! @Richard James Uri-Oracle / @Nicole Mendoza-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Leonard Mallare-Oracle / @Kristoffer Viray-Oracle, any ideas that can help? To our other members, feel…

Hi there @Christopher Williams, Thanks for posting your concern in our community! Hope you're doing good today. Our gurus will check this for you and will revert with their findings, To our other members, feel free to comment your insights on this as well!

Hi @KNason76, According to SuiteAnswers 27937: BOM costs using Standard Costing are based on the effective date shown on the planned standard cost rollup record. Also note that the standard behavior when using Standard Costing is that there can be only one inventory revaluation for an item per day for each location. Hope…

Hi @User_DATN1, The Support tab is located here: If you're having issues accessing SuiteIdeas, you may want to refer to this other thread: Or you can submit a new question here in our community so it can be addressed accordingly. Meanwhile, we'll keep this thread open in case other members have suggestions or insights they…

Hi @Nickey, Glad to have you with us and thanks for posting your question here in our community! Have you tried using the "Memo" field in the results of your saved search? Let us know if this works for you.

Hi @User_V0JSJ, Glad to have you with us today and thanks for posting your question here in our community. @Dominica Sevilla-Oracle / @Elychelle Gulen-Oracle / @Katerina Winklerova-Oracle, any ideas that come to mind? To our other members, feel free to share your insights about this as well.

Hi @Rick Cobb_2, Glad to have you back with us today and thanks for posting your concern here in our community! Let me tag our gurus who may be able to help you out on this: @Patrick Fresnosa-Oracle / @Clarisa De Torres-Oracle, need your expertise on this one. 😊 To our other members, feel free to share your insights as…

Hi @Benjamin Paul - USA, Our gurus will be checking this one and will get back to you with findings or if more information is needed. To our other members, feel free to comment your thoughts on this as well.

Hi there @Benjamin Paul - USA, We also have a discussion posted about this: Anyway, I'm tagging @Dominica Sevilla-Oracle / @Elychelle Gulen-Oracle /@Katerina Winklerova-Oracle if they have anything to add. To our other members who also use this bundle, let us know your thoughts as well.

Hello @User_FL4CK, Glad to have you with us today and thanks for posting your question here. @Dominica Sevilla-Oracle / @Elychelle Gulen-Oracle / @Katerina Winklerova-Oracle, any ideas that can help? To our other members, feel free to comment your insights as well.

Hello @Benjamin Paul - USA, Thanks for posting another question here in our community! Tagging our experts who can assist you on this one: @Patrick Fresnosa-Oracle / @Clarisa De Torres-Oracle / @Micah Timbol-Oracle, any ideas that can help? To our other members, let us know your thoughts as well by commenting on this…