1,941 results total
Browse the knowledge base by search, topic, audience, and difficulty.
Answer
To compare non-ASCII characters in NetSuite saved searches, use the `ASCIISTR` function. This converts multi-byte characters into a comparable ASCII representation, enabling accurate comparisons. While `ASCII` only processes…
Read answer→Answer
To compare transaction amounts across two date ranges in a NetSuite saved search, use specific formula fields. These formulas calculate and display amounts for a current fiscal year-to-date…
Read answer→Answer
To concatenate and sort values in a NetSuite saved search, utilize the LISTAGG function. Specify the field containing the list, a separator, and use WITHIN GROUP (ORDER BY…
Read answer→Answer
To concatenate two fields in NetSuite, create a custom field and uncheck 'Store Value'. Set its 'Default Value' formula to {field1}||' '||{field2}. This configuration dynamically displays the combined…
Read answer→Answer
While Google Sheets offers native conditional formatting for entire rows, an alternative programmatic approach using Google Apps Script can provide more customized control. Implement a script with onEdit…
Read answer→Answer
To establish a house account for sales reporting in NetSuite, create a dummy employee record named 'House Account'. Enable the 'sales rep' flag on this record, but user…
Read answer→Answer
To enable unauthenticated AJAX access for a Suitelet, ensure its deployment is set to 'Released' and 'Available Without Login'. Crucially, configure the Audience tab by selecting 'Online Form…
Read answer→Answer
To prepare a NetSuite web store for testing, navigate to Commerce > Hosting > Domains. Specify the domain name, set the Domain Type to 'Web Store Only' or…
Read answer→Answer
Yes, a single payment gateway provider can be established in NetSuite to process transactions across multiple countries (e.g., US, UK, Philippines). Multiple payment gateway accounts can be configured…
Read answer→Answer
To access advanced email signature options in Gmail, navigate to Mail Settings. While older versions might have used 'Lab tabs' and specific 'gadgets', current Gmail integrates comprehensive signature…
Read answer→Answer
To filter data between NetSuite and NetSuite SuiteProjects Pro based on a custom field, declare the field using NS_FIELDS and NS_CUSTOM_FIELDS in your integration mapping. Then, define the…
Read answer→Answer
To make an item non-taxable in a specific state, configure the item's tax schedule. Within the tax schedule, define the tax application rules based on the state. Once…
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.