Ivy Lopez-Oracle

Hello @Sheene Lim-Oracle, Let us know if further assistance is needed with this. If none, we would greatly appreciate it if you can 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 Accepter badge.

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 16, 2023 10:18PM

Hi @Owen Ramirez Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle & @Clarisa De Torres-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back to you. In the meantime, if any…

in Is there a way to identify B2C and B2B customers for OSS Scheme in Suitetax? Comment by Ivy Lopez-Oracle Mar 16, 2023 3:39PM

Hi @Nickoletta Gounaris, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Katerina Winklerova-Oracle & @Micah Timbol-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back to you. In the meantime,…

in How to map custom field when importing new Journal Entries through CSV? Comment by Ivy Lopez-Oracle Mar 16, 2023 3:38PM

Hi @Katelyn M Martin, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle, @Elychelle Gulen-Oracle & @Katerina Winklerova-Oracle to take a look at your question and provide you with the best possible solution. Please allow them some time to investigate and get back…

in How to implement Inline Purchase Order Approval Functionality in a Saved Search? Comment by Ivy Lopez-Oracle Mar 16, 2023 2:56PM

Hi Sean, Let us know if you need further assistance with this.

in How to create a Saved Search that shows assemblies that are below build point? Comment by Ivy Lopez-Oracle Mar 15, 2023 10:19PM

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…

in How to Edit a transaction line description? Comment by Ivy Lopez-Oracle Mar 15, 2023 10:18PM

Hi @User_C6XDE, 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 the…

in What Permissions are needed for a Custom Role to Access WMS Mobile App (bundle# 445891)? Comment by Ivy Lopez-Oracle Mar 15, 2023 10:17PM

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…

in Why are we unable to configure Inventory Detail when fulfilling Sales Order? Comment by Ivy Lopez-Oracle Mar 15, 2023 10:13PM

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…

in How to create a Saved Search to show the First Time a new Item has been Received? Comment by Ivy Lopez-Oracle Mar 15, 2023 8:04PM

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…

in How to Auto-populate the Rate field oo a Sales Order with the Average Cost of an Item? Comment by Ivy Lopez-Oracle Mar 15, 2023 5:11PM

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…

in Is it possible to add a Subcategory under a Center Category? Comment by Ivy Lopez-Oracle Mar 15, 2023 3:43PM

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…

in Is there a way to display the GL Account for an Invoice in the same column as a Journal? Comment by Ivy Lopez-Oracle Mar 15, 2023 3:20PM

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…

in Any suggestions on NetSuite clean-ups? Comment by Ivy Lopez-Oracle Mar 15, 2023 3:17PM

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…

in How to create Workflow for Sales Orders Converted From Quotes Comment by Ivy Lopez-Oracle Mar 15, 2023 2:35PM

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.

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 15, 2023 1:45AM

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…

in Why is there Quantity On Order in the Item Record but no open POs or WOs? Comment by Ivy Lopez-Oracle Mar 14, 2023 11:44PM

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…

in What is the Formula to get a substring from text box field? Comment by Ivy Lopez-Oracle Mar 14, 2023 8:10PM

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…

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 14, 2023 8:10PM

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.

in How to Edit a transaction line description? Comment by Ivy Lopez-Oracle Mar 14, 2023 8:04PM

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.…

in How to create a Saved Search that shows assemblies that are below build point? Comment by Ivy Lopez-Oracle Mar 14, 2023 7:14PM

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!

in What Permissions are needed for a Custom Role to Access WMS Mobile App (bundle# 445891)? Comment by Ivy Lopez-Oracle Mar 14, 2023 7:06PM

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…

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 13, 2023 4:40PM

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

in What is the Formula to get a substring from text box field? Comment by Ivy Lopez-Oracle Mar 13, 2023 3:35PM

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…

in What is the Formula to get a substring from text box field? Comment by Ivy Lopez-Oracle Mar 13, 2023 3:28PM

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…

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 13, 2023 3:17PM

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

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 13, 2023 2:51PM

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…

in How to Use Expressions in Saved Search to exclude specific criteria? Comment by Ivy Lopez-Oracle Mar 13, 2023 2:48PM

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…

in What is the Saved Search Formula for Most Recent Value? Comment by Ivy Lopez-Oracle Mar 10, 2023 11:01PM

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…

in How to display the non-zero number of Back Ordered in Sales Order in a saved search? Comment by Ivy Lopez-Oracle Mar 10, 2023 10:59PM

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…

in How to create report connecting 2 data sources Employees & Service item? Comment by Ivy Lopez-Oracle Mar 10, 2023 10:57PM

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments