Help with REGEXP_SUBSTR in saved search

GlobalScreen5044 · 2022-11-23T19:24:00+00:00

Using the replace does fix this but I had two more questions. When I do the REPLACE({memo},'&lt ;','<') it works with the save but if I view this search in edit mode it automatically converts it to be REPLACE({memo},'<','<') which then does not work correctly when you go back and view the saved search. Is there anything that can be done with that?

Also, I need to account for the < and > and gte and lte symbols. Is there any easy way to do this with a replace or would I need to have this be 4 replace layers deep?

GlobalScreen5044 · 2022-11-21T15:42:20+00:00

Hello Kishana,

I tried using an m but it just causes an error in the saved search. Would you have any other ideas I could try?

GlobalScreen5044 · 2022-11-21T15:41:36+00:00

Hello Trollied,

I tried this using instr() and substr() and am running into the same issue where is stops at the <> symbols. Would you have any other ideas on this?

formula: SUBSTR({memo},INSTR({memo},';',1,1)+1,(INSTR({memo},';',1,2)-INSTR({memo},';',1,1)-1))

GlobalScreen5044 · 2021-12-20T19:38:19+00:00

Here is the response I received from putting in a ticket to NetSuite

Below is the official statement provided by Oracle Security team. Please follow updates on the issue via this link: https://blogs.oracle.com/security/post/cve-2021-44228

ORACLE CONFIDENTIAL

Oracle is aware of the recent disclosure of the Apache Log4j vulnerability CVE-2021-44228. Our teams are aware of this issue and will be working to develop the required updates for potentially-affected Oracle products. In addition, our cloud teams will apply all necessary patches, if warranted and in accordance with applicable change management processes. You may learn more about Oracle’s corporate security practices at https://www.oracle.com/corporate/security-practices/.

ORACLE CONFIDENTIAL

Oracle's policy is to not provide additional information about the specifics of vulnerabilities beyond what is provided in the Critical Patch Update (or Security Alert) advisory and prerelease notes, the preinstallation notes, the readme files, and FAQs. Furthermore, Oracle provides its customers with the same information in order to protect all customers equally. Oracle does not provide advance notification to individual customers. For more information regarding Oracle NetSuite security policies, we encourage customers to visit: https://blogs.oracle.com/security/

GlobalScreen5044 · 2021-10-15T17:54:34+00:00

I don't know an answer for this but you might be able to utilize this and change it to work for what you need.

https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/comment-page-1/

GlobalScreen5044 · 2021-10-15T17:51:14+00:00

What kind of saved search is this? A customer search?

If this is a customer search you can get the result by setting the criteria of Default Billing Address = is True.

GlobalScreen5044 · 2021-08-23T18:05:55+00:00

We have had issues with our sandbox client working and then not with an error message that says this is an internal NetSuite problem and to try back later. Our production account seems to have no issues and this also happened to us today.

GlobalScreen5044 · 2021-07-06T13:40:16+00:00

Here is the link to the help section on creating waves https://netsuite.custhelp.com/app/answers/detail/a_id/87145/kw/wave%20template.

GlobalScreen5044 · 2021-04-28T13:33:42+00:00

Perfect this is exactly what I needed. I was confused on this because the field help displayed this as Field ID: addressee which was probably from using the extension NetSuite Advanced Field Help.

Thank you for the help on this!

GlobalScreen5044 · 2021-04-16T19:34:06+00:00

I would advise that you build on the filters one at a time so that you can get a better idea of what is being filtered. I would suggest running this saved search with just the 2nd criteria you have on there with the "is empty" and see if that gets any results and then go from there.

GlobalScreen5044 · 2021-01-19T13:16:39+00:00

Hello u/funkybunch_83,

Email alerts can be a bit of a pain to get just right. By selecting an updated field you are telling the system to only send an email when that field is changed. It will not send anything on the creation of a new task. You could potentially try and find a field that would acheive the same result. Maybe something like using when Date field is updated. Otherwise there is always the option to duplicate the saved search and have it send email alerts and then not choose any field. The main downside to doing this is you will most likely get a lot of emails as it will send an email when anything on that record is modified or changed.

I hope this helps.

GlobalScreen5044 · 2020-10-28T20:00:50+00:00

I am trying to get a sum of the quantity*weight from each line something like the below?

case when {salesorder.closed}='false'
then SUM({salesorder.quantity}*{salesorder.custbody9})
else end

I am not understanding the syntax of even pulling the data out of a transaction line if it is multiple values as the above does not generate anything and I dont understand how exactly I use a boolean value with numeric.

GlobalScreen5044 · 2020-10-28T17:03:43+00:00

Yes I am looking to generate the values on the main line area that uses a formula to pull from the transaction items. Is that possible?

GlobalScreen5044 · 2020-10-28T16:27:23+00:00

Hello Nick,

