3941951 Newbie

Glad to hear you were able to streamline your solution using Suitelets and thanks for the suggestions. Some comments on your suggestions: #1 - Please enter an enhancement for this per the other thread #2 thru #5 seem like general enhancements to search so I would enter enhancements for those as well. #6 - Did you see my…

The default routing engine doesn't support this sort of routing. You can define criteria that identify incoming help desk cases but you can't define routing criteria for routing cases to the employee's supervisor. I would recommend using SuiteScript to implement this solution. Thanks, Yang

Issue 127735 has been entered and resolved for this problem. It will be released in the next emergency release. Thanks for bringing it to our attention. As a workaround try disabling Campaign Test Cells under Setup > Marketing Preferences if that's not a feature you use extensively. Thanks, Yang

There is a Print/Email/Fax preference ("Letter Template Folder") that lets you specify the default folder in your file cabinet under which all letter templates are stored. Did you upload your document into a location under this folder? Thanks, Yang

This feature (Enhanced Campaign unsubscriptions) is already in the works for our Q2 release next year. Thanks, Yang

That is correct. For non journal entries, you can reliably get the total amount of the transaction by looking at the amount column in the transaction_lines row with transaction_line_id = 0. Thanks, Yang

This is possible using SuiteScript. You can define a user event trigger to execute whenever a custom record, invoice (or any record type for that matter) is created, viewed, edited, or deleted. Check out the customization -> SuiteScript section for examples on how to do this. Thanks, Yang

I am not sure about the entirety of the use case you are describing but generally speaking if you want to see information about entries in a select field you would define another custom field (typically non-stored since it's informational only) whose value was sourced from a field on the record being displayed in the…

Should be doable via Customer Search. Something like the following should return the customers who bought the item but haven't done so in the last 30 days and the most recent transaction date: 1 - Add customer name (or Internal ID) column (summary type=GROUP) 2 - Add joined transaction:transaction date column (summary…

Try using CASE when IF {custrecord_physorder_due_date} IS NULL THEN 'it is null' ELSE 'it is not null' END Thanks, Yang

Steve, Should work. Just make sure you use a valid date filter operator (documented in the SuiteScript reference guide): For example: filters[1] - new nlobjSearchFilter('recordenddate',null,'on','daysfromnow90'); Thanks, Yang

How did you create this sublist? Thanks, Yang

You could try using a Numeric formula filter: something like "TO_NUMBER({SUBSTR(zipcode,1,3)})" and then your criterion would be between 160 and 168 for example. Thanks, Yang

Ooops! I didn't reference the field properly (I forgot the curly braces). Try this instead: TO_NUMBER(SUBSTR({zipcode},1,3)) Thanks, Yang

inventorynumber records are not yet supported. We added support for serializedinventoryitem and lotnumberedinventoryitem records in 2008 release 1. One thing you could try doing is performing an item (or any item subtype) search and joining in inventorynumber fields. The search join to use would be inventoryNumber. This…

Steve, Could you post the snippet of code you are using to read the itemid joined column as well as the name (entity should work as well) column? Thanks, Yang

Now could you try calling results[0].getAllColumns(). This should return all the nlobjColumn objects returned in the search. For each one you could try calling: results[0].getValue(col.getName(), col.getJoin(), col.getSummary()) with col being a reference to each nlobjColumn object. Thanks, Yang

Steve, Excellent idea! Expose enterprise views in SuiteScript. Please enter an enhancement for this so that it's priority gets bumped up. Thanks, Yang

Unfortunately there is not a search join from the "Event" search to the company/contact fields. There is a search join from the "Event" search to the attendee entity records but that may not apply if the customer you set as the company for this event is not an attendee. For now the only thing you can do is add the company…

You could hide the messages subtab on the customer page and then publish a custom sublist unto the customer page in it's stead. Of course you would lose all email messaging and mail merge functionality if you did that. Edit: The easiest solution would be to define a preferred search to use for the messages sublist. Thanks,…

It would be a message search and you can only create it by customizing the saved search used on the messages sublist. Thanks, Yang

There is a past thread on this that you should find useful: https://usergroup.netsuite.com/users/showthread.php?t=7567&highlight=systemnotes Thanks, Yang

Try using the following search filter: new nlobjSearchFilter('internalid', null, 'anyof', foretag); Notes: I assume foretag is not null in this case. If so you would need to guard against that error condition. Finally, it would be a lot easier to implement this using the nlapiLookupField function: var _rabatt =…

Files/documents are not a supported scriptable type (yet). Having said that, there are a number of options available to you as of version 2007.0.5. If you do a lookup on a document custom field and specify that you want the display names you will get the name of the document custom field. Doing the same thing for an image…

Hmmm.... This capability isn't yet supported out of the box but perhaps you could try to do something clever with a numeric formula filter such as: (case when {oldvalue}={newvale} then 0 else 1 end). You would then add this filter using the "Equal to" operator value and 1 as an operand. Good luck and please enter an…

Assuming it's an inventory item, this should work: var record = nlapiLoadRecord('inventoryitem',id) var totalvalue = record.getFieldValue('totalvalue') or you could search for it using nlapiSearchRecord(xxx) Thanks, Yang

Time of Day fields are for tracking a particular time in a day (i.e. 6:00 pm or 18:00 if you prefer military time). If you are trying to track time in hours then you should probably use either an integer or a float field and provide a maximum value of 50 and perhaps also a minimum of 0. Thanks, Yang

The built-in "Field" list has a field you can source from called "Field ID" which contains the scriptable ID for that field. Can you try using that? One way to use it would be to always source it unto a non-stored hidden field in whichever page you are using it in. Thanks, Yang

Did you try using {id}? Thanks, Yang

Why? Did it not work after all? Thanks, Yang