Karishma Krishnadas – Page 7

Function to get the length of the parameters and convert the string to hex value

function getLength ( lengthparam ) { try { let length = lengthparam.length let orgLength = Number( length ) / 2 let hexString = orgLength.toString( 16 ) if ( hexString.length < 2 ) { hexString = “0” + hexString; } return hexString } catch ( e ) { log.error( “error@getLength”, e ) } }

Quantity invoiced does not match Quantity fulfilled

We can solve the problem of “manually creating an invoice for a sales order, it adds the entire SO quantity, not the shipped quantity” using the standard way of NetSuite Go through the Navigation Setup -> Accounting -> Accounting Preference Uncheck the “Show Unfulfilled Items on Invoices “ and “Invoice in Advance of Fulfillment “checkboxes… Continue reading Quantity invoiced does not match Quantity fulfilled

Calculate Number of Business Days between Two Dates

Item Location Configuration search

// search for item location configuration using itemid and get the supplytype of the location function itemLocConfigSearch(itemId){ try { let supplytypeItemobj = {}; let itemSearch = search.create({ type: record.Type.ITEM_LOCATION_CONFIGURATION, filters: [ [‘item’, ‘is’, itemId] ], columns: [ search.createColumn({name: “supplytype”, label: “Supply Type”}) ] }); let searchResultCount = itemSearch.runPaged(); searchResultCount.pageRanges.forEach(function (pageRange) { let myPage = searchResultCount.fetch({… Continue reading Item Location Configuration search

UTM Parameter

The use of UTM parameters has completely transformed today’s online marketing strategies. You can easily see where you are gaining your traffic just by using the right parameters. For example, if you have an outstanding landing page on your website, you can measure the exact source of the traffic such as the name of the specific campaign or even… Continue reading UTM Parameter

Split URL String to get each parameter value in the JavaScript

function splitData(){ try { var value=”journreference=123line=A&destination=China&operator=Belbo&departure=104″; // split the string with these characters var parts = value.split(/[#\?&]/g); // find the piece with the key “destination” var filteredParts = parts.filter(function (part) { return part.split(‘=’)[0] === ‘destination’; }); // split the value and key, and grab the value [1] if (filteredParts) { var splitValue = filteredParts[0].split(‘=’)[1]; }… Continue reading Split URL String to get each parameter value in the JavaScript

User Keeps on Getting an Alert when Time under the Alerts tab is Removed from Home > Set Preferences

Under Home > Set Preferences > Alerts tab > Time were already removed under First Selection, Second Selection and Third Selection fields, but the user is still receiving the alert. This setting is role-specific, which means that if the user has multiple roles, the time has to be removed on each role to stop the alert. Steps:1. Log in to NetSuite.2. Click View all roles.3. Log in to role #… Continue reading User Keeps on Getting an Alert when Time under the Alerts tab is Removed from Home > Set Preferences

Email template for overdue invoice

<#assign customerPassed=”#customer”>Hello ${customerPassed}, <#assign invoiceid=”#invoiceDATA”><#assign dataPassed=”#DATA”><#assign totalPassed=”#TOTALDATA”><#assign invoicePassed=”#subject”><#assign duePassed=”#pastDue”>Thank you for your continued business with OX Tools USA!Your invoice ${invoicePassed} is past due by ${duePassed} days, please pay your invoice immediately! The total amount of the order is $${totalPassed}, and it has been open for ${dataPassed} days. We’re excited to announce a… Continue reading Email template for overdue invoice

Saved Search to Display Customers without Sales starting a Specific Date

Customer would like to create a Saved Search for Customers that have no Sale Transaction starting a specific Date. You may include also the column for Total Sales before the Date. For example: Date is May 1, 2013 1. Navigate to Lists> Search> Saved Searches> New> Customer.2. Criteria tab> Summary subtab–Sum | Formula ( Numeric) | is 0 | Formula: Case When {transaction.trandate} <= TO_DATE(’05/01/2013′, ‘MM/DD/YYYY’) then 0 else 1 end3. Results tab> Columns subtab–Name | Group–Formula Date| Formula:… Continue reading Saved Search to Display Customers without Sales starting a Specific Date

Email Template for automated sales order approval for the approvers who do not have access to the NetSuite.