User_KC8S1 Red Ribbon

I have had a look at the code provided but dont think i would be able to get this going without some more help on it. Does anyone have any more info on how to do this please? When does this script run? Where is it put? Any info would be much appreciated. Have you read the help on scripting? Your question is a big one and…

I submitted a case to support on this, and they created a defect #150275. However, I'm in need of a workaround while this is getting fixed, so I was hoping someone else had solved this problem. Here's the issue: Workflow 1. The contact for the customer creates a case in NetSuite via online case capture. The case is…

Hi, is it possible to capitalize the first letter of each word entered in the fields on sales forms? I know how to do this on the web site, but wanted to know if it was possible on the forms? Any help would be appreciated. Suitescript, field changed event. Very simple script. I don't think there is a way to set up…

Well, I guess generating an unexpected error truncates the field quite effectively ROFL! The workaround we came up with worked. Thank you. I still consider this a nasty bug, though, especially since it would leave someone reading the code scratching their head... Eric!.... You SHOULD have let me know in private, kept your…

Heads up! I just noticed this in the help: Note: Be aware that long text fields are truncated at 4000 characters in search/lookup operations.

I suppose I could try to use nlapiLookupField after nlapiLoadRecord, to just get that field's value, then place the updated field into the record and write it out with nlapiSubmitRecord. I'll try that... That's what I was thinking, yeah.

Have you checked: <Role> > Permissions > Setup > Custom Lists = View

You can (and should) use the utility method nlapiDateToString() - this will return a formatted date string using the same formatting from your preferences. nlapiDateToString(new Date()); Additionally you can pass a second format specifier argument for some additional formatting options (although you can't specify detailed…

You can do this pretty easily thanks to SuiteLets and the nlapiRequestUrl() method. Here is what I would do: [LIST=1] [*]Create a SuiteLet script that will create a tab and any custom fields on the record. [*]Create a Web Service (hosted by you) that will serve up the data from your external repository. [*]In a BeforeLoad…

Are you by any chance testing the security by changing your role to the role that your target audience will use? If you ARE doing this, NetSuite will consider the fact that you are the owner and assign privileges base on ownership rather than role membership. I don't like it, but that's the way it works. If this isn't what…

Hi Ray, thanks for the feedback. maybe a client script (maybe at SO level or something) that looks at the customer record for a "snow bird" flag and selects a shipto address (already on the customer record) with name say "snow bird" address if date criteria (also on the customer record) is set. -prompting the user to…

daylight savings and time zones!! What I've ended up doing is to remove the time zone offset component from the offset time stored as the "due date". javascripts Date() object has methods to obtain the offset in minutes, after than it's a matter of subtracting this value (multiplied up to milliseconds) from the result of…

I didn't know that, very cool.

well... the Integer field type has a max length of 10 characters. (not documented of course) javascript is being smart and returning the value as scientific notation which TO_NUMBER() seems to be choking on (probably because javascript uses it's own "special" format) Sigh... Anyone have a trick to force javascript to use…

Thanks for the reply Pog. I had thought about taking an approach like that but had hoped I could stick with built in types so I could still use filtering in the UI searches. I still may be able to, but if I CAN I bet there will be some crazy SQL-Oracle-Code involved. I forget where I noticed it, but the Time of Day fields…

Confused again on date arithmetic results. I've got a formula result in a saved search I'm toying with: (sysdate - {custrecord_ttttttt}) * 24 * 60 * 60 'custrecord_ttttttt' is a Time of Day field, but if you pass it to TO_CHAR you can extract a date component as well. So, the above formula is VERY close to being correct,…

This is somewhat related but did you know that you can format a Date object as a datetime string in SuiteScript: nlapiDateToString(new Date(), 'datetime') nlapiDateToString(new Date(), 'time') nlapiDateToString(new Date(), 'date') This API call takes an optional 2nd argument which can be used to format the Date as a date…

Thanks for sharing Pog- I've been messing around with this stuff this morning and I noticed that sysdate is printing a strange value for me. As I type this, my cell phone says it's 9:51am my watch says 9:50 am my computer says 9:50 am sysdate is printing: 06/02/2008 09:06:24 Soooo....? what's up? :confused: Nevermind, I…

Is there a way of adding more options to the 'Phone Status' list on the Phone Call form? At the moment there are just 2: Completed and Scheduled. Thanks I just ran into the same requirement the other day. I ended up creating a new field and a custom list to solve the problem. Hopefully this enhancment will get some votes!

Even Better! A text formula field with this: '<a href="http://www.google.com">google</a>' will display a link in the results. Sweet!

OK, maybe someone here can help me understand what's going on. As pog2000 suggested I've resorted to timestamps to try to acheive my use case. After some struggling with the various oracle functions and netsuite bugs (can't use custom text fields with TO_NUMBER) I finally had what I thought was a workable solution. Not the…

Possible solutions:[LIST=1] [*]Can we create URL fields in saved search results? If we could, I could build the url to point to the SuiteLet with the record parameters in the url [/LIST]IDEA!... Create a custom URL field on my record, hide it from all forms but show it the search results. I think I can create a formula…

Hi Yang, Confused.... Parent company? These contacts are related to a custom record, can I specify the custom record in the company field? I think I'm missing something.

Hi Josh, Thanks for the reply. Many of the contacts aren't a person, but a department or simply a hotline or service center, etc. We are creating contacts that represent the "Claims Department" or "Provider Relations Center" - most of the time we aren't fortunate enough to identify a person in said department that we can…

Yeah, I think I understand what you are saying, I was trying to understand how I can use that information in my case where there is no company involved. You know what I mean?

Lol!......

Hi Yang, No, that is not the behavior I am seeing, although it is what I expected. I've got a customer record ("Insurance Carrier") with a list of Contacts (parent /child - Insurance Carrier FK added to Contact record) I've enabled Mail Merge on the Insurance Carrier record. When I invoke the new Fax operation the only…

Oh yeah, I re-read your post... I was thinking you wanted the custom records to show up on the employee record but I see you want the opposite actually. Sorry for the confusion.

The only entity records that are displayed are entity records selection on fields on that custom record. Thanks, Yang Yang, This doesn't seem to work either. I've just added a transaction body field of type Contact. When I click the email button on the message tab of the sales order the contact in my custom contact field…

Case# 672233 Custom record with child Contacts not showing up in Message recipient list Still waiting for the ER from support. Child custom records are not included although that sounds like a good enhancement. I'll ask our product manager to follow up with you on this one. Hi Yang, I'd really like to talk to someone about…