Ben G Red Ribbon

thanks yang, i'd made a silly error which was stopping it. works fine now! a small issue: in the UI, the sysnotes uses the field label from the specific form in use; in the script output, the field labels are taken from the field names specified in the field setup records - i would prefer to have the form's field names in…

there's a switch in setup / customisation / address form

there doens't seem to be the field 'lastpurchaseprice' available for noninventory items - the code looking for it is filters[0] = new nlobjSearchFilter('isinactive',null,'is','F'); columns[0] = new nlobjSearchColumn('lastpurchaseprice'); results = nlapiSearchRecord('noninventoryitem',null,filters,columns); this returns…

scott - many thanks, that works well. note - you can also round to 2dp with this profit = Math.round(profit*100)/100

i'm not clear whether you're using the same form or reloading with the approp form. for the former approach, there is info in this forum about dynamically hiding and showing fields. See these posts for useful info https://usergroup.netsuite.com/users/showthread.php?t=5314…

hi yang, as scott says this depends on the porate field. i've set up a script that updates inventory items' "cost" field with the "lastpurchaseprice" field, which makes sure the profit figure is reasonably current, but i can't do the same for noninventory items - is there any way to access lastpurchaseprice for them?…

doing just that at the moment. Try using custom forms: - create an item form with everything removed (as far as you can) except the customform field. rename that field 'choose type'. make this form the preferred form - create more item forms for each templated type of item. tune each form with the appropriate fields. use…

If you were to all the NS Integration team, you would hear a recorded message warning that they are "fixing a bunch of broken operators". That's our warning, I guess. luckily for them - and other users here - we try to fix things ourselves first ;0

i tried var recordCreated = nlapiCreateRecord('customrecord27'); but it gave an error at that step (before trying to submit the record): INVALID_RECORD_TYPE -- or did you mean something else? ben

yang, that's great, once again you save the day thanks ben

hi yang, they return the expected id numbers of the records. i've tried hard-coding the numbers into setFieldValue both as numbers and strings ('665') but i get the java error in both cases. if i change the field to freetext it works fine, when i change the field back to list/record it breaks.

hi yang, this is the code (i've raised case 576191 for this - more info there) var recordCreated = nlapiCreateRecord('customrecord_sales_log'); recordCreated.setFieldValue('custrecord_sl_customer', record.getId()); recordCreated.setFieldValue('custrecord_sl_sales_rep', record.getFieldValue('salesrep'));…

todd, that's working fine now - thanks ben

nick, at the moment the script just adds attention & addressee data so that the addrtext field becomes usable in mailmerges. we'll probably add some more code to de-capitalise etc soon - PM me and i'll send you something later on i tried your &# stuff but it didn't work. replacing \n with <br> works on addrtext to stop the…

thanks, saved search is working would be useful to be able to see all the issues for a new release, not just the ones i've already raised cases for - this wd save time when you start to hit a problem and don't know whether it's you or the system

thanks - that works fine -ben

hi yang, for those of us on 2007.0, pls could you post the syntax for accessing custom list values from server scripts? thnaks ben

that explains it, thanks yang. i've submitted a case and will post the ref here later... ben

similarly (i'm really not trying to hijack the thread - it seems closely related), i wanted to give contacts access to their customer account when each new contact is created (we are an IT support company and our customers' staff use netsuite to log problem cases) i got stuck trying to get a server script, triggered by…

Steve, the contactroles is a list of items on the customer record. You can access fields in this way e.g. companyRecord.getLineItemValue('contactroles','email',j) but ONLY for contacts that have access already. Contacts without access aren't visible... so you can't use the code to give them access. I have a case open to…

steve - here you go Case # 539126: "Suitescript: list of contacts with access on a customer record"

hi noknok - on a customer record, on the 'access' tab, is a list of the customer's contacts where you can assign access to each one individually - a great feature, but a lot of admin with our larger customers. (you can also set a single customer-level access on that page.) I'm hoping we can automate access so that creating…

thanks yang - i'm having a problem seeing all the lines of contactroles there should be a contactroles sublist available whenever you load an existing lead, customer, for instance on a customer with 109 contacts the script sees only 29 lines. any idea what's going on here? thanks ben

i can't get this search filter to work - filters[1] = new nlobjSearchFilter('date',null,'within','previousoneweek',null) but this does work filters[1] = new nlobjSearchFilter('date',null,'onorafter','daysago7',null) yang, any idea why?

Hi Mark, here's an example from a client-side script if (confirm('This will submit this case - OK?') == true){ // do some stuff here NLMultiButton_doAction('multibutton_submitter','submitedit') } note that "su bmitedit" should be "submitedit"... something odd in the display of this post

try these which hook into the function that the save button uses NLMultiButton('multibutton_submitter', 'submitter') NLMultiButton_doAction('multibutton_submitter','submitter') the function names vary with different pages - look at the html source for the page to see what the buttons are using... rgds ben

try clicking the default value button on the field mapping screen in the csv import wizard - that might yield clues as to what data it's expecting

jim, as per earlier post - you can do this with a single import operation

elham - this is now issue 125474. looks like it might be something to do with the UK version of netsuite. thanks, ben

I was able to use gladstone's recommendation of creating an independent ID that maps leads and contacts and import without any problems. Thanks. great. i've now broken mine by trying to import 8000 leads and contacts together - it's been stuck on "Processing 0%" for 18 hours...