Ivy Lopez-Oracle NSC Guru

Hi @dylanvv, Have you tried the suggested solution in SuiteAnswers 68721? There is also a note there that says: Please contact NetSuite Support for further assistance as the behavior encountered is a possible issue. It seems that this is something specific happening on your account as I can't reproduce the behavior in my…

Hi there @Dallas H, Good to see you here again! I tried to modify the search provided in SuiteAnswers 37932 and here's what I came up with: I also tested out @JohnCirocco's solution and I noted that you can add another column in the search results to show how many Item Receipts there are for the item: If you want to show…

Hi @Sharon Hirsc, I checked this on my end and it seems that what you're looking for is currently not possible without using customizations. Note that the price level in Sales Orders is considered is based on this hierarchy: If Customer Name is already indicated, the Default Price will be based on the Price Level set on…

Hi @Asher_123, We're glad you posted your question in the NetSuite Support Community. It's great to see our members actively engaging and seeking assistance. We have notified our experts @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle & @Kristoffer Viray-Oracle about your question and they will be checking in soon. In…

Hi @Steven O, Thank you for posting your question in the NetSuite Support Community. We appreciate your participation and are here to help. Our gurus @Elychelle Gulen-Oracle, @Katerina Winklerova-Oracle & @Dominica Sevilla-Oracle will be checking your question and they'll get back to you as soon as possible. In the…

Hi @HU06, Welcome to the NetSuite Support Community! We're thrilled to see new members like you joining our community and reaching out for help. Thank you for posting your question. Our community gurus are here to provide you with the assistance you need. Let me tag our expert on this topic, @Michelle Jabanes-Oracle, and…

Hi @brocha, We're glad you posted your question in the NetSuite Support Community. It's great to see our members actively engaging and seeking assistance. Let me tag our gurus to take a look at your question and provide you with the best possible solution. Please allow us some time to investigate and get back to you. @Jack…

The search results will pull all items that match the Criteria that you set. If you can share examples/screenshots of items that match the criteria and you expect to see in the search results but is not included, then maybe we can further troubleshoot.

Hi @Nickey, It's possible that the quantity on order issue is specific to your account if there are no open orders for the item. We have a tool in place that runs periodically to address common data problems with inventory quantities on item records. However, the frequency of the tool's run depends on the account and might…

Hi @KR Mike, Just wanted to check in if you were able to see the possible solution provided in my previous comment. If it was helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll earn points and unlock the Answer…

Hi @Sheene Lim-Oracle, Just wanted to check in if you were able to see the possible solution provided in my previous comments. If it was helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll earn points and unlock…

Hi @Varonis inc., Are you referring to the Line ID in CSV Import Mapping? For Invoice type, you can try Order Line instead. Hope this helps.

Can you elaborate on "If I do a Status: Work Order Released for the critieria, and use {quantity} in the formula, the results are only of anything on a work order, which is not real useful."? If you want to get only the quantity of the Assembly item to be built, then you need to add Main Line = True as a Criteria as well.…

Hi @User_C6XDE, Thank you for posting your question in the NetSuite Support Community. You can check the following SuiteAnswers articles about WMS Roles and Permissions: Warehouse Management Roles Warehouse Management Permissions Assigning Custom Roles to Custom Mobile Processes Hope this helps!

You can play around with using AND/OR until you get your desired results. Based on the criteria I provided, the results are expected to show the ff: AND - Items wherein BOTH the Season is not Discontinued Products AND the Location Qty On Hand + Location Qty On Order is greater than 0 OR - Items wherein EITHER the Season is…

Hi @KR Mike, Try this in Formula(Text): REGEXP_SUBSTR({custitem41}, '<ShippedBy>.*')

Hi @KR Mike, We're glad you posted your question in the NetSuite Support Community. It's great to see our members actively engaging and seeking assistance. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if you have any other questions or concerns, feel free to…

Hi @Sheene Lim-Oracle, You can use this in your Criteria: Depending on your need, you can select AND instead of OR. Note that the correct use of Not, Parenthesis, and AND/OR is critical when defining the logic of your expressions. AND means that all of the criteria that you have should be true while using OR (when placed…

Also, what is the correct logic of what you want to exclude? A. Season - "Discontinued Products" OR "Location on hand" + "Location on Order" = 0 B. Season - "Discontinued Products" AND "Location on hand" + "Location on Order" = 0

Hi @Sheene Lim-Oracle, Thank you for posting your question in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, can you clarify please if what you are trying to exclude is a transaction or an item? Since you are doing an Item…

Hi @NoshinYZNetSuite-Oracle, I hope you're doing well! I just wanted to check in and see if you had a chance to look at the possible solution I provided in my previous comment. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?". It's a quick and easy way to let us know that the…

Hi @Benjamin Paul - USA, I hope you're doing well! I just wanted to check in and see if you had a chance to look at the possible solution I provided in my previous comment. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?". It's a quick and easy way to let us know that the solution…

Hi @User_E1GW7, I hope you're doing well! I just wanted to check in and see if you had a chance to look at my previous comment. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?". It's a quick and easy way to let us know that the solution worked for you. Plus, it helps others with…

Hi @Varonis inc., I hope you're doing well! I just wanted to check in and see if you had a chance to look at the possible solution I provided in my previous comment. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?". It's a quick and easy way to let us know that the solution worked…

Hi tech work, Kindly provide the requested information so we can proceed with investigating this. Thanks!

I agree with @Edwards_05. You can set up different addresses per Location. However, on a company level, you can only have one. I did find a Enhancement # 103600 related to this. You can vote for this enhancement request in the SuiteIdeas page.

Hi @PaulFleetwood, Glad to have you with us today and thanks for posting your question here in our community! @Michelle Jabanes-Oracle, need your expertise on this one. To our other members, feel free to share your thoughts as well.

Hello @User_R0L8N, We do have NetSuite WMS, but this is also limited to warehouse management only, and doesn't cover scanning items for over the counter sales. There is NSPOS available for your POS needs. You can check SuiteAnswers 76380 for an overview, or reach out to your account manager for more information about this.

Thanks for your insights @Christopher Williams! --- Hi @NoshinYZNetSuite-Oracle, I agree with Christopher that the initial formula you provided is picking up both of those dates and giving you the maximum value. Since your search results are grouped (I assume by Item), then it is still getting the values of all the…

Hi @Benjamin Paul - USA, If you want to add it to your Criteria, you can use a Formula (Numeric) field, and set it to "not empty". Here's screenshot of what it should look like: