Author: Karishma Krishnadas

Navigate to Setup > Accounting > Customized Fulfillment email and modify accordingly Disable Use Web Site Template for Fulfillment Emails Navigate to Setup > Accounting > Accounting Preferences Under Order Management tab > Fulfillment section If this option is marked, it will use the Email Template on the setup below: Navigate to Commerce > Websites > Websites List > Edit the Website Under Email tab Order Emails sublist > Order Fulfilled section To test the template, follow steps below: Edit an existing Customer record with… Continue reading customize Item Fulfillment email preview.

This information refers to SuiteCommerce and the Kilimanjaro release of SuiteCommerce Advanced and later. With Commerce and Site Builder web store extensions, users can change their registered email address in the My Account application on the Profile Information page: To change the email address in Commerce web stores, users can go to Home > My… Continue reading Change Email Address

Navigate to Lists > Search > Saved Searches > New Click Customer Search Title: Enter Title Example: Customers with Balances Over 90 Days Click Criteria Click Standard Filter: Select Inactive Inactive: Select No Click Set Click Summary Summary Type: Select Sum Field: Select Formula (Currency)  Formula: Enter Case When substr({transaction.amount},1,1) = ‘-‘ and (NVL({transaction.daysoverdue}, Round({today}-{transaction.trandate}, 0))) > 90 then ({transaction.amountremaining}*-1) When substr({transaction.amount},1,1) <> ‘-‘ and (NVL({transaction.daysoverdue}, Round({today}-{transaction.trandate}, 0))) > 90 then {transaction.amountremaining} else 0 end Formula (Currency): Select not equal to … Continue reading Saved Search Shows Customers with Balances Over 90 Days

Navigate to Lists > Search > Saved Searches > New 2. Select Transactions  3. Search Title: Enter Title   Example: Purchase Orders with no applying Transactions 4. Click Criteria 5. Click Standard 6. Filters: Select Due Date/Receive By 1. Date/Receive By: Select before 2. Date/Receive By: Select Start of this week 3. Click Set Select Type 1. Type: Select any of 2. Select Invoice 3. Click Set Select Main Line 1. Main Line: Select Yes 2. Click Set Select Customer/Project Fields… 1. Customer/Project Field: Select Overdue Balance 2. Overdue Balance: Select greater than 3. Value:… Continue reading Automatic Reminder for Overdue Balances

We can start by creating a random ID – and worry about it being unique later. // short random string for ids – not guaranteed to be unique const randomId = function(length = 6) {  return Math.random().toString(36).substring(2, length+2); }; The function works by creating a random number (Math.random()), which gives us a decimal number between… Continue reading Create a random ID with JavaScript (of custom length!)

SuiteQL queries include references to record types and fields. For example, the following SuiteQL string queries for entityid field values that are included in employee records:      SELECT employee.entityid AS entityidRAW FROM employee  Using the SuiteAnalytics Workbook UI You can use the SuiteAnalytics Workbook UI to find record type and field names. SuiteAnalytics Workbook uses the… Continue reading Finding Record Type and Field Names in suiteQL

You can use SuiteQL to query your NetSuite data using the N/query module in SuiteScript. The following object and methods are available in the N/query module to work with SuiteQL: The query.SuiteQL object represents a SuiteQL query. It includes properties that represent the query type, the SuiteQL string representation of the query, result columns to return from… Continue reading Using SuiteQL with the N/query Module in SuiteScript

To set up a team quota: Go to Forecast > Setup > Establish Quotas. Select the year for this quota. In the Rep field, select the supervisor of the sales team for this quota. If this quota is for an item, department, class, or location, select the corresponding data. If you use NetSuite OneWorld, select the subsidiary associated… Continue reading Team Quotas

To establish quotas: Go to Forecast > Setup > Establish Quotas. In the Rep field, select the sales rep for whom you want to set up quotas. For an employee to show in this list, go to the employee record at Lists > Employees > Employees. Click Edit, and then on the Human Resources subtab, check the Sales Rep box. When you select a… Continue reading Establishing a Quota

Click the Sandbox and Release Preview Email Preferences tab to set preferences for the routing of email messages from your sandbox and release preview accounts. Important: You should choose the Send Email To option for both the Sandbox and Release Preview accounts. There are exceptions to the email routing rules you specify. Security-sensitive email will be always sent to the… Continue reading Sandbox and Release Preview Email Preferences