T.Watz Red Ribbon

Hi, I don't think you have understood my problem. The idea is to exclude projects where any of its ancestors is inactive. Look at below example, in this case I want to include only the Great-Grandfather and none of the others. As the Grandfather is inactive, it and it's active descendants should be excluded.…

Hi @Richard James Uri-Oracle, that is the basic query to get all records based on it’s own active status. It doesn’t take into consideration the active statuses of it’s ancestors. A classification can be active even though it’s parent is inactive.

@Michelle Jabanes-Oracle , Thank you for the confirmation that it can't be done.

Hi @Patrick Fresnosa-Oracle, Yes the role has access to other record types. But it is only the employees that they should get the cross subsidiary viewing for. All vendors and customers are automatically shared with all active subsidiaries through scripting. We just don't want to make all transactions available for the…

Hi @"starlingMark", did you get any closer to getting openpgp.js into a suitescript?

Hi, I've just got a response from netsuite regarding the enhancement request. They wouldn't put it up since it was a duplicate of another one. The number of the existing one is 124571. You can find it by searching for that number on the suiteideas site. I have voted for the existing ER. Please do so you too! //best regards…

Hi, I've just been informed by my sales reps, that they can't send proper invites through Netsuite. And that is 4 years after we started to use netsuite. Now they have to create the event in netsuite, wait for it to sync over to lotus notes and then send the invite from notes. I really find it lacking to send an invite the…

Has anyone found another way of doing this? (as we can't have the above mentioned feature enabled)

I was just wondering this too. And perhaps a quota on revenue instead of billing. (when you use advanced revenue recognition)

However, is this is a transaction search? If so, {shippingaddress} and {shippingaddress.city} will probably contain the same city. But if you need to compare the customers default shipping address you might want to use {customer.shipcity} and compare that to either {shippingaddress.city} or {shippingaddress}: CASE WHEN…

I tried my formula against a multiple select field of the type employee. What I think you mean by list. Though I didn't compare to a formula, I had in('%Employee Name%'). Looking at your image, the columns look fine. Maybe try to hardcode it to in('%Friday%') and see it that works?

Native list of what? 30 seconds for a search seems like a lot. Have you double clicked the netsuite logo to see what takes so long? In the popup that's shows up if you do that can at least tell you if it is server-side or client-side. I assume that even if you have a limit on how many rows are shown, the full result is…

For future reference... Make sure that the sublist has not previously been sorted on a join column in another listview. This will affect all searches on that sublist, even if they don't include the joined column in the result or has it in the sorting. To fix: just sort the sublist again in the view that you want.

You could give this a try instead: Case When {custbody_vgw_so_del_days} like('%' || INITCAP(TO_CHAR ({shipdate}, 'DAY')) || '%') then 0 else 1 end and set it to equal 1

In my setup, this item search will generate 4344 rows with 0's on the rows that don't match according to your criteria (in the formula), and if I remove the formula-column. I still get 4344. [ATTACH=JSON]{"alt":"Click image for larger version Name:\tImage 17.png Views:\t1 Size:\t63.8 KB…

Maybe you have forgot the single quotes: CASE WHEN {shipaddress} LIKE '%{shippingaddress.city}%' THEN 'TRUE' ELSE 'FALSE' END

If you set all the columns to group, you will not have the edit buttons for anyone. And if you also replace all the fields to formulas, you won't be able to drill down either. This will only prevent on a per search basis and will also disable inline edit.

You can also try to concatenate the strings for the compare: CASE WHEN {shipaddress} LIKE '%' || {shippingaddress.city} || '%' THEN 'TRUE' ELSE 'FALSE' END

My guess is to limit data transfer between client and server and also for usability (ui). I'm thinking of when you want to download a large saved search that results in an excel file of 50+ MB. That takes a while to download. Think to have to wait for that if you have unlimited row counts in the UI. Personally I have…

Maybe try this: REPLACE(col_name, CHR(13) || CHR(10), '') From googling "oracle SQL remove carriage returns"

Ok, so the concept is similar. But as you'd want to filter it to "- mine-", I'd go for a Customer-search instead of an employee search as I demonstrated previously. The key is to use MAX on the date, and then filter out either those that are within 30 days or only show those that are before 30 days. You might need to keep…

Yeah exactly that's why I would start off by doing a csv-import to get the latest note per customer. And this wouldn't distinguish who made the note, only that someone has.

I'm guessing that you want to see employees that hasn't had any note registered within the last 30 days. My suggestion is that you change the search to a summary search with "MAX" set on User Notes: Date and group on Employee. This will then show you the latest date on a note for each employee. Then to only show those that…

You could replace the revenue field for a formula that is something similar to this: case when {transaction.date} between to_date('2018-1-1','yyyy-mm-dd') and to_date('2018-10-31','yyyy-mm-dd') then {transaction.amount} else 0 end And then don't have a date filter. The formula it self will act as a date filter for the…

Scratch the scheduled script. I think I'd try to create a after submit script on user notes that every time someone saves a note, searches for the latest user note on that customer record and then updates the custom-field on the customer. Here it is in it's simplest form (untested, note that it requires a custom field…

Yeah, forgot about that. Reminders don't play well with summary searches. You might need to create a scheduled script that sets a custom field on each customer with the "Latest User Note" and then create a search on that field.

case when {salesteammember} like '%' || {custbody_testfield} ||'%' then 1 else 0 end works for me. I might be wrong about this, but I think the real issue comes when you mix it with the NS_CONCAT() which is a formula that you need to set to MAX to use.

Create a custom field on the record that you want the button on. The field should have the type "Inline HTML". And in formula field you should input something like this: '<a href="/app/common/search/searchresults.csv?searchtype=Contact&AFC_CUSTRECORD_MARKETINGERBJUDANDEKOD=' || {id}…

Try putting "group" on all of the other columns.

Hi, The first formula does not work, and especially since the field-names are not correct. ({system notes: new value} is not a valid field name) The second formula contains an errant space in the first "Pending Fulfillment". So if you just copied the formula you probably got it too. And the formula is only tested on…