On the saved search record >Email >Customize Message >Summarized Results -Send within Message -Send as CSV -Send as Microsoft ® Excel -Send as PDF

You can schedule the saved search to email automatically with xls attachment.

I'm using Transfer Orders but have a $0 transfer price, which is what I want. When I fulfill, the Amount is $0 -- perfect. And there is a GL posting to the Inventories in Transit account -- working well. But now I'm trying to make a saved search to find that GL posting amount for each line in the transfer order. I cannot…

Just sends the new result (as the record is Created/Updated). Test it out by using your email address and then close some test orders. Saved searches are the way to go... very flexible and intuitive to set up.

There are some dynamic fields under the tab 'Recipients from Results', you should be able to find the address you need there. For my saved search I have this: Criteria Type is Purchase Order Status is Purchase Order:Closed Results Number Name Amount Email Send Email Alerts When Records are Created/Updated - Checked…

yes, you have to use nlapiMergeRecord

A client script would work. You could also use a check box instead of a button, and when the record is saved call a user event script. This way is a little more robust since it doesn't depend on the user's browser.

I did the same thing by a saved search email alert, works perfectly.

Can you just let javascript handle it, force an integer var QACurrentCount = parseInt(AssRec.getFieldValue('custrecord_ass_qa_counter'));

How is the work order being created? If it's from another user event script, it won't fire.

I'm not sure about why it's returning null. Different issue though is that you should let javascript handle the 1 hour differently. If your .getHours is 0 then you are trying to .setHours as -1, maybe a script error?

Should be do-able. You could do it as a user script or a client script -- the client script might be better because you could see the results before saving, and you can trigger on field change. First create a saved search with the results you need in columns. Then call that search in your script, and apply a filter of…

Most likely a problem with your conditional if statements. Try debugging with this: if (ticket[i].getText('field','systemnotes')== 'Printed Picking Ticket') { alert(ticket[i].getValue('newvalue','systemnotes') ); } If you get an alert, you will see the value. If you don't get an alert, then it's not finding that field.

To accomplish this same thing, I built a multi-level MRP application (excel/vba) that connects to NS with ODBC.

Thanks. I got it to work using nlapiLoadFile

for customer-specific forms check out this thread: https://usergroup.netsuite.com/users/showthread.php?t=28248&highlight=script+change+form and for invoice-only emails, read here: https://usergroup.netsuite.com/users/showthread.php?t=27049&highlight=invoice+email

Here's a simple little client script for Sales Orders, that checks the 'Ship Date' field for obvious problems. We key in most of our Sales Orders, and the Cust Service workers sometimes schedule a shipment in the past, or on a weekend, or too late in the day to ship. This script handles those 3 problems with a pop-up alert…

Try taxgroup or taxtype the full list of scriptable records is here: https://system.netsuite.com/help/helpcenter/en_US/RecordsBrowser/2010_2/index.html

You might be able to hide the default button, through NS or via script, and then replace it with a custom button that validates your fields and then calls the same function. My 'Bill' button shows: onclick="process_ord(**order_id**,'custinvc','');return false;"

No that won't work, beforesubmit fires after the user has clicked 'save', so unless you prevent it, changes will be written to the database. There's a lot more to this that the above portion of script, the timestamp logic needs to be written, the custom field added, and then tested thoroughly or you are going to have…

The way to do this is to abandon the idea that the record is 'locked' if a user is in 'Edit' mode. Instead, write a beforesubmit script that checks if the record has been saved since it has been loaded by the user.

You could use a custom timestamp field.

You'll have to load the current record again as an object, and compare the two timestamps, something like this. You'll want to actually prevent the record from being saved, I don't know the code to do that but it should be simple to find an example in the user group. function beforesubmit (type) { var current_record_type =…

Are you getting an error, or is it just not firing? I can't tell what's wrong, but if it's firing then you can narrow it down by running simplified code like this: function pageInit_getFieldTextTest() { var departId = nlapiGetFieldText('department'); alert(departId); } and see if your variable ever gets defined.

If NS coded it right, the timezone text should match this table http://en.wikipedia.org/wiki/Zone.tab and you could convert it to UTC

You have two problems with your nlapiDisableLineItemField line: [LIST] [*]it takes 3 arguments, you have 4. [*]it's only available in client scripts (your script appears to be a user event) [/LIST] [h=2]nlapiDisableLineItemField(type, fldnam, val)[/h] Sets the line item field of a sublist to disabled or enabled based on…

The 'T' should be 'true' nlapiDisableLineItemField(type, fldnam, val) Sets the given line item field of a sublist to disabled or enabled based on the value (true or false). Parameters type {string} [required] - The sublist internal ID (for example, use addressbook as the ID for the Address sublist). In the NetSuite Help…

What I meant was that it's not T or F, it's true or false. Your first post has 'T' as the argument, and NS help specifically says Important: The values for this parameter can be true or false, not T or F. So there must be something else wrong too, what kind of transaction is this?

There are a lot of ways to set it only once. 1. You could create a custom field (a checkbox) in the record that says it's been reset (in pseudocode) function pageinit() { if (checkbox <> 'T') { set email to blank set checkbox to true } } 2. Check email value against the customer record, if it's the same then reset it. This…

If amount is null then amount !=0.00, so that could be the problem. Can you post the actual criteria and/or results?