michoel

You can do this in a template with the 'replace' builtin, e.g. [CODE]${record.field?replace('%', '')?replace('-','')}[/CODE] Sorry I have to ask. I've limited trial-and-error time on this and have to throw it out here. There is nothing to apologise for, that's what this forum is for :D

in Removing/adding in the characters "-" and/or "%" from incoming text in a PDF/HTM Comment by michoel Jan 12, 2016 5:27PM

Hmm, seems like the 'createdfrom.trandate' field is actually a string, so you do want the '?date' builtin to convert it to date. Though your mistake was trying to put the date format you wanted to output, while ?date requires the date format of the input string. The following should work: [CODE]…

in Accessing QUOTE # from an Invoice PDF/HTML Template Comment by michoel Jan 18, 2016 6:48PM

Try using ${record@title} instead.

in Advanced PDF/HTML Templates Title Property Comment by michoel Nov 12, 2015 6:10PM

The way I ensure consistent rounding of all fields is to first convert all fields to a number and then format with FTL: [PHP]<#function toNumber val> <#if val?has_content && val?length gt 0 > <#return val?html?replace('[^0-9.]','','r')?number > <#else> <#return 0 > </#if> </#function>…

in Rounding in Advanced PDF/HTML Comment by michoel Oct 26, 2015 11:37PM

