1,941 results total
Browse the knowledge base by search, topic, audience, and difficulty.
Answer
Financial ratios can be calculated in NetSuite using KPI screens and saved searches. For complex ratios like EPS or Dividend Payout, statistical accounts may be required. Custom formulas…
Read answer→Answer
To calculate the fiscal year start date in a NetSuite saved search for a non-calendar fiscal year, use a custom formula. This formula dynamically determines the fiscal year's…
Read answer→Answer
To calculate Gross Profit Percentage in NetSuite, ensure all income and cost components are summed. The formula handles cases where income is zero to prevent division errors, returning…
Read answer→Answer
To calculate item weight with multiple units of measure in NetSuite, custom fields are used to capture item weight and unit, alongside transaction-level unit selections and conversion rates.…
Read answer→Answer
To calculate the months between a customer's last and second-to-last sale, use the MONTHS_BETWEEN function. This involves identifying the second-to-last transaction date using DENSE_RANK() partitioned by customer name…
Read answer→Answer
To calculate percentages of summarized columns in NetSuite saved searches, use SUM(CASE WHEN ... THEN {Amount} ELSE 0 END) constructs for both the numerator and denominator. This approach…
Read answer→Answer
To calculate rolling 12-month sales in NetSuite saved searches, use specific CASE WHEN formulas. These formulas evaluate transaction dates against a rolling 12-month window and sum the amount…
Read answer→Answer
To calculate the number of days in a month within NetSuite, apply the formula LAST_DAY({trandate}) - TRUNC({trandate},'MONTH')+1. This formula subtracts the first day of the month from the…
Read answer→Answer
To calculate the interval, create a Formula (Numeric) column in your saved search. Set the Summary Type to Maximum and use the formula `MAX({date}) - MIN({date})`. This will…
Read answer→Answer
While NetSuite's native Time-Off Management and Payroll features are the recommended approach for vacation accrual, a custom SQL formula in a saved search can be used for specific…
Read answer→Answer
To successfully call a NetSuite Suitelet from a server-side script using nlapiRequestURL, the Suitelet must be configured to be "Avaiblable without login". Failing to do so will result…
Read answer→Answer
Cancel a NetSuite contract mid-term by creating a Return Authorization (RMA) against the Sales Order, which initiates financial reversals. Prevent contract renewal using NetSuite's 'Cancel Contract' or 'Terminate…
Read answer→No answers match those filters.
We use only optional tools to measure site usage and manage HubSpot forms. You can accept, reject, or choose category by category.
Optional tools are off by default. You can change your choice at any time.
Always on. These only remember your consent choice and support site security. No analytics or marketing tool runs in this category.