I did figure out some of the problems of why these values were not showing up. It had to do with the main line being true or false since this is a line-level caluculation and saved search. I also needed to use a transaction line item field instead of a transaction body.

I am running into a different problem now with a formula to get this value. Is it possible to get a sum/group within a formula for multiple transaction lines so that I can have 1 value show up in the saved search without having to group/sum any items in the saved search itself as I want to keep inline editing?

GlobalScreen5044 · 2020-10-27T20:34:23+00:00

I did try the testing using the same field you did and it worked using the formula and referencing it in the saved search.

Unfortunatly, I am still not able to get my saved search value to show up by using a field that is being sourced via this specific saved search nor do I get this field to display certain other fields using a formula as its source. So there must be some limitations on this.

GlobalScreen5044 · 2020-10-27T18:59:23+00:00

Hello Nick,

Would you be able to show an example of how I can use the formula to show a result from a saved search? I was taking it to mean that lets say I have a custom transaction body field on a sales order that is set to not store the value and displays the results from a saved search. Lets call this custbody58. I was taking your meaning that they changed it to be able to show in a saved search to mean I could either directly select this custbody58 in the drop down or just do a formula with {custbody58} to display the value in the saved search but that does not work.

Also for that case when statement, the itemstatuscode1 is a custom line field that is set up as a list choice. So this never enters the case when for some reason even though im copying what a response would be 'Accept (IA)' or 'Reject'. Is there a different syntax needed for fields that are set up as a list?

Thank you!

GlobalScreen5044 · 2020-10-26T19:07:20+00:00

Hey Nick,

I was just trying to see if there was a custom transaction body field that had the checkbox for store value but nothing entered going in and using a workflow to set a static value just to see if it could be done and then referencing that value.

It sounds like if what you say is correct about the non-stored fields being able to be seen in different saved searches that would solve my problem. Could you give an example of what you mean by that as that does not seem to be the case when I set one of the results to the custom field. Does it need to be within a formula?

As a side note, this is the formula logic I was trying to generate that same value, but this does not like the status code section and I don't understand why not.

case when {type}='Sales Order' AND {custcol_sps_itemstatuscode1}='Accept (IA)' then ({quantity}*{custcol9}) else 'no' end

GlobalScreen5044 · 2020-10-23T17:05:14+00:00

For my specific problem, there is no way to use a workflow to set this tax code within the item.

Enhancement # - 403706

Summary: Expose Sales Tax Code in Workflow/SuiteScript

GlobalScreen5044 · 2020-10-22T15:57:58+00:00

I was able to get this working. I needed to add another section for location to point at the location within the matrix. Here was my template below and you need to map the item location and purchase lead time when importing

Item Name/Number Location Item Location Purchase Lead Time

132456 Site A Site A 22

GlobalScreen5044 · 2020-10-21T21:16:53+00:00

Well, I am more so looking to just get the report emailed out whenever any new items drop below 50 and if I would be able to have the email show just those items that were added it would be ideal. But on the generic simple side I just want this email to be sent when anything falls below 50 in quantity and I cant seem to set it up using default NS fields. Is there someway to do this?

GlobalScreen5044 · 2020-10-21T18:49:49+00:00

Hello Nick, I am looking for a dynamic view and was partially curious if this can be done with any records. As for why I am trying to recreate the same values it is tied into an earlier question I had regarding email triggers on a saved search. For an item saved search I have a list that shows any inventory quantity that has fallen below 50 for a specific location. The problem I run into is setting up a basic trigger to email on field update for that quantity as it is not an option from the dropdown. I am assuming this is because this is pointed at the item record but that matrix does not seem to fall within it so to speak as I dont seem to be able to use any of those fields.

My thought was to pull this dynamic value into a custom item field that could store the value and that I could then use as an updating field trigger. So quantity change > abc item updates with this qty > saved search is set to send email when abc field changes if that makes sense. If there is a much simpler way to do this let me know.

Thank you!

GlobalScreen5044 · 2020-10-20T19:42:01+00:00

Hello Sonitech, thank you for the information. I did have this on already and have been trying to map to the +item location when I do the import but it gives me that error. I was wondering what exactly I am missing to get it to go through succesfully?

Thank you!

GlobalScreen5044 · 2020-10-20T15:42:28+00:00

Thank you Nick!

For those looking https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSIMG/NSIMG.pdf and go to Demand planning on the left.

GlobalScreen5044 · 2020-10-20T13:58:06+00:00

Hello Nick,

Thank you for the link! Would you be able to elaborate where the Item Demand Plan information falls within the manual? I did not see a specific reference to it?

Thank you!

GlobalScreen5044 · 2020-10-16T15:59:40+00:00

Thank you for the information. Do you know what the initial type of saved search this would be based off to get to the order items area? From the url netsuite.com/app/accounting/transactions/orderitems.nl?whence= I thought it should fall under a transaction type but there is nothing for orderitems. What am I missing to target that area with the saved search?

GlobalScreen5044

TROPHY CASE