The 'date' builtin actually does the opposite of what you are trying (converts a string to date, not date to string) Try: [CODE]<td>${record.createdfrom.trandate?string('mm/dd/yyyy')</td>[/CODE] You can also set this globally for the template: [CODE]<#setting date_format = 'mm/dd/yyyy'>[/CODE]

in Accessing QUOTE # from an Invoice PDF/HTML Template Comment by michoel Jan 17, 2016 5:37PM

You could do: [CODE]<td>${record.createdfrom.createdfrom?replace('Quote #','')?replace('Devis #', '')}</td>[/CODE] Or using a regular expression, this might be cleaner (untested): [CODE]<td>${record.createdfrom.createdfrom?replace('^.+ #', '', 'r')}</td>[/CODE]

in Accessing QUOTE # from an Invoice PDF/HTML Template Comment by michoel Jan 12, 2016 5:21PM

This is quite straightforward to do in a Workflow using the 'Set Field Mandatory' action, and using conditions to control when this should be triggered.

in Dynamic required fields Comment by michoel Oct 22, 2015 7:10PM

On a general note is there either a full schema list for the advanced printing templates (other than the add fields button in WYSIWYG which seems to have lots of values not applicable to the specific record you are on) or anyway to print all the information in an object, eg equivalent of console.log record ? Try opening a…

in Advanced Printing - Packing Slip - Tracking Numbers Comment by michoel Oct 7, 2015 1:40AM

Try: [CODE]${item.rate?html?replace('$','')}[/CODE]

in $ express sign in Advanced PDF/HTML template Comment by michoel Jul 17, 2015 1:44AM

I'm guessing that as you are not selecting 'Store Value' on the entity custom field, it is not available for sourcing in the transaction custom field. In any event, you can source this directly in the transaction custom field using the formula {entity.id}. If you want this to be shown on new unsaved sales orders as well,…

in Custom field on sales order to source customer internal ID Comment by michoel Aug 3, 2015 10:19PM

Hi Biggio, That's probably because you need to "double escape" the backslash - try: [CODE]${item.amount?html?replace("^\\w+\\$","","r")}[/CODE] http://stackoverflow.com/questions/20394713/how-to-use-regular-expressions-b-w-in-freemarker

in $ express sign in Advanced PDF/HTML template Comment by michoel Jul 19, 2015 10:02PM

You can do this with Advanced PDF/HTML Forms using the <pbr/> tag.

in Add 2nd or 3rd Page in PDF Layout Template Comment by michoel Mar 6, 2016 5:17PM

They have probably just renamed one of the standard entity types. Have a look under "Setup -> Company -> Rename Records/Transactions".

in Entity Type = Sales Partner Rep Comment by michoel Sep 2, 2015 7:49PM

You can do this by checking the 'Global Search' checkbox on the custom field. For more info, see the help topic 'Including Custom Fields in Global Search'. We use the built-in 'otherrefnum' field to store the customer's purchase order number, which by default comes up in global search. Are you already using this field for…

in Search for custbody form Comment by michoel Jan 19, 2016 5:20PM

Have a look at the Audience tab of the Script Deployment record.

in form.addButton() adds a button that is only seen by employees signed in as a specific role? How to Comment by michoel Jun 19, 2018 8:36PM

One big thing that held me back using SS2.0 was lack of IDE autocomplete ("IntelliSense"). I've since used started using TypeScript with https://github.com/headintheclouddev/typings-suitescript-2.0 which works really nicely, but I've heard from other devs that they would rather not introduce another tool/layer to their…

in Why haven't you switched to SuiteScript 2.0 ? Comment by michoel Jan 1, 2018 9:15PM

A suitelet that's available without login sounds like a good approach. I would advise adding a custom field to Purchase Orders that is populated with a randomly generated verification token to prevent url tampering. Yes, you can retrieve parameters from the URL the same you would retrieve POST'ed ones.

in Approvals through emails Comment by michoel Nov 23, 2017 5:34PM

There is no supported way to do that. You could technically manipulate the DOM yourself in a script, but it's not recommended.

in Is it possible to add a custom summary field under transaction Summary section? Comment by michoel Sep 11, 2017 8:59PM

You could replace the native alert by modifying the window.alert() function, though this approach is by no means recommended. var nativeAlert = window.alert; window.alert = function() { if (arguments[0] === 'No Match.') { var result; do { result = confirm('No Match. Click Cancel to continue.') } while (result); } else {…

in Custom Message for Scanning Wrong Item in Item Fulfillment Comment by michoel Aug 14, 2017 7:29PM

Here's what we use - works for Australia :-) // https://usergroup.netsuite.com/users/forum/platform-areas/customization/suitescript-custom-code/342881-transaction-custom-address-script-doesn-t-work record.setFieldValue('shipaddresslist',-2); var shipaddr = record.createSubrecord('shippingaddress');…

in Custom Shipping Address not getting set on Sales Order Comment by michoel Jul 6, 2017 9:47PM

Including an iframe will delay the onload event of the parent page. You could try one of the techniques listed in the link below to defer loading the iframe until the main page done. http://www.aaronpeters.nl/blog/iframe-loading-techniques-performance?%3E

in Data loading in iframe causing slow down? Comment by michoel Jun 19, 2017 7:55PM

Have you tried added the file as a library to your Script Record?

in Replacing jQuery UI Comment by michoel Jun 1, 2017 8:48PM

Another option for SS1.0 is to use the undocumented internal Netsuite function showAlertBox() in your client side code. showAlertBox('alert_duplicate_record', 'Warning - This record may have duplicate', 'This record may have duplicates.', NLAlertDialog.TYPE_HIGH_PRIORITY);

in Adding banner (notice) to top of record Comment by michoel Apr 4, 2017 7:22PM

The status of the SO is always pending approval when I inspect it via the debugger This is probably your issue. Have you tried approving the Sales Order before transforming it?

in Transform salesorder into cashsale Comment by michoel May 3, 2017 9:41PM

Looks good to me! I've had to do something similar before, but I needed the total of unapplied deposits. Here's what I came up with: function checkUnappliedDepositsOnSalesOrder(salesorder) { var unappliedDeposits = 0; var filters = [ new nlobjSearchFilter('type', null, 'anyof', 'CustDep'), new nlobjSearchFilter('status',…

in Detecting total deposits on a SalesOrder Comment by michoel Mar 21, 2017 7:48PM

Here is an example of doing something like this with DataTables for pagination mos_product_search.js [CODE]/** * Suitelet to make searching for stock codes really easy * * Script Type: Suitelet * */ function getItems() { var columns = ['internalid', 'itemid', 'salesdescription', 'baseprice', 'lastpurchaseprice',…

in Showing Bulk data on suitelet Comment by michoel Apr 3, 2017 7:25PM

Use the orderstatus field. Here are the codes. (A-H) david.smith I am curious why you would prefer that? The statusref field is more readable, and it's documented in the Records Browser?

in Detecting if a SalesOrder can be billed Comment by michoel Mar 22, 2017 1:17AM

I ran across another method that seems like it would be bit cleaner. There's an "amountunbilled" field on the SalesOrder that should work. This code snippet seems to be working fairly well. Any reason why this approach wouldn't work? I forgot about that search field, that's probably the best way.

in Detecting if a SalesOrder can be billed Comment by michoel Mar 26, 2017 6:42PM

A standard alert box in JavaScript cannot include a clickable hyperlink. You have a couple of other options: 1) You can use the new SS2.0 N/ui/dialog module to create a popup box with HTML require(['N/ui/dialog'], function(dialog) { dialog.alert({ title: "Click on the link", message: "<a href='" +…

in Create hyperlink in an alert box Comment by michoel Mar 16, 2017 2:14AM

The issue I'm running into is it's possible for some accounts to be configured to bill before shipping, so pendingFulfillment status does not give me a guarantee that the SalesOrder was not billed. You won't catch cases where the Sales Order was only partially billed before fulfillment (you are just checking for the…

in Detecting if a SalesOrder can be billed Comment by michoel Mar 22, 2017 1:13AM

MFA for Oracle Community

michoel Red Ribbon

Comments