I asked Netsuite support about footer filters on published saved searches (which would help with this subordinate search) and got the following; This is not possible today hence an enhancement request has been rasied (on case 6311) to request that this be added in a future release. When I get an ER # I will add it here,…

Great! Thank you so much Srilatha.

Enhancement 73430 Please vote!!!

I also struggle with this... I can see why in the NS "role" world (where users can have several) that searches based on the users role are not possible/practical(?).

A Contact join would also be good for activity search

Thanks Evan! Activity search by Group, would be really helpful.

Last edited by Krish0nan

Please give us some kind of response here Netsuite, somebody must be able to give us an insight here! Is there something in the Help or Knowledge Base that we are missing? It cannot be unique that we need to dynamically utilise searches! We REALLY need searches by groups! Pretty please.....

Maybe someone has another way, I tried for a while for other methods but found this way worked pretty well, we have several sublists for each record type, eg on inventory we have 6 sublists, I might even do a few more. My users find it easy & useful.

sublists we have are: sales by week (with location filter) sales by month (with location filter) sales by location total soh returns by month (with location filter) they are pretty simple but easily let lots of info be seen right on the record

We setup sublists on the inventory tab for this and various other searches on transactions for items. Results; sum of 'location on hand' These sublists are great, eg we added 1 on vendors that show best sellers & also displays the item image.. go sublists :p might be other ways but this worked for us..

I wasn't entirely sure how custom parent-child record relationships work. :) They can be very complex, even outside the NS context. :p

We use online case form to catch applicants info (including resume) http://www.treeoflife.com.au/Careers/Job-Opportunities We have 1000's of applicants on file from this method and use a workflow to manage the progress of applicants looking to work with us. If you look into the customisation options I think you will be…

Will do, thanks

Hi John, I have tried currency, integer & decimal, all show no result - thanks for your input though! & Evans too.

OK so I have 2 (custom) columns, they have values; current price (currency) full price (currency) I just want 1 more calculated column = saving {full price - current price} It won't calculate (I am unmarking stored)... ideas?

The only formula field is #3 as below. 1. Custom 'full price' is sourced from the item record. 2. I am trying to source the customers base price, closest I can get is the item base price, can work with that. 3. My custom 'saving' is a formula field 1-2. Thanks!

That is correct, maybe not possible? - or need a script, it will be helpful for us to do this somehow. I also tried it as 2 stored fields, could not get a formula working with that either.

It would be Very helpful to be able to customise forms and explicitly label "First Name" "Middle Name" "Last Name". We are using Netsuite in a retail POS environment and not being able to name & display Exactly what is what, creates a training burden.

for quick signup forms on website i think it's good that someone can submit email + name (without firstname, lastname; being enforced).. many sites have it set like that. Seem like using forms you can set what is mandatory for your business anyway, not sure why having the option of either is making a problem?

Maybe you should checkout Transfer Orders, they do allow custom fields, etc

Thanks, Evan. I need to be able to restrict the form for an Employee Center role - it seems to allow all CRM forms (in this case I want to restrict the Event form we have created) without a way to disable access. What am I missing? I have a custom employee centre role, I set 1 event form as preferred, now that role can…

Hello Krishnan, If you have the preference "Show Employees as Contacts" set to True in Setup> Company> General Preferences, any activities (e.g. event) for your employee will reflect on the Activities tab of the Contact:Employee record. I have tried this and the activities don't show up on the emp:contact

insert Happy Person! sounds like 8.2 could be exciting especially if the calendar gets the hinted at rework also. BTW Rob, what we ended up with was to create a custom record say "confidential information" then have all that info on that record and apply the permissions to that record type. That works well for us.

Hey Hazel, Yes what you say is true. The reason it comes up is my HR people are working the Employee view of the entities rather than the Contact:Employee view. It is tricky to explain to my HR staff the concept of Entity views so I thought well why not just let them see that activities at the Employee view? I will just…

Is this documented in the help? That would help. I have also scratched my head when working in the permission area and had the same experience Steve had when dealing with custom lists, I went down the line of thought that I would need to convert them all to custom records and define the permissions from them, now reading…

insert unhappy person.

Sounds like you need datetime, maybe there is a way to join date and time fields then calc? past my knowledge though... sorry

I have formula field, store value; no, decimal number. {custrecord_roster_end}-{custrecord_roster_start} both are TOD result = ERROR Invalid Expression (that could be a good new smiley type #-] ). :confused:

Hey, what about the Holidays! :) OK, I have a TOD field and then another field (shown in list, on the record - freeformtext) which is formula TO_CHAR({custrecord_myTODfield}). So then I enter some times into my records TOD field then in list it will display a date value (always the start of a month), but then on the record…