Author: Lakshmi priya Suresh

Adding a new column in Item table using Basic PDF Template.

Schenario: Need to add one more column in item table in Sales order print. Let the additional column that needs to be added be ‘Location’ and the Salesorder form use the basic pdf option for printing purposes. Solution: Initially, need to find out the custom form that the salesorder is using, then need to navigate… Continue reading Adding a new column in Item table using Basic PDF Template.

Removing the Currency Symbol Printed Using Advanced PDF HTML Templates

If There is a requirement to remove the Currency Symbol printed using Advanced PDF/HTML Templates for Currency type fields without converting to 2 decimal places, add the following code to the value you need to remove the symbol. ?string?replace(‘[^\.,0-9]’,”,’r’) Example: ${item.rate?string?replace(‘[^\.,0-9]’,”,’r’)} Note: The additional code removes all non-numeric characters except ‘.’ and ‘,’. Add characters  within the… Continue reading Removing the Currency Symbol Printed Using Advanced PDF HTML Templates

Search to get inventory details of Lot Numbered Inventory Items

/** * function to search inventory details of lot numbered inventory items */ function invtDetailSearch(itemArray) { //An array of lot numbered item is passed as argument to this function. try { var searchResultArray = []; var JJ_invtDetailSearch = search.create({ type: “inventorydetail”, filters: [ [“item.internalid”, “anyof”, itemArray], “AND”, [“expirationdate”, “after”, “today”], “AND”, [“itemcount”, “greaterthan”, “0”], “AND”,… Continue reading Search to get inventory details of Lot Numbered Inventory Items

Calculating Subtotal amount for transaction saved searches:

Subtotal of a transaction record cannot be retrieved by using it’s internal Id, instead we need to use a formula. In a transaction saved search, add all required values in criteria tab and result tab.For subtotal, add either of formulas shown below: Formula = {amount} – nvl({taxtotal},0) – nvl({shippingamount},0)Label = Subtotal Alternative for Formula (Currency):… Continue reading Calculating Subtotal amount for transaction saved searches:

Adding Fonts in Advanced PDF Templates

Get the Font File: Download the .ttf file of the required Font Store the Font File: Upload all needed versions of the .ttf files (Regular, Bold, Italic, Bold-Italic, etc.) to Netsuite File Cabinet. Make sure that the “Available Without Login” check box is checked. Get the URL of the file. Reference the Font File: Code up… Continue reading Adding Fonts in Advanced PDF Templates

Adrenalin-Netsuite Employee Integration : Solution

Requirement: Neutrinos needs to integrate the Master Data Employees from Adrenalin to Netsuite. Also would like to migrate existing employee records from Adrenalin to NetSuite. Prerequisites: Token based Authentication(TBA)  is considered here as Authentication type. So, need to set TBA( refer http://jobinandjismi.in/setting-up-netsuite-token-based-authentication-tba/ ) We will provide the consumer key, consumer secret, token ID, token secret,… Continue reading Adrenalin-Netsuite Employee Integration : Solution

Setting Up Netsuite Token Based Authentication (TBA)

Token-based authentication is a protocol that generates encrypted security tokens. It enables users to verify their identity to websites, which then generates a unique encrypted authentication token. To use Token Based Authentication (TBA), the following things need to be done first: Enable Token-Based Authentication Create Integration record Create a Role and assign it to a… Continue reading Setting Up Netsuite Token Based Authentication (TBA)