1,012 results total
Browse NetSuite solutions for intermediate users, filtered by topic and audience.
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 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
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→Answer
To capture Purchase Request rejection reasons, create a custom record linked to the Purchase Request. A workflow action, ideally using custom scripting or actions for pre-rejection capture, prompts…
Read answer→Answer
To capture CyberSource payments in NetSuite when authorization occurs externally, enable "Allow Request ID to Meet Payment Card Field Requirements" in the CyberSource Profile. Ensure the external transaction_id…
Read answer→Answer
To capture email threads on NetSuite transactions via script, utilize the N/email.send SuiteScript 2.x API. Ensure the relatedRecords parameter correctly links the email to the transaction using transactionId,…
Read answer→Answer
To chain NetSuite User Event scripts, load the target script's logic as a library within the triggering User Event script. This enables the triggering script to manually apply…
Read answer→Answer
When a customer's currency needs changing with open transactions, NetSuite offers solutions. Options include deleting and re-entering transactions, creating a new customer record for the desired currency, or…
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.