User_KC8S1 Red Ribbon

are you still getting the expression error or just an incorrect, unexpected result?

"Invalid Expression" sure is a useless error message, isn't it?! :( The following should do what you want CASE WHEN {custentity_date1} > TO_DATE('09212009', 'MMDDYYYY') THEN ADD_MONTHS({custentity_date1}, 12) ELSE ADD_MONTHS({custentity_date1}, 9) END

I think the sandbox should be a standard included netsuite feature and would encourage better adoption of netsuites more advanced features by all of its users. I agree Fred, this would be really nice if it was included. I also agree that for experimenting and training the SB is a great tool.

I'll open a case, but wow is my sandbox account messed up! [LIST] [*]Searches that take 2 seconds in my production account are timing out in the sandbox [*]My version of help is "old" - there is nothing in the help about the 2009.2 features (e.g. UI Assistant) [*]Can't change roles [*]Searching help results in 404…

if custentity is a date field (versus a text field) then you are comparing a date to a string. I think you need to either construct a date type from you static string or convert the date field to a string. Performance wise I have no idea what is cheaper and it probably doesn't matter anyway. SO... something like this:…

oh sorry, I was thinking this was a search column. OK, I will give this a shot in a minute and see if I can figure anything out.

So what do we say? Are there other customers out there that feel the same like us? We would be. Have you had any response from NetSuite? You can reach me at sklett@pmddirect.com

When I researched integration with several repository services the problem I ran into was authenticating requests against the host system. NetSuite has part of the solution in that you can define a File record with a URL source (great!) but I wasn't able to come up with a secure way to protected the external assets and…

Works like a charm! Cool, thanks for the help! This just became a valuable thread as I think it's safe to say none of this is particularly obvious. Well to me it's not at least. :rolleyes:

Nice one! A bit obscure, but it accomplishes exactly what I want, thanks. Now.... what is the trick for built in records? Say I want to show the transaction fields only.... I tried: [LIST] [*]RECORDtransaction [*]transaction[/LIST] Neither worked, just filtered the list down to nothing.

Thanks Evan. :) Last question, is their any clever solution to setup a dynamic Type filter based on another field of type List/Record : Record Type? Let's say I'm defining a set of Rules (custom record) and I want to pick a Record Type, then a Field from that record. It's not currently possible, right?

Sure, I'm not suggesting there is a defect but rather unexpected behavior. OK, so let's say I have a Record Type called Baseball Card with the following fields:[LIST] [*]Year [*]PlayerId [*]Team [*]FirstName [*]SeriesNumber[/LIST]I know, it's weird... just go with it. Then, on another custom record I add a List/Record :…

Ha, and COLUMN yields expected results! Let me save us some time, can I please have: [LIST] [*]Case [*]Entity [*]Message [*]Note [*]Event[/LIST]

That's strange, it works for me in a similar setup when I choose to insert something from "XXX fields...". Anyway, what you should be getting, and using, is {custrecordXXX.email} where custrecordXXX is the internal id of the custom contact field. If you can file a dfect about the insert field selector not working correctly…

I see. If you don't want the sublist, then there is no need to use "record is parent." That is the main benefit. If you do a custom field of list/record type then instead of the sublist you should get what you need. In my opinion the most valuable side effect of Record is Parent is that the join in available in both…

Thanks for the comment. A one-to-many is established with a regular List/Record field though, so how is Record is Parent any different? I has suspected that Record is Parent may create a Constraint, but that also seems to be present regardless of this setting. Maybe it's only effect is on the UI with the automatic creation…

Hi Steve, Support sent you an email. Please review and reply to that email if you need additional assistance. Thanks. Hi Maria, I saw the email and the workaround for the defect. I will copy it here for others to see. Do understand that by posting the instructions I am not accepting the workaround and "by design", only…

OK, thanks. Two confirmations is good enough for me. I'll go ahead and turn this option on and then modify the form to hide the sublist. Thanks to both of you.

No can do. It's in the "not customizable" club with Address and Message :(

... Can this also be done with a fax? Sending an addtioanl sheet to accompany the invoice or sales order. Yes, from the transaction create a new fax and then follow the instructions above for the email. careful if using HTML, FaxAway and efax (one of the worst companies in the world) have different finicky rules about…

dear ug, I think i have a similar issue too. mine is that in a search for the scores of a particular student i want to be able to total the score so it can show in a column on the search page or a report card thanks ERP Try: Student | Group Score | Sum

Sorry Olivier, I don't have anything to add that Yang hasn't covered already. ...this sounds like a possible deployment issue. How do you know the UE did not fire? Is it released? Is the audience configured properly? Is the logging level set to what you would expect it to be? Do you have over 5 UEs deployed to the customer…

use setTimeout() with 1 ms delay - it's psuedo multi-threading in javascript. I haven't tried in awhile, but I think it will give you the result you want. Something like: setTimeout('document.body.style.cursor = 'wait'', 1);

There isn't a way (although there should be). Besides what Olivier suggested (which is what I usually do): Depending on how often the list/record data changes, you can create a in-memory map/representation. Something like: var myRecordOrListData = { 1: 'Green', 2: 'Blue', 3: 'Red', 4: 'etc' } // then you take your…

I don't understand what you mean or what this has to do with my comment. I'm not concerned with the case, but more with defects being defects. Maybe I'm missing your point?

FYI... Support contacted me moments ago to inform me of an existing enhancement for this. Yes, an enhancement. I asserted that missing documentation is a defect, not an enhancment and requested that it be treated as such. The support rep informed me she would work with her supervisor, product management and the rep that…

errrors-wise I don't see a problem unless {exchangeRate} is zero. To round, use the Round() method. so yer formula would be: round( (({rate}/{exchangeRate})*{quantityCommitted}), 2 )

When the "Links" portlet is in a narrow column, only some of the links show, based on the setting of this flag. Thanks, -e Got it, thanks for the info. Jim: I entered a case for the missing documentation: 789015

Hi Sklett, thanks for that. I dont suppose you have an easy sample do you, im new to NetSuite and not very similar with SuitScript. Thanks in advance. Sure. The following pieces are grabbed from various scripts I have so you will need to use the parts that apply: /* * Event handler for field values changing. (this is the…

Support Department decided to refer you to Professional Services to get help on creating something like Support's "awaiting customer reply script". Please contact your account manager. What a phenomenally greedy response to a fair request. Just give him the script with the typical "no warranty or support offered"?? Not to…