mgoodman

'give me all projects where probability is not equal to 0 or 100' - or at least I can't work out a way - let me know if there is. Try adding two filters: - Probability is greater than 0% - Probability is less than 100% That should do the job.

in field formula under validation and defaulting Comment by mgoodman Aug 27, 2009 9:16AM

NVL({custbody3},',') seems right to me, but more importantly, why would you want to replace a null value with a comma?

in case statement to check if a field is empty Comment by mgoodman Sep 14, 2009 8:33AM

Where are you trying to display this custom drop-down, and what is its underlying purpose?

in field formula under validation and defaulting Comment by mgoodman Sep 9, 2009 8:43AM

So the first list is a Customer search, and the second one is an Item search, correct? One way you can solve this is to have a formula field (Text) in your first saved search that is an HTML link to the second item Saved Search. You can then pass filter parameters through the link to the second search to filter the items…

in Category within category search Comment by mgoodman Aug 20, 2009 9:01AM

Hi Kris, Can you describe how your Saved Search for the custom KPI is set up, and how you tested it?

in Custom KPI - Period Versus Date Filters Comment by mgoodman Aug 13, 2009 8:35AM

Try adding END at the end of your statement.

in field formula under validation and defaulting Comment by mgoodman Aug 26, 2009 8:51AM

If you're looking for a null value, use NVL(expr1, expr2). If expr1 is null, it will return expr2. Generally I just compare to a blank string (i.e. '') and that does the job. In SQL, the "not equal to" operator is <>.

in case statement to check if a field is empty Comment by mgoodman Aug 25, 2009 9:44AM

The only thing I can think of is you might have conflict between the Account column and the Applied Transaction column. Try removing your Account criteria and add it to your results to see if the account is really the ones you were expecting to show up.

in Payment search filtered on Applied Invoice Items Comment by mgoodman Aug 17, 2009 9:07AM

I've had to deal with similar issues in the past, and what I ended up doing is determine exactly when {amount} is needed and when {fxamount}*is needed, and create a CASE statement accordingly: CASE WHEN (your condition where you need fxamount) THEN {fxamount} ELSE {amount} END

in {amount} vs {fxamount} when in formulas? Comment by mgoodman Aug 28, 2009 9:33AM

How about this: Criteria: - Login Acces is true (I've seen rare cases where Employees had roles but no login access) - System Notes : Field is Login Access - System Notes : New Value is T Results: - Name - Role - System Notes : Date (when the Login Access Field changed to T) - System Notes : Set By (who changed it) - [...]…

in Managing users / role search Comment by mgoodman Aug 20, 2009 8:49AM

When you use a Date filter based on periods, it uses Accounting Periods. Accounting Periods are not always set up on a monthly basis, sometimes they're quarterly, so I wanted to confirm with you that your Accounting Periods are set up on a monthly basis. You can check in Setup > Accounting > Manage Accounting Periods to…

in Custom KPI - Period Versus Date Filters Comment by mgoodman Aug 17, 2009 10:28AM

Just to make sure, are your periods set up as one-month each?

in Custom KPI - Period Versus Date Filters Comment by mgoodman Aug 17, 2009 8:36AM

Is the number for Last Period much higher than the one for Last Month? Just as a test, can you try comparing Last Period with the 3 months of the last quarter?

in Custom KPI - Period Versus Date Filters Comment by mgoodman Aug 17, 2009 11:25AM

Hi Jordan, Try using Campaign "Internal ID" and choosing "-None-" as your criteria.

in Search for Contacts NOT associated with a campaign Comment by mgoodman Aug 7, 2009 9:13AM

could it be that your button has return false twice? return false;return false; That shouldn't matter as the return statement is a breaking statement, i.e. the return statement exits the function and code following it is never executed. This definitely looks like a case for NetSuite Support. At least the Advanced Search…

in Search function not working- Help Comment by mgoodman Aug 6, 2009 8:42AM

Possibly, but I did some tests with some XML and couldn't reproduce the problem. If you give me the full description of your Saved Search with the XML in question, I'll try it out in my demo account to see if I can reproduce the problem.

in How To Search & Create Formulas for Long Text Fields Comment by mgoodman Jul 30, 2009 9:01AM

Hi, Detailed description is a rich text field. for some items, we add an object tag there to display a video (usually from youtube), I tried to create a saved search for items contains "youtube" in detailed description, but not all items retrieved - is that because youtube keyword existing in HTML tag (not displayed in…

in item search depends on detailed description and sales description Comment by mgoodman Oct 20, 2010 8:15AM

I created a custom Long Text Entity Field and was able to use it in a 'contains' criteria of a Customer Search successfully, but when using it in a Formula (Text) field, it would return something along the lines of "oracle.sql.CLOB@e0f95". Looks like the formula is returning the SQL object instead of the text. EDIT: Using…

in How To Search & Create Formulas for Long Text Fields Comment by mgoodman Jul 29, 2009 9:23AM

Hi Bushra, You can get what you need by using Formula Fields. 1) For your first search, add a criteria Formula (Text), in the Formula put {salesdescription} and the criteria should be "contains" and "Final". 2) For your second search, just like the first solution, make a Formula (Text), and in the Formula field put…

