When NetSuite incorrectly creates an Expense account for a Tax Control Account, manually create a new Tax Control Account. NetSuite will then correctly generate an Other Current Asset…
To correct 'Subaccount of' assignments on the NetSuite Chart of Accounts, the field must first be programmatically set to NULL. Following this initial update, a subsequent programmatic update…
To correct an incorrect company name on NetSuite PDF forms, navigate to Setup > Company > Printing & Fax Preferences. Locate and uncheck the 'Use Location Address on…
In NetSuite, project custom fields are classified as 'entity fields' rather than 'CRM fields'. This distinction is vital for administrators when creating, locating, or managing custom fields associated…
If components on a NetSuite Sales Order are not displaying correctly or storing their associated values as expected, the most direct solution is to remove the affected item…
When custom check layouts do not print correctly, the issue often stems from an incorrect vertical print offset. Users must adjust this offset in NetSuite preferences to compensate…
To count only unique values in a NetSuite Saved Search summary formula field, prepend the 'distinct' keyword directly before the field name within the formula. This ensures that…
To count records in a NetSuite saved search using a summary type, create a new Formula (Numeric) field. Set its Summary Type to Max. In the Formula field,…
To create a Gross Margin % KPI in NetSuite, define a transaction saved search filtering for Income and Cost of Goods Sold account types. Use a formula to…
To add a custom print link, create a saved search with a Formula (HTML) column containing a URL that includes a custom parameter. Then, create an Inline HTML…
To filter NetSuite records for dates starting next week and extending for a specified period, use a SQL "between" clause. Set the start date as TRUNC(sysdate, 'iw')+7 to…
When creating a hyperlink field with dynamic references using `{}` in NetSuite, the system may incorrectly mark it as a formula. To resolve this, save the field, then…