3948168 Green Ribbon

Thanks Malin, I just voted on it.

Try adding two filters: - Probability is greater than 0% - Probability is less than 100% I think there is overlap in this logic but I tried something similar - probability - not equal - 0 and probability - not equal - 100 As soon as I add the first filter I get an error on the data entry form.

thanks that works - silly mistake!

OK my objective is to have a dropdown list of projects that is filtered according to a custom field on the project record called probability which is of type percent. I want to show projects that have a probability from 1-99 ie exclude both 0% and 100% projects from the list. I found under sourcing and filtering there are…

GREAT solution! One very small correction which I sure was a typo related to brackets you used curly brackets instead of round ones - here's the solution: case when {custentity_strat_house.id} in (26,2,27,28) then 'other consulting' else {custentity_strat_house} end One question, where can I find out more about other SQL…

Can you try just displaying balance as a separate column and also whatever custentity12 is. Display them both as columns then have your formula column next, there must be something wrong and you just have to break it down to small enough pieces till you find it. I've rarely found errors that weren't my fault! well somewhat…

Just voted on the enhancement, I added some additions to it: I'd expand on the current request but also use it in a few ways: 1. Just like we have an employee type saved search we need one for saved searches so we can run reports on the saved searches we have. This would include: 2. Which searches have scheduled emails set…

Just try FORMULA (NUMERIC) {custentity12} and see if you still get the error - if so then I'd try the above as a text formula to see what value is coming out. If you still get the error then try selecting the field again using the UI (user interface) in case you got the field ID wrong. If the field you are accessing is on…

I'd break down the formula into parts and check if each part is getting the desired result. I'd also ungroup the search to show all records initially so you understand what underlying data is being brought in by the criteria on the search. So in a testing column I'd have formula (numeric), formula: TRUNC ({today}-1) And in…

FYI - we found this solution worked - case when ({custevent5}='T' or {custevent17}='T') and {status} = 'Completed' and round({today}-{completeddate})<31 then 1 end you can then just change the number of days at the end from 31 to 365 to get a yearly view.

A non-stored formula field will not work on a report (only on a search) and if it is stored it won't actually execute the formula except on initial record creation (and then it will only be beased on the default value of the other fields). If you want to store the value you would need to write a simple before submit script…

If you want to store the value you would need to write a simple before submit script that calculates the value, otherwise you will need to use a search. Can you write a script that also calculates upon update of the record via in-line editing? Is it a separate / different script or does the script work in each case based…

Thanks Yang, I tried this and it works which is great. One more question: Under setup - company - regions There is a list of regions that are linked to various custom fields on forms. How do I get the 'custom_list_id' of these system lists?

Problem: I created a script to run against the results of a saved search, it worked the first time it ran but hasn't worked subsequently. I could see it worked both in the execution log and seeing a changed value in each record of the saved search. The saved search has about 25 records in it both before and after running…

function samplePageInit() { var myfield1 = nlapiGetFieldValue('custevent5'); var myfield2 = nlapiGetFieldValue('custevent17'); if (myfield1 == 'T' || myfield2 == 'T') { nlapiSetFieldValue('custevent20', 1, false); } } Great Post, thanks for you help, the above code works and really helped me to understand some of the basic…

If your outcome is just to calculate total duration why not do it in a saved search. Saved search type = time Criteria tab could define the overall timeframe you want the task durations calculated in eg date is on or after 1/1/09 Results tab field - 'assigned to' ie the name of the person the task is allocated to summary…

<span style="color:'"DarkRed"'">function pageinit(type) { if (type=='edit') { nlapiSetFieldValue('custevent_total_duration',calculateTime()); nlapiLogExecution("debug","debug","nlapiSetFieldValue('custevent_total_duration' ") ; } } function calculateTime() { var linecount = nlapiGetLineItemCount('time'); var total = 0;…

Thanks Nick, I appreciate the input.

ok just solved this one! - I missed the simple step of doing a summary of count on the results tab. All working now.

I'm looking to pull information out of 2 record types that have overlapping data items, so what you are talking about sounds good. Since this message was written in 2006 I'm wondering in the joining of data is now possible in NS? Also where is a good place to start learning about the learning the programming side of ns eg…

That worked thanks Evan!

otherwise you would need to use ODBC. How do I go about learning to use ODBC? is there a reference manual?

I've been reading through lots of posts which talk about the sql function - keep() and dense_rank. This is what I've come up with so far but I'm getting an Error "invalid expresion" - here's what I have in my saved search under the Date - summary type = Maximum Employee name - summary type = group Formula (currency)…

There are many applications to this problem that people must have worked out - You might have customers and want to pull out what their latest sale was for all your customers. It would be easy to pull out for customers all of their sales in the last month, but I'm looking for something that pulls out just the most recent…

This is really helpful Evan, that works!

Try installing the publicly available "Resource Scheduler" SuiteBundle (bundle id=619). Being new to NS, what are the steps to installing this resource scheduler? We are a consulting firm and currently run a large supply and demand resourcing spreadsheet which we'd like to incorporate into ns. We basically input across the…

I've gone through the post on using formulae in searches - https://usergroup.netsuite.com/users/showthread.php?t=5889&page=8 but can't get mine to work. I'm trying to build a report on projects that shows how many different types of employees are working on that project. We have 9 types or levels/grades of employees -…

then you could do something like 'AEM: '||count(decode({custevent_project_resource_type}, 'AEM', {internalid}))||', SEM: '||count(decode({custevent_project_resource_type}, 'SEM', {internalid})) ... And apply a count summary type to that column. Let me know if that helps. The above hasn't worked and I don't have a solution…

Has anyone tried this product: https://forms.netsuite.com/app/site/...solution_id=69 This is the Celigo SmartClient for NetSuite. We're trialling this software now - they'll allow you to trial it. I find it pretty good generally.

Hi Fred, Thanks for the advice. Will give it a try. One issue may be that some of our users aren't very computer literate so if anyone has a virtual "push button" application they are using I'd love to hear about it. Many thanks once again. Clint