in item search depends on detailed description and sales description Comment by mgoodman Jul 28, 2009 8:40AM

Hmm.... the only field that could be the right one is Rate, although that might be for all price levels or if you don't use price levels at all. Did you try that?

in item search depends on detailed description and sales description Comment by mgoodman Jul 28, 2009 9:02AM

thank you. i did this before but doesnt it also affect scripts that contain nlapiSearchRecord and are not executed as admin? That's very possible. Is this a problem? Why don't you just execute the script as admin?

in Edit View button removal Comment by mgoodman Jul 15, 2009 10:19AM

Here you go: function validateLine(type){ if(type == 'addressbook'){ alert("Cant edit addressbook!"); return false; } return true; }

in restrict editing to the addressbook Comment by mgoodman Jul 9, 2009 8:47AM

Did you try setting Field-level permissions to None for your Partner Center role? I was able to hide certain fields of a Custom Record in a Search (criteria and results) by doing the following: - Go to Setup -> Customization -> Record Types and click on your custom record name; - Click on the field name you want to…

in Return to Criteria button Comment by mgoodman Jul 1, 2009 9:13AM

Hmm, looks pretty much the same, I don't see why one would work and another wouldn't. At this point I would suggest contacting NetSuite Support and opening a case.

in item search depends on detailed description and sales description Comment by mgoodman Oct 21, 2010 7:16AM

You can do criteria - Date Created = Yesterday. Let's on a Tuesday, the saved search will send email on cases that were created on the Monday. Right, but if it was created on Monday at 11:59PM, your approach could send an e-mail at 12:00AM on Tuesday, one minute after the record was created.

in Scheduled Emailing Saved Search Questions Comment by mgoodman Jul 24, 2009 9:39AM

We also need to pull in Commission fees with invoices so that we can calculate "Customer Contribution", which is Gross Profit - Commissions. If anyone know how to do this, or has a solution for sale, please post here. Thanks. Since NetSuite Solution Providers and other developers aren't technically allowed to offer their…

in Search to Commissionable Revenue Comment by mgoodman Jul 14, 2010 9:12AM

I think you'll need to be more specific on what type of Saved Search you're running, what Criteria you're using and which Result columns you're displaying. For example, if you're doing a Transaction search and a Partner doesn't yet have any transactions, they won't show up in the results. You'd want to do a Partner search…

in Saved Search not showing Nill result Comment by mgoodman Jul 23, 2009 9:23AM

How about a Client script on Validate Line, check if the type is "addressbook" and deny the submission of the line if it is? Seems to work pretty well, but isn't flawless. The Insert button isn't always caught for example.

in restrict editing to the addressbook Comment by mgoodman Jul 8, 2009 9:05AM

I'm surprised that didn't take care of it. Let me test it and see. Can you be a bit more specific? Which record are you talking about? Where are your employees viewing the list? Is it from a sublist? Is it from a portlet?

in Edit View button removal Comment by mgoodman Jul 14, 2009 11:57AM

If you use "Applying Transaction..." with Main Line False you should be able to get to the Payment line items from the Invoice results. Alternatively, you can do a Payment search and use "Applied To Transaction..." fields to retrieve the invoice line items. Also check out "Applied To Link Amount" and "Applying Link Amount"…

in Search to Commissionable Revenue Comment by mgoodman Jul 8, 2009 8:43AM

MFA for Oracle Community

mgoodman Red Ribbon

Comments