Was NS Support able to resolve this case? I am now having a similar issue.

Mchen, can you tell us more about when exactly you would like that check box to be checked? How is the Order being changed to status Shipped? Is it a manual process? Is it when the fulfillment is issued? What is the purpose of the checkbox? All of these help to determine which of the many methods that netsuite offers to…

Robbie, I like what you have done here is clean and concise. However this code will error if there are no sales orders yet for the current day. I have commented my edits to what you did below. function flagDropShipOrders() { var filters, results, i, salesOrdersProcessed, salesOrderId; filters = []; filters.push(new…

Try this; var strItemPreferredVendor = nlapiLookupField('inventoryitem',intItemIndex,'vendorname'); This will return the ID of the vendor. as long a s intItemIndex is a valid int. -Sean

After looking more closely at the Record Browser and the Help article above I believe you are correct BrettKnights. The way I suggested would work but yours is more elegant. -Sean

nlapiLookupField(type, id, fields, text) Performs a search for one or more body fields on a record. This function supports joined-field lookups. Note that the notation for joined fields is: join_id.field_name Note: Long text fields are truncated at 4000 characters in search/lookup operations. See API Governance for the…

Gary, Perhaps you could accomplish something similar, I know it would not be exactly the same, by importing the line items from your CSV to Purchase orders, via script you could do one PO per CC per billing cycle and add multiple line items to it? For commonly purchased items you could create a for Purchase Item in NS and…

I use filters in scripted searches all the time and as long as you get the syntax right, result set returned is filtered.

try changing var rec = nlapiLoadRecord(nlapiGetRecordType(),nlapiGetRecor dId()); to var rec = nlapiGetNewRecord(); nlapiGetNewRecord references the current record on the screen with all field level changes that have been made since the user opened the record. When you submit this rec you will get what you want. using…

What field(s) does applyDiscount(name); change? I looks to me like perhaps applyDiscount(name); changes the 'custcol_discount_pct' which in turn calls onFieldChange again which then recalls applyDiscount(name) -- now your in a loop. however, if like Lorne says, you set firefieldchanged to false when you set the field value…

I should have mentioned that you need to make this a server script for it to work. I cannot think of a way for this to work in a client script at all. Put you new code into a BeforeSubmit script function contact_BeforeSubmit(type) { var savestatus = true; var rec = nlapiGetNewRecord(); var APEmailid =…

If the purpose of your script is to validate field values prior to saving and disallow save if the validation fails, you should use a BeforeSubmit user event to do the validation and use the standard save buttons. If the validation passes return true and the save will happen, if it fails return false and the save will be…

I also have not tested this but, I would further modify what khultquist suggests by changing this line; nlapiSetFieldValue('linkedtrackingnumbers', link + trackField); TO this nlapiSetFieldValue('linkedtrackingnumbers', '<a href="' + link + trackField +'">' + trackField + '</a>'); This will make the tracking…

Your not specify which field should get this value nlapiSetFieldText('<a href="' + link + trackField +'">' + '</a>'); try this; var myfld = nlapiGetField('linkedtrackingnumbers'); myfld.setDefaultValue('&lt;a href="' + link + trackField +'"&gt;' + '&lt;/a&gt;');

Your field is a list/record type field. So it is not storing the Text Value it is storing internalid. you If you want to be able to search on text; 1. Add a hidden custom field of type free-form text, 2. Create either a workflow or a client script to copy the text value (nlapiGetFieldText) of custentity_sales_type whenever…

I did have a scheduled script run for several days and then just inexplicably stop working. It still looked the same. Status was scheduled. But no results and no logging. I opened a case with support but while waiting for an answer I created a script record and new deployment. it is worked. The original Script record and…

They do match. Can you post the entire function?

Looking at this again with your latest comment, I don't see any tests of the values in CC to ensure that are real addresses or at least formatted like real addresses. Perhaps var addr = contact.getFieldValue('email'); if (addr.match( /(@+..+)/i;).length &gt; 1 ){ carbonCopy[j++]=addr; } using this method you know two…

According to the help, the event does not fire on select field or check box fields. Do I that case it would not log the names for those.

ok, After reading this code a little more carefully, I have several questions, 1st -- since this appears not to be the entire function is it hard to tell what is going wrong - Can you post or send me the the entire script? 2nd -- what type of script is this? Client Script, User Event? Scheduled? 3rd -- in this line if…

lynale, What is your question about this script? please describe the problem you are having or the expected result of this script? Thanks, --Disregards this post, I see the questions in the comments now!

ok not positive here but I might have put an extra character in try removing the ; after /i. I am not an expert at RegEx but the semi colon feels out of place. Sean

two things I see in this script the could be an issue, 1. You need a null check to ensure that you actually loaded a record into the var contact before you try to get the value of the custom field Before var contact = nlapiLoadRecord('contact',rec.getLineItemValue('co ntactroles','contact',i)); //Add contact to the Carbon…

funny, I did the same thing I was telling you to correct. I did not test that there was a value in addr before trying to use it. So you could do it the way you found. I assume that will work though I don't actually know or you could do this; for(i = 1; i&lt;=count;i++){ var contact =…

the fact that you are dealing with peoples financial records and possibly Credit Card data makes this type of feature (or even the possibility of it) very undesirable, Your best bet if you need to access someones login is to simply change the password and send them a new one. Sean

it is very frustrating when you are looking for the internal id for a built in field but simply cannot find it in the documentmentation because it is either undocumentented or the field name veries based on context. a trick I have found for figuring out what the actual internal id for built in fields is, Add a client…

Interesting thought silverriaz, I don't know if this will work or not. The immediate potential issue I see with that approach is if multiple quotes are created for the same Opportunity. Which one will be updating custom field? Could they both? Will that work?

I think you are going to have to use Script. When you convert the Quote to a SO you want to also change the status of the Opp is that correct? Changing the status of the Opportunity when you Create the Quote can be done via SuiteFlow. However, to get back to the Opportunity record from the Quote when you Process it to a…

Hi, I am sorry but I don't understand your request. Could you please explain your request with some more detail?

Try If ((sf_countryid == 57 || sf_countryid == 61). &&. sfrec == 0){ }