Craig Haroldson Red Ribbon

Replace the "customlist_mylist" in the example with your list id. In this case it would be customlist_atlas_cust_type.

const results = nsQuery.runSuiteQL({ query: ` SELECT id, externalid, scriptid, name, isinactive FROM customlist_mylist `}).asMappedResults();

@PaulFleetwood Next place I'd look is any scripts or workflows that run "After Submit" that might be reloading/saving the item fulfillment.

Hi Paul, This error occurs when a record is modified by someone/something else while you are in edit mode and prior to you clicking Save. For example: You open an Item Fulfillment in edit mode. You start modifying the item fulfillment. Another user, integration, script, or workflow loads, modifies, and saves the same item…

nzaleski, I think you want vRecord.getFieldValue rather than vRecord.getField

Not sure if this will be a direct help or not, but may assist you on your path... View one of the custom records in the NetSuite UI. In your browser address bar, append &xml=T to the end of the URL. This should display your record in XML, including the field names. These aren't ALWAYS the names used in search…

Michael, thank you for this. This was the only thing that worked for me, as well.

Using filter expressions... var search = nlapiCreateSearch('transaction', [ ['mainline', 'is', 'T'], 'AND', ['type', 'anyof', ['CustInvc']], 'AND', [ ['sometextfield', 'startswith', 'This'], 'OR', [ ['sometextfield', 'startswith', 'That'], 'AND', ['sometextfield', 'contains', 'OtherThing'] ] ] ]);

Two options... combine them into one function (probably preferred in a scenario where you're performing data validation on submit); or create two separate script records/deployments. Combined... function saveSOCheck() { // Validate due date var despatchDueDateValue = nlapiGetFieldValue('custbody_despatch_due_date'); var…

I scoured the release notes for 2014.1 and 2013.2 yesterday and didn't find any mention. Is there another set of release notes for integrations that I missed?

nlapiSearchRecord requires a "saved search id" parameter. If you're not searching using a specific saved search, pass null. For example: var results = nlapiSearchRecord('salesorder', null, [ ['mainline', 'is', 'T'], 'AND', [ ['sometextfield', 'startswith', 'This'], 'OR', [ ['sometextfield', 'startswith', 'That'], 'AND',…

Well, I got it to work. This is undocumented, which typically means unsupported. Use at your own risk! var workOrderRecord = nlapiCreateRecord('workorder', { recordmode: 'dynamic', assemblyitem: bomId }); workOrderRecord.setFieldValue('location', '1'); workOrderRecord.setFieldValue('soid', soid);…

+1 I also need to be able to do this. :h_a_w:

var request = (HttpWebRequest)WebRequest.Create(settings.Url); // If you're behind a web proxy, specify that information here. //request.Proxy = new WebProxy("proxy", 8080); //request.Proxy.Credentials = CredentialCache.DefaultNetworkCredentials; string authHeader = String.Format("NLAuth nlauth_account={0},…

I just ran into this also. Did you ever get this to work?

Well, that wasn't too bad. My main content was wrapped in a <div>. Removed that and the <pbr/> worked fine.

QweryBuilder has been my tool of choice.

Hello Craig, I do not have experience with web services. Have you ticked 'available without login' for your script in File Cabinet? I am just thinking this should work. Srujana So, a quick update here. I checked "Available without login" and it worked. The User Event script ran. However, I then UNchecked it to make sure…

Use NVL() to test for NULL: CASE WHEN NVL({item.lastpurchaseprice},0) = 0 THEN 'Yes' ELSE 'No' END http://www.orafaq.com/wiki/NVL

The list views are the most annoying, debilitating part of the new UI. So much wasted space between fields and lines. Endless scrolling, both vertically and horizontally. Think about it... who opens up an Excel spreadsheet and says "This data I'm about to review needs more space. Let's increase the font size, column widths…

Yes, definitely. Clearing browser cache fixed it for some. However, we're also getting errors saving existing transactions in scheduled scripts.

We're seeing similar behavior. Did you get anywhere on this, Jeff? --- Craig

In SS1.0, we had nlapiDateToString and nlapiStringToDate. In SS2.0, we have the "format" module... format.format and format.parse.

FYI, I am a test engineer on the SuiteScript team and I will be looking into this issue. dmeng Any update on this? Running into the same issue and wrapping in try/catch works, but is certainly not elegant.

Last week I started a new topic. After I posted, I clicked on the "Subscribe" button. I never got any notifications when someone replied to that post. Forum issue or user issue? :) - Craig

Never mind... didn't realize there was a user setting for this. For anyone else wondering, it looks like my Notifications default to the Message Center on my forum user profile, as opposed to the email notifications I was expecting. - Craig

We're seeing a similar issue in both sandbox and production. $ sign replaced with foreign currency (mostly Euro) on PDF printouts.

Assigning the variable works fine, but the problem is in the comparison. NetSuite will not allow us to Save the template with the #if statement in it. When saving, it appears the HTML editor is validating the HTML. It sees the totalPages variable as a FreeMarker SimpleScalar type (since <totalpages/> has not been evaluated…