Thanks for that EJinDenver I've been wondering how to do this as well

Another way to post back some client code from a suitelet such as an alert() call is to call nlobjResponse.write( _CLIENT_CODE_) passing in some client code as the parameter var _client_code = "<script type='text/javascript'>" + "alert('Hello n' + 'Again')" + "</script>";" response.write( _client_code);

There is a remaining snag, but it may not be the scheduled script! This is the debug error message: Error: SSS_MISSING_REQD_ARGUMENT type What type of script is this you're running? User event? if so your main method needs to look like function _FUNCTION-NAME_(type) { //code } so that the execution context is exposed (even…

To do this you need to reference the column you want to pull the value from using getAllColumns() var swritebestseller = nlapiSearchRecord('inventoryitem', 'customsearch1177'); if(swritebestseller) { var thirty_day_sales_column; for(var i = 0; i<swritebestseller.length; i++) { var columns =…

Oh cool, thanks for this tip - will store it for the future

Oh great thanks for that Here's a direct link to the voting form: https://system.netsuite.com/app/site/hosting/scriptlet.nl?script=customscript_enh_vote_suitelet&deploy=customdeploy_enh_vote_suitelet&l=T&issue=2797447

have you tried 'storedetaileddescription'?

Not to do with RESTlets but we have a similar workflow of storing SO data in a SQL db then each day pushing these into Netsuite - not as many as 1000 - maybe 500 or so We built a C# application over the SOAP web service to do this, so it's possible if you use SOAP

Note: JS code - php code block used for colour coding // filter var filters = new Array(); filters[0] = new nlobjSearchFilter('custrecord_mto_project', null, 'is', stProjectId); nlapiLogExecution('DEBUG', 'Fill Filter', 'Fill Filter'); // return column type, total amount var columns = new Array(); columns[0] = new…

Should be possible: using the ids of the custom records and sublist you can pass data around e.g. if customrecord_A has sublist 'customsublist_B' then you can script a fieldchange function in customrecord_A's entry form to do nlapiSearchRecord('customrecord_c', null, null, null) and return the results Loop through the…

Yes as Olivier has said for example: var currentContext = nlapiGetContext(); /* **Make sure this is not being triggered in SUITELET mode ***/ if (currentContext.getExecutionContext() != 'suitelet') { /* update support cases*/ }

JavaScript & jQuery: The Missing Manual by David Sawyer McFarland is just a great js/jquery read Teaches you javascript and glides into jquery before you've even realised it

Great thanks for the pointer - have found this preference and it's unchecked but you've given me another idea to play with!

oh awesome - I've gotten stuck in the past when needing an OR operator in a searchfilter - this will do just nicely!

@khultquist I really like anything that gives automatic response to users' input based on their decisions - nice, thanks for that

That's great thanks Frederic After RobertLCratch's reply it made me realise I may have to set each line item to fulfil - you've just showed me how :) Michael

As a start-off, here's my useful 'Search-builder' function I always find writing searches long-winded and repetitive so I've attempted to make it less awkward function searchBuild(recordType, fils, cols) { //takes a record type id, array of filter arrays and array of column arrays //returns a searchresultobject var filters…

mhson1978 has a great netsuite examples site http://www.codeboxllc.com/ksc/ You'll find a ton of library code there including my own submission: How to process multiple requests in a single suitelet

Hi DDewar I'm glad you like this Code Swap Shop idea! The best way to implement these functions is to : Create a new file called simply 'Netsuite_Library.js' - Paste the posted code snippets - save and Upload the file into your Netsuite file cabinet (suitescripts folder) - You don't need to create a script record for it,…

robj.name = rslt[i].getValue(_row.getAllColumns()[0].getName(),_row.getAllColumns()[0].getJoin()); This seems to work really well when you create Complex Saved Search to be used on your script. @mhson1978 great, thanks for highlighting that api and showing how to quickly dig right into your defined search columns! I'd love…

@Delaineyr oh nice - I've been wanting to explore nlobjFile and the file apis more - thanks for that

@ironside I like it - especially (perhaps incorrectly) I can see prototyping with js objects derived from ns method calls - customising the ns api to some extent, nifty!

eric.mushrushs script on the thread how to send the value from suitelet to client script appears to give me a good idea as to how to implement this i.e. pass parameters from a form to a suitelet, do suitelet processing (making item selections here), then return with values to the form Michael

Yeah it's a really useful api :-) You might be interested to know that you can set parameters for a pdf layout in the xml declaration such as: var XMLHEADER = '<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report"…

Brilliant! Go PDF :) Michael

Yes if you declare this in your header it should work <!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd"> Michael

Ah OK thanks for that Michael

That sounds great Olivier! Just wondering - can that mechanism be applied to web scripting? Say for building '3 for the price of 2' or 'buy these three products and get this one free' offers? Thanks! Michael

Hi Olivier thanks for that, yes originally I had a for loop but when that didn't work I decided to force the first line to execute (hence do while) to make sure something was happening Just kept it as a do while from there! Thanks again Michael

No it's a client button - user selects value from drop down then hits a button to trigger the function