Use a checkbox to mark receipts that have been processed with the scheduled script. Then you can schedule your script to execute every 15 minutes, and it will handle any/all receipts that have an unmarked checkbox, and when process is complete mark the checkbox on those receipts. This way you don't have to trigger…

Hi Pat. Use this line var customform = nlapiGetFieldValue('customform');

I believe it's ISO and you have to run it through a conversion, you could create a library file from this table http://en.wikipedia.org/wiki/ISO_3166-1

A simple script would do it: aftersubmit user event where type = create. You could also do it with workflow.

Sure you could do that, you'd need a 'where used' type function. Also you should account for other ways that inventory changes, not just Sales (receipts, inventory adjustments, etc). The scheduled script wouldn't require the same types of triggers.

No, formula will not work. You need a script or maybe a workflow.

This is kind of like MRP, only without the work orders. I would do this by script, looping through the components. See this thread for MRP: https://usergroup.netsuite.com/users/showthread.php?t=34370

Hi Linda - This would be best to do it as a user event script, not a client script, which would only trigger through a user interface. If this is a body field (not a line field) then a really simple script would be like this function beforeSubmit(type){ var copy_from = nlapiGetFieldValue('***field_name_from***');…

Sure, here's a first step. You need to decide on the type of script to run -- probably "scheduled script", but might vary based on your business. The biggest downside with scheduled script is that you will have a delay between actual and shown value of QOH. The upside is that is runs in the background and will not show any…

I have a custom record and a whole lot of scripts that allow us to show the customer part number on all transactions. I've even set up a script so that Sales Orders can be created with the customer part number, since many of our customers send in POs with only their numbers shown.

You probably want to update only when blank, correct? var count = nlapiGetLineItemCount('item'); var dueDate = nlapiGetFieldValue('duedate'); for (var i =1; i<= count; i++){ nlapiSelectLineItem('item', i); var expectedreceiptdate = nlapiGetCurrentLineItemValue('item', 'expectedreceiptdate'); if (expectedreceiptdate !==…

Shelly- this scheduled script creates invoices for SO with statuses "Pending Billing/Partially Fulfilled" and "Pending Billing" // look for sales orders to be turned into invoices function transform_so(type) { // Run only when scheduled if(type == 'scheduled') { //Sales Order:Pending Billing/Partially Fulfilled =…

Is this what you are looking for? It's the undocumented list of internalid for item records (not all transactions) Assembly Description Discount DwnLdItem EndGroup GiftCert Group InvtPart Kit Markup NonInvtPart OthCharge Payment Service ShipItem Subtotal TaxGroup TaxItem…

If you go to your list of roles (View All Roles), each link has this format system.netsuite.com/app/login/dashboard.nl?id=123456&h=12abc123abc But the id and h values don't have any recognizable meaning to me

Can you post it once you are finished, it would be useful, I refer to this all the time: https://usergroup.netsuite.com/users/showthread.php?t=24788

You could hack a DIV on the parent page that dims/disables the page until the conditions are met.

Wiz - you should script/bundle that idea and sell it as a Permission Viewer.

Thanks nelliot, I'll try that, hopefully the 'type' in the custom field will show as 'Quote' and not 'Estimate' The reason I don't want to hard code this is that I'm trying to make a generic email template, like this: Dear <customer name> Thank you for choosing <our company>. Your <type> <tran id> is attached... blah blah…

A couple things to check.... Are the bins in location '1'? Are the bins active for that item? Also I would change the fromBinID and toBinID to a string fromBinID = request.getParameter("frombin").toString(),

Maybe you could use kits, where the kit is the obsolete number, and the member is the replacement. Another option that works well for internal use, but not on the store, is a custom record that lets you build a table of superseding parts. If you set 'Global Search' for the superseded part, your sales reps can get an easy…

Your best best is a script to step through the lines and add the total to a custom field.

Clay - you could upload the files (txt, csv) to a NS folder, and script it from there. That leaves you with just the manual task of uploading the file(s) to the file cabinet. If you wanted to fully automate it you could allow your vendors to upload through a suitelet, or with web services.

Is a sponsor similar to a customer, vendor, or partner? If so, you could add a check box to the record type. Or you could just set up a custom form for that record type.

you need to allow for null in the fields {shippingamount} becomes CASE WHEN {shippingamount} = null then 0 else {shippingamount} end I believe you can also use nullif()

You are adding the field inside an if {} And then trying to reference it after the related else (which is missing {}) So it doesn't exist, because the if condition was never met.

Like rudler said, go to your list of saved searches, check 'Show Inactives', then sort by the 'Last Run On' column. All you have to do to inactivate them is click the checkbox on each line and then submit for the page after they are all checked. If you figure it's 2 seconds to check a box, inactivating a thousand records…

kphu - I've been working on something similar, but haven't implemented it yet. An idea for your issue with the indefinite lock... it's not perfect but might be good enough. You would need to add two scripts: The first is a client script that limits how long the record can be open. For example, if you set a 30 minute limit,…

I would suggest a beforesubmit user event (as long as your average cost is stable). You also need to plug a few holes in the script -- what if taxcode is null, or the weight is 749.5. function beforeSubmit() { // calulate the min selling price // get field values var weight = nlapiGetFieldValue('weight'); var avgcost =…

Sounds like a syntax problem, maybe a missing ' or }

What type of field is it? text area, rich text, html, something else? Do you want it changed in view mode, or edit mode?