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:

Hi @User_FL4CK, Can you clarify what you mean by "Ship To Address" please? Is it the Address in the Customer record, in the Location record, or in the Company Information (Setup > Company > Company Information)?

Hi @Dolev, Welcome to the community! We're glad to have you here with us today, and thanks for posting your question here. Allow our gurus to check this one and we'll get back to you with more info. @Micah Timbol-Oracle / @Katerina Winklerova-Oracle, need your expertise on this one. To our other members, feel free to share…

Hi @User_XMFHV, We're glad to have you here with us today, and thanks for posting your question here. Allow our gurus to check this one and we'll get back to you with more info. @Micah Timbol-Oracle / @Katerina Winklerova-Oracle, need your expertise on this one. To our other members, feel free to share your insights as…

Hi @nir.levy, Thank you for creating this thread! 😊 Our gurus/members will look into your concern and get back with more information. To everyone, feel free to share your insights! 😊

Hello @Pallavi1903, We're glad to have you here with us today, and thanks for posting your question here. Allow our gurus to check this one and we'll get back to you with more info. @Patrick Fresnosa-Oracle / @Clarisa De Torres-Oracle, need your expertise on this one. To our other members, feel free to share your insights…

Hi there @Andrii Siryi, We're glad to have you here with us today, and thanks for posting your question here. Allow our gurus to check this one and we'll get back to you with more info. @Richard James Uri-Oracle / @Nicole Mendoza-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, can you take a look at this…

Hi @Febin Antony, Glad to have you here with us today, and thanks for posting your question here. Allow our gurus to check this one and we'll get back to you with more info. @Dominica Sevilla-Oracle / @Elychelle Gulen-Oracle / @Katerina Winklerova-Oracle, any insights? To our other members, feel free to share your thoughts…

Hi @ColinGreener, Welcome to the community! We're glad to have you here with us today, and thanks for posting your question here. Allow our gurus to check this one and we'll get back to you with more info. @Patrick Fresnosa-Oracle / @Clarisa De Torres-Oracle, any ideas you can share? To our other members, feel free to…

Hello @Benjamin Paul - USA, Have you tried the solution provided in my previous comment? Let us know if you need further assistance with this.

The last screenshot you sent is the Components list in the Item Record. Can you send the screenshot of the Components tab in the Work Order Completion? Here's a sample: Are there multiple Work Order Completions for that Work Order? What is the set under Setup > Manufacturing > Manufacturing Preferences > Production Costing…

Hi @User_E1GW7, As documented in SuiteAnswers 104215: To link datasets in a workbook, you must first connect at least two datasets to a workbook and define at least one set of common keys between each dataset. Common keys are fields that contain the same data within each dataset, in the same data type. For example, the…

Hi @User_I763M, Welcome to the community! Glad to have you with us today and thanks for posting your question here. Our gurus will be checking this one and will be responding to this thread for findings, or if more details are needed. @Richard James Uri-Oracle / @Nicole Mendoza-Oracle / @Jack Daryl Espiel-Oracle / @Joahnna…

Hi there @Varonis inc., Glad to have you back with us today and thanks for posting your concern here in our community! I was actually able to test this on my account just now and here are my findings: For your saved search concern, the Description field in the transaction line is called "Memo" It's standard behavior that…

Hello @CRATIV_Jason, Just checking in if you were able to check the article provided in my previous comment. If it was helpful to your concern, we'd greatly appreciate if you can click "Yes" on "Did this answer the question?" in my previous comment. This will aid the others with the same question to easily find the correct…

Hi @alexmccullough, I would like to follow up on this thread. Please let us know if you need further assistance. If there's none, kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. You will…

Hi @davidd039, Were you able to test my previous comment? Let us know if you need further assistance with this.

Howdy @Tiffany Haslerud, You can try this Transaction Saved Search: Formula used: CASE WHEN {billaddress} = {shipaddress} THEN 1 ELSE 0 END You can add/remove columns that you want to see in the Results . --- As for sending an email alert: Select whether you want an alert to be sent every time a record that meets the…

Hi @Benjamin Paul - USA, Try this formula: NULLIF(({quantity}-NVL({quantityshiprecv},0)-NVL({quantitycommitted},0)), 0)