The CASE statement should probably look like this: CASE WHEN {pricing.pricelevel} = "Market Price" THEN {pricing.unitprice} ELSE 0 END

MAX({emailfield}) would just return the maximum alphabetically sorted email address without taking dates into consideration. I think the easiest way to do this would be to have a Saved Customer Search output all customers and their last logged message, which you could then export to CSV/Excel and filter there. This is…

If you want to go the regex route, something like this should work: [CODE]REGEXP_REPLACE( REPLACE(NS_CONCAT({communicationcontact.firstname}), ',', ', '), '^(.+), ([^,]+)$', '\1 & \2' )[/CODE]

You could theoretically do this with Applied to Transaction Fields.. Applied to Transaction However, I am not sure that this is what you are actually after. While a Credit Note if often applied to (i.e. used as payment for) the same Invoice which it relates to, this is not always the case. If the original Invoice had been…

We have a selection of description items that the people creating the RAs are supposed to use to explain the reason for return. there are 7 description items in all. I can get the criteria to find the return auths. If it's not too late to change, a better option might be to create a custom field with a list of return…

You can do this as follows: Filter - Formula (Numeric) Description - is between 4054 and 4068 Formula - TO_NUMBER({zipcode})

Why not set up a workflow or saved search to send you an email every time a new case is created? Otherwise, I don't believe there is any way of scripting a standard Netsuite list but you could look into displaying it in an iframe of a Suitelet, or perhaps inject Javascript using a browser extension.

Make sure that you have made the file in your File Cabinet 'Available Without Login'.

Even when you are not able to uncheck the 'Show' Checkbox, you can often (but in my experience, no always) hide the column in the UI by removing all the text from the 'Label' field.

FYI, you can simplify your formula using the NVL() function {amount} - {shippingamount} - NVL({taxamount},0)

It looks like Amount (Net of Tax) ('netamountnotax') provides the subtotal amount. With regards to the issue of the rendering a formula with XML templates, this should work as long as you only have one (of each type of) formula column in the search. Alternatively, you could include the individual columns in your search…

Thanks Alex and Eric. I ended up extracting the data in SuiteScript and using a Javascript library to filter out the outliers. https://github.com/alyssaq/stats-analysis

Alex, did you ever come up with a good solution for this? I am looking at doing something similar.

We do this. You don't need a custom field, just freemarker directly in the email template. Good <#if false><b><i>{</#if><#assign hour = .now?string['HH']?number><#if hour lt 12>morning<#if false> / </#if><#elseif hour lt 18>afternoon<#if false> /…

Here's an updated version with a couple more improvements: 1) Works in View mode 2) Works on all sublist types, not just the Item sublist 3) Doesn't add extra space if the sublist is shorter than the screen height [CODE]// ==UserScript== // @name NetSuite Floating Headers // @version 0.2 // @description Float item sublist…

I've done this via scripting before - by deploying a Before Load User Event script to the Message record which can then manipulate the form.

So I've improved this a bit using a different floating headers technique so that the columns match up properly and horizontal scrolling works too [CODE] // ==UserScript== // @name NetSuite Floating Headers // @version 0.1 // @description Float item sublist header on scroll // @match https://*.netsuite.com/* // grant none…

Is there a way to execute javascript on the view part of a form? I don't see how its done. You would do this by creating a User Event script with a beforeLoad event, and then call form.setScript();

Thanks, I got it working. alert(nlapiGetLineItemCount('item')); returns -1 on the view, is some some other function I should use on the view part? In view mode you would have to load the record first: var record = nlapiLoadRecord(nlapiGetRecordType(), nlapiGetRecordId()); alert(record.getLineItemCount('item'));

Try <#if record.shipmethod.internalid == 1231231>

I believe that preference is for standard forms, not Advanced PDF/HTML templates. mushrush You will run into trouble having a footer for only the last page of a template, as this is not supported by BFO.

Weird, this works fine when I try it.. What type of custom field are you using? Also, I've had trouble with the CASE (expr) WHEN (comparison_expr).. syntax. I've found CASE WHEN (expr) works more consistently.

How do you plan to handle this if the tax rate varies on different lines? If you just want to retrieve the tax rate of the first line item, you should be able to do something like ${record.item?first.taxrate1}.

Thanks :), let me know how you go..

If the custom field was created after the Sales Order was saved, the value may be null, not true or false, so it may just work to default to unchecked. Also, I've come across some inconsistencies in Netsuite/Freemarker where checkboxes are sometimes boolean and sometimes 'T' or 'F'. For example, I have some code that is…

Try using the Freemarker default value operator: http://freemarker.org/docs/dgui_template_exp.html#dgui_template_exp_missing_default

I'm pretty sure the only way to do this is with a custom field. Set 'Store Value' = F, and on the forms it is used in remove all the text from the Label (but leave 'Show' checked) to hide it in the UI.

First of all create a Custom Entity Field called 'Approved Vendor' with the Type 'Check Box'. Then your custom dropdown field should be configured as follows: Type - List/Record List/Record - Vendor Sourcing & Filtering > Filter Using: Approved Vendor, Is Checked

Interesting, sounds like a Netsuite bug to me. Have you changed the name of the record under Setup > Company > Rename Transactions/Records? What is your hesitation in hardcoding it in the PDF?

Try: [CODE]<td>${record.createdfrom.createdfrom?replace('Quote #','')}</td>[/CODE] The documentation for the templating engine that NetSuite uses for generating Advanced PDF/HTML documents is available here: http://freemarker.incubator.apache.org/docs/index.html