In this we will know how to create a promotional discount using custom reward point for 100 points $1 discount and if for $1 purchase will add 1 will be added to your reward points Create a Custom entity field for the reward points under the custom tab in customer record In customer record at… Continue reading Promotional discount using using custom reward points in checkout box
Month: April 2023
Map in JavaScript
In JavaScript, a Map is a built-in object that allows you to store key-value pairs, similar to an object. However, a Map offers some additional functionality that makes it useful in certain situations. Here’s an example of creating a Map: To add a key-value pair to the Map, you can use the set() method: You… Continue reading Map in JavaScript
Set in JavaScript
In JavaScript, a Set is a collection of unique values of any type, which means that each value can occur only once in the Set. It can be used to store a collection of values without any duplication. To create a Set in JavaScript, we use the Set() constructor or the Set literal notation by… Continue reading Set in JavaScript
How to set transaction body field to sales order form in netsuite
This topic concern about creating a Transaction Body Field and set that value to sales order form Login to NetSuite. Go to Customization > Lists, Records, Fields > Transaction Body Fields > New and enter the Label and select Sale. Click “Applies To” and select the wanted section where you want to apply this value to(Purchase, sales). Under the Save option click Save & Apply to forms. After this is done, the custom… Continue reading How to set transaction body field to sales order form in netsuite
Cost Benefit Analysis
A cost-benefit analysis is a process of comparing the projected or estimated costs and benefits (or opportunities) associated with a project decision to determine whether it makes sense from a business perspective. Generally speaking, cost-benefit analysis involves tallying up all costs of a project or decision and subtracting that amount from the total projected benefits of the… Continue reading Cost Benefit Analysis
Human Capital Management
Human Capital Management (HCM) helps companies acquire, develop, manage, and optimize their workforces. It helps create an environment that maximizes workforce potential by implementing a set of processes and policies around hiring, managing, and employee development. Workforce Analytics- It is about measuring the behaviors of employees, leaders, and candidates and using resulting insights to make… Continue reading Human Capital Management
Saved search to calculate time elapsed from system notes
MAX(CASE WHEN {systemnotes.field} LIKE ‘Problem Order’ AND {systemnotes.newvalue} = ‘T’ THEN {systemnotes.date} END) – MAX(CASE WHEN {systemnotes.field} LIKE ‘Problem Order’ AND {systemnotes.newvalue} = ‘F’ THEN {systemnotes.date} END)
Saved search operation to find the latest data based on the date
To find the latest data of a field for standard and custom records, use the following formula in a saved search MAX({field_id}) KEEP(DENSE_RANK LAST ORDER BY {date field_id} )
Average daily balance calculation
In NetSuite, we calculate the average daily balance of an Entity based on the following conditions. Find the opening balance of the entity from which average daily fund balance has to be calculated. Use the opening balance to find the balance for 1st day. Use another saved search to finf the transactions made in the… Continue reading Average daily balance calculation
Key Performance Indicator saved search conditions
In order to create custom KPIs a saved search must be built with the necessary filters and result columns The saved search should have the required date filter added in the available filter section such that the date are compared for days, months and years. The results must be grouped with the sum, average or… Continue reading Key Performance Indicator saved search conditions