Author: Karishma Krishnadas

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

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

<#assign customerPassed=”#customer”>Hello ${customerPassed},<br /><br /><#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.<br /><br /><span style=”font-weight:bolder”>We’re excited to announce a… Continue reading Email template for overdue invoice

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

<style type=”text/css”>@media screen and (max-width: 450px) and (min-width: 330px){ #itemid{ table-layout:fixed; },#totalid{table-layout:fixed;} }</style><#assign approvar=”#name”><span style=”font-family:Arial;font-size:10pt”>Hello, ${approvar}!</span><br /><br /><#assign saleno=”#number”><#assign trandate=”#date”><#assign storename=”#store”><#assign tranamount=”#amount”><#assign storename2=”#store2″><#assign reject=”#reject”><#assign approve=”#approve”> <span style=”font-family:Arial;font-size:10pt”>Below are the details for OneSource #${transaction.tranid} that was created on ${transaction.trandate} by Store ${storename}.<br /><br />This Order will cause the Total Amount of Orders for this Month (for… Continue reading Email Template for automated sales order approval for the approvers who do not have access to the NetSuite.

var startDate = “23-SEP-2022”;startDate = new Date(startDate.replace(/-/g, “/”));var endDate = “”, noOfDaysToAdd = 2, count = 0;while(count < noOfDaysToAdd){endDate = new Date(startDate.setDate(startDate.getDate() + 1));if(endDate.getDay() != 0 && endDate.getDay() != 6){count++;}}

This can be done by adding a Formula(Numeric) that uses formula string shown below. REGEXP_SUBSTR({completeddate}-{date}, ‘[^ ]+’) Here are the steps:I. Create an activity saved search.1. Navigate to Lists > Search > Saved Searches > New.2. Click Activity.3. In the Criteria tab, set Status= is any of Completed, In Progress, Not Started4. In the Results tab, add Formula(Numeric) | REGEXP_SUBSTR({completeddate}-{date}, ‘[^ ]+’)5. Click Save & Run.This… Continue reading Activity Saved Search > Ability to get the number of days a task is opened