Thanks for the suggestion Evan - tried it and it still didn't move to the next line Anyway came up with a kludge but it's working...:cool: function changeDiscountLevel() { var itemcount = nlapiGetLineItemCount('item'); nlapiSelectLineItem('item',1); var i = 2; do { if(nlapiGetCurrentLineItemValue('item', 'price') !=…

@eric.mushrush I think this is the answer to my question here: Is it possible to execute a client script from a button on a form which returns results on a new 'Pop-up' window? Thanks! Michael

Is there a way to return the values generated in the suitelet back to the client side? So the workflow would be [LIST=1] [*]Push a button to open a suitelet [*]user selects values from e.g. a multiselect field in the suitelet, hits submit [*]these values are returned to a client form field (e.g. multi select field) [/LIST]…

This is awesome! You've really helped me out with my query here Is it possible to execute a client script from a button on a form which returns results on a new 'Pop-up' window? Thanks a lot! Michael

Brilliant thanks for the window.opener.nlapiSetFieldValue tip - I'll try that The thing about returning data then parsing it from response.write is that I need to use nlapiRequestURL in order to return a string value This way would be much nicer but how do I call nlapiRequestURL and display the suitelet page with…

That's done it - great thanks for your help on this *high five* I hit a stumbling block because I was trying to execute window.opener.nlapiSetFieldValues - since it was a multiselect field I was populating with an array of values It just wouldn't parse it - finally after checking in the chrome dev console I found that I…

Thanks for that - I've tried this but no luck - calling nlapiRequestURL causes the nlapiResolveURL and window popup code to be execute quickly making the popup window appear then disappear On the other hand using window.opener.nlapiSetFieldValues() seems to be the right way to go... ...except having that call in my code…

Oh I see what you're saying In that case you'll need a loop mechanism to read each row of the CSV file and generate a new promo record at each iteration with that row's data Like for(var i=; i<CSV_FILE.length; i++) { var promoCodeRecord = nlapiCreateRecord('promotioncode');…

Oh sorry, that was pseudocode and not intended for production - It will be easier just to stick to one method of importing - i.e. either using csv imports or building a script The CSV import route will be the easiest as @felix.guinet explained 1) Create a custom record that contains fields you want to import for…

Quote: promoCodeRecord.setFieldValue('custrecord_promotion_code', 'Promotion Code'); The Red Text is the Custom Record Field ID and the Blue is the Actual Name of the Custom Record Field and also this is also the Field Label in my CSV Test. using nlapiSetFieldValue(); the parameters are 1.field id 2.value to set So in this…

Ah so it was a WorldPay issue after all Thanks for this JPincas

Called Netsuite support and didn't get through for 12 minutes (option 1 on the IVR - "A/R, procurement" etc.) which was unusual - perhaps something major happened? Whilst talking to customer support I tried again to replicate what was happening and payment was processed succesfully We're back up and running now so I'm…

My last option would be to roll a fully customized solution that would do the merge in script and pull in the required data, but man that's a lot of work for this single requirement I have. If you do go with building a custom solution, we have built something similar: [LIST=1] [*]Create custom record type - Signature (to…

Thanks for that - yeah have been looking at the new checkout but the upheaval puts me off Needing to do implement this functionality might just be the push I need to go just go for it

Is it possible to make it work the other way around as well? So, if only that item is selected the order is free but any other items added will make the order calculate postage according to the shipping rate? (kind of overriding the free shipping)

Is it possible to combine this setting with scripted checkout? I only want specific customers (which I can denote with a custom checkbox), around 5, to be able pay later (invoice) but have around 100 with terms set

Thanks for testing that out @StephQ - one question - Existing customer who registered with Terms, no Credit Limit = Gets both Invoice Option and Credit Card - Existing customers with Terms and Credit Limit = Gets both Invoice Option and Credit Card Does this mean that either way, with or without a credit limit, Invoice and…

C# code (PHP code editor used for colouring) private NetSuiteService service; SalesOrder sales_order = new SalesOrder(); //TODO sales_order data e.g. sales_order.leadSource = ... //variable for the Sales Order Internal ID String so_internal_id = ""; SoapError so_error_exception = null; SoapError so_error = null; try {…

I once had this error when attempting to populate a field on a custom record The solution was to make sure the declaration for the netsuite web service schema was up to date (i.e. the latest version) - in C# project you update this by looking at web references in your solution (com.netsuite.webservices) and checking the…

That's really cool, thanks Mark!

Yeah I agree that's a really helpful answer Thanks!

@mmeyer highlighted that there is no ratio mechanism at the moment For example, when someone buys N quantity of product X, they get the discount on N number of item Y. The initial implementation does allow for discounting up to a max number of units, but it would make these promotions that much more flexible if we could…

Ah OK in that case yes there is a trick using Javascript's 'replace' method say you have var richText = nlapiGetFieldValue('RICHTEXTFIELD_DATA') you can execute richText = richText.replace(/&lt;br&gt;/g, "&lt;br/&gt;") So when ns strips the / from <br/> you simply regex search and replace it with the correct markup as a…

Yeah there are a few idiosyncrasies when parsing text using bfo pdf generator in nlapiXMLtoPDF Glad you got it working though!

To use nlapiXMLtoPDF you make sure that the xml conversion api is declared (I've assigned it to a variable): var XMLHEADER = '&lt;?xml version="1.0"?&gt;&lt;!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd"&gt;&lt;pdf&gt;&lt;head&gt;&lt;style&gt;&lt;/style&gt;&lt;/head&gt;&lt;body size="A4"…

Yes thanks Brett I have a declaration for a jquery library in our theme header now - @chrisp_68 you can do this too by going to Setup-->website-->themes, select your theme then in General add the declaration in 'Addition to <head>'

Yes if you place the jquery library in your file cabinet - like in the 'website hosting files-->live hosting files' folder you can then grab its url (by selecting 'edit') You can link to this url and update the library as and when you need Michael

You're welcome!

Ah I see - so it would be like a declaration 'pinned' to the head of each file you create I like that - *thumb up* I haven't come across any way to do that I'm afraid Michael

Yes as Olivier has explained the best way to do any scripting is with the standard Netsuite scripting platform Here is the basis of what to do: [LIST=1] [*]Create the javascript file you want to run which will include your api calls e.g. "var total = nlapiGetFieldValue('total');" [*]Upload it into the…