khultquist Red Ribbon

We are adding some chromeOS shared computers (conference rooms, common areas). I am envisioning a meeting room full of 20 people, all looking at the projector, and NS is asking me who was the first girl or boy I kissed.

Check out the same discussion in these threads https://usergroup.netsuite.com/users/showthread.php?t=21536 https://usergroup.netsuite.com/users/showthread.php?t=27049

There are email forwarding services that forward emails to multiple addresses like pobox.com

You can access with ODBC.

use Formula (Numeric), something like this: CASE WHEN {field1}={field2} THEN 1 ELSE 0 END And then you can filter based on the result Equal to 0

You have to purchase the ODBC package from NetSuite, it's a few $k per year. Once you have it you can download the driver and access most tables through ODBC connections (eg through excel or access).

Hi Steve - I'll share with you what we do. We scan packing slips during receiving, and pick tickets after fulfilling. In both cases the worker is initialing the paperwork so it becomes an important record. But I found that the scanned documents are rarely accessed, and we were spending a lot of time organizing them by…

Note sure what an 'error to fill description' is... did you put your field names into the formula? Copy/paste your exact formula here.

We use One World, I would not want to try and do separate account statements from locations. I'm not sure how all the GL postings would even work, I think you should trust your judgement.

A couple of thoughts: 1. You could hide the email button/link on the form, and then add a button via script if the status = approved. Kind of messy though... 2. What if you create a saved search, with email alert, with criteria of: >message not equal to blank >status equal to pending approval and alert the user and their…

The only thing I can come up with is kind of ugly and a lot of work, but it would work: 1. create a custom field on the record, such as 'Original Date Created' 2. Have it default to blank 3. Immediately after you merge, run a script/mass update to sync 'Date Created' and 'Original Date Created' 4. New records, when merged…

You could create a scheduled saved search, based on the end date of the contract, for example search for contracts that expire 30 days from today. And then have the saved search generate an email to the customer with a link to renewal.

That page in the account center usually shows 0% used for me, then once in a while is shows some percentage... For me it's not reliable, anyone else?

You should be able to access this from the sublist 'itemvendor' and retrieve the values from 'purchaseprice' https://system.netsuite.com/help/hel...ntoryitem.html

Here's a snippet of live code from a scheduled script, adding a new sublist line record.selectNewLineItem('item'); record.setCurrentLineItemValue('item', 'item', item); record.setCurrentLineItemValue('item', 'quantity', qty); record.commitLineItem('item'); If for some reason you can't add to your Item sublist via user…

It's odd that 'Assembly/Bill of Material' items are not available choice for client scripts. I confirmed in my account. Just curious, why can't this be a user event script? I've created plenty of user event scripts that add/edit/delete sublist lines. For evaluating 'Non-Inventory' items, try checking the 'subtype'…

In your script you are using two different ways to get the id [INDENT]var recid = itmRec.id; and var itemid = itmRec.getValue({fieldId: 'itemid' });[/INDENT] I suspect the first one works but not the second one, is that right? I use a Chrome Extension called NetSuite Field Explorer that is really helpful for finding the…

what about using itmRec.itemid instead function onclick_ViewImage() { var itmRec = currentRecord.get(); var recid = itmRec.id; var rectype = itmRec.type; var itemid = <strong>itmRec.itemid;</strong> ... more code here }

I like the idea of custom record, that's the cleanest, plus it's available for your future scripts.

This ended up being more work that I expected, but I did get it working. Because contacts can only be removed with record.detach (or SS1 nlapiDetachRecord), you must have a saved record to work with, so the very earliest chance to work with a saved record is an aftersubmit user event (since an unsaved, new record won't…

savethepennies leacelosacolumna I ran into the exact same issue, and was able to create a summary search and custom field on the opp record that uses this field... thanks for the great suggestion! However, I don't see the "buttons on the form to 'Remove All' or 'Clear All Lines'", I only have a 'Remove' link on each line,…

Thanks leacelosacolumna I'll build a script to do that. samzad thank you for the suggestion, but I am trying to remove the contacts from the opportunity when viewing the opportunity, not while viewing search results.

Two ways to handle it: 1. in your results loop, add a condition that the nlapiGetContext().getRemainingUsage() > some value that will prevent partial execution. Then schedule the script to run again. This works if a record is removed from your search results after being edited by the script. 2. use nlapiSetRecoveryPoint()…

Did you try workOrder.selectNewLine() instead of workOrder.selectLine() -- I edited my last post, not sure if you saw it. Since line 0 doesn't exist, you may not be able to select it.

Right, sorry about that. That should say workOrder.setSublistValue(), but in re-reading your post you already tried that. Selecting lineitems/sublists server side has caused my scripts to crash, but that's not the problem you're having. Here's another thought, is kind of a long shot... try removing the extra sublist lines…

I would try using workOrder.setLineItemValue(group, name, linenum, value) instead of workOrder.setCurrentSublistValue()

np... I haven't thought this out all the way but here's how I would attempt it: [LIST] [*]add a custom field to vendor records (and maybe other entity records) [*]put a value in this field, a key, generated by some function of all the contacts attached to this record (eg the product of the internalids of all contacts,…

The user event will trigger anytime that the record is saved. Like j.j says, the linking of records doesn't trigger a user event, because the record is not saved. If you really need this, you should be able to discover changes with a scheduled script that looks for changes in attachments/detachments. The script would run…

Nope, you cannot change the Field Display Type in a client script, only in a user event script. Consider using a Validate Field function for the dependent fields. You can build the same logic but it behaves a little differently in the UI.

I don't know if this is possible, but I'll tell you that we struggle with temporary and permanent price changes as well. We've found that the best way to update prices is to export all price levels/items to a csv file, modify them as needed, then import it. It's a few steps but it works reliably.