Neil Elliott Red Ribbon

When I've pulled item details I've used a for loop using the item as the object and the field as the property such : <#if (record.item?size > 0)> <#list record.item as item> ${item.item} ${item.quantity} ${item.description} ${item.rate} ${item.amount} </#list> </#if> Maybe the same approach would work for you.

One thing to note with the above approach, try and ensure the inlinehtml field is added to the form as late as possible otherwise fields you may be trying to access may not be available to the code.

I don't have this installed or know anything much about it but since installing Windows 10 at home found some apps would not "work", i.e. flash up then disappear, unless I force them to "run as administrator". I thought I'd throw this in to the conversation since there seems to be no real answer right now, apologies if…

If I've understood your first question correctly, you should be able to source your custom fields content through the "Sourcing & Filtering" section of the custom field creation. Choose Company or Contact in the "Source List" and "Phone" in the "Source From" Hope that helps.

If you search the forum for Advanced Print / BFO / FreeMarker you should find a variety of interesting posts dealing with issues that you may well come up against using FreeMarker. Other than that, without a specififc question, the best resource I can point you to when working with FreeMarker is this :…

A custom "transaction column field" is used on a sublist not on the main body of a record for that you would want a "transaction body field" The before submit functionality would kick in just before you save the record. You would, I believe, have already navigated away from the currently selected line so I don't think that…

My misunderstanding of course, I mistook the "tabs" as being that not sublists! If I get 5 I'll have a think on this for you.

Yeah, I just tried the same thing, what are you defining the field as? I used "Decimal Number"? See the screens I attached

Maybe try: [CODE]${record.discounttotal}?keep_before_last("'")${record.discounttotal}?keep_after_last("'")[/CODE] I haven't tried this but according to the freemarker Built-Ins for strings that should in theory give you : -105,50€ I don't think you need "?string" You may find this useful:…

You might be better off, since you want to apply logic to this, using a script, maybe a client post sourcing function or maybe a user event before submit / before load, depending on when you're expecting the field to populate. Maybe try: CASE WHEN {total}&gt; 110000.00 THEN ({total} * .02029) WHEN {total}&lt; 110000.00…

Not really addressing your question directly but is there a reason you don't do this directly in the template? I'm thinking something like this (I appreciate this is items on the record currently in scope and may not be what you're looking for): [CODE]<#if (record.item?size > 0)> <table class="padded-table"…

I wonder if this would work: &lt;#if record.billcountry!="US" && !record.amountremaining&gt; So long as your amount remaining is not a string value of "0", !record.amountremaining would return true if it was 0; Kinda daft anyway you look at it but advanced print / pdf coding is always a "challenge".

Thanks for the response. In fact it was resolved in a less complex (in other words "code free") fashion. A custom role was introduced that was assigned to the users at a particular site and the form was linked to the role.

You could have a new form as suggested but if the first form has returned the user a reference allow the user to enter that reference, their email address and notes. (the reference could be set by your code initially and act like an externalid to the customrecord). When they submit the new form, perform a search for the…

Sometimes the template tag templ_aaaaa is "lost" from the template and sometimes the macro tag gets "lost" from the macros. To restore them, open up the file with it's missing tag via the file cabinet in edit mode. You'll see a text field labelled Tags. For Macros it's a piece of cake as you just type in "macro", for…

Thank you for replying. Unfortunately since it's close to 2 months since I requested the information I've moved on from this project but it's still useful to know.

"that line" I mentioned because it looks like there's potential for it to return false and stop your form submitting. Yes/ No? Barking up the wrong tree? :) I was suggesting you put in some debug code in that section to double check that's not happening. Good luck. Neil

You might want to add some alerts / console.log code in to the checkmandatory319 function to see what is happening in there. The submit for the form is dependent on the return from checkmandatory319 being true as I read it. I suspect this line : if (!validate_field(amt, 'poscurrency', true, false, null, null, true, null))…

This doesn't address your issue directly but maybe employing showAlertBox would be better than an alert and potentially break your loop. showAlertBox("myelement_id","You did bad things","stop entering rubbish",0,"","","","") Parameters below a = id of ui element, (whatever you want). b = Title c = Message d = severity - 0…

Any reason you would say that? The governance on a mass update is such that you're extremely unlikely to run out of governance. It's allocated on a per record basis. From the NS Help : "The SuiteScript governance limit is 1000 units per record/ invocation of a mass update script."

If it's something you can schedule you might also consider a mass update script. Not sure if this would meet your needs but I thought I'd throw it out there for you to consider.

If you're working with a Scheduled Script you should look at something on the lines of this: if (nlapiGetContext().getRemainingUsage() &lt; 50) { nlapiYieldScript(); } If you're not using a Scheduled Script maybe look to move the bulk of your code into one and calling that SS from your script. You'll probably appreciate an…

You don't have to set the recovery point but if you do be aware "nlapiSetRecoveryPoint API consumes 100 units per call." so make sure you have the governance before you set it :)

Where did you see that "dateFormat"was a method you could use on a NetSuite DateObject? I only ask because I don't believe it is... but the documentation is so out of date and unreliable that I may be wrong! Go to the help system and search on Date APIs. Normally you supply the format at the time you convert a string to…

So don't use nlapiFormatCurrency format the string values as per my instruction.! Process each value in turn, keep it simple then inject the values in to your layout string So: <em>layout += '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'+a…

The value is a string not a number type evident by the "," in the value so... You could strip the commas and float the value and that would give you something close and then use toFixed. presuming your input value is "10,000", this would work: var x= "10,000"; x =x.replace(/,/g,''); var b = parseFloat(x); var Y =…

Just a heads up but I think you will find including commas in the string will break nlapiFormatCurrency.

What quantity do you believe you are setting? There is no Quantity on an SO / IF / RA / CR on the main body of a record that you can see or set. Take a look at the Records Browser. You cannot initialise the quantity at item line level directly in the transformation. You can set the main body Location in that way. You would…

If you search " SSS_INVALID_HOST_CERT" in the NetSuite help you'd find a fairly descriptive explanation in the very first search result.

If I'm understanding you correctly I think I've done something similar myself in the past. In the first instance, you can add filters to a saved search at the time you run it so there's no problem filtering on the internal id. something like: var search = nlapiLoadSearch('location', 'customsearch_my_saved_